Hello Friends, here is the second set of Questions on Application Developers , more of general questions, i am not digging in particular areas , only trying to put question which i normally ask with candidates. If you want help in any specific areas , plz advise, i will try to do that.
Q11 ) What is SET-OF-BOOKS?
Collection of Chat of Accounts and Currency and Calendars is called SOB
Q12 ) What is the interface?
Interface Table is a table which is used as medium for transfer of data between two systems.
Q13 Tell me what is the procedure to develop an interface?
a. First we will get the Requirement document.
b. We will create control file based on that plot file.
c. Then the control files which loads the data into staging tables.
d. Through pl/sql programs we will mapping and validate the data and then dump into the interface tables.
e. Through the standard programs we will push the data from interface tables to Base tables.
Q14) What is multi org?
“Legal entity has more than one operating unit is called as multi org”
a) Business group — Human resources information is secured by Business group
b) Legal entity. — inter-company and fiscal/tax reporting.
c) Operating unit — secures AR, OE, AP, PA and PO Information.
d) Organizations — is a specialize unit of work at particular locations
Q15) What are the User PARAMETERS in the Reports?
Q16) FND USER EXITS:-
FND SRWINIT sets your profile option values, multiple organizations and allows Oracle Application Object Library user exits to detect that they have been called by an Oracle Reports program.
FND SRWEXIT ensures that all the memory allocated for AOL user exits have been freed up properly.
FND FLEXIDVAL are used to display flex field information like prompt, value etc
FND FLEXSQL these user exits allow you to use flex fields in your reports
FND FORMAT_CURRENCY is used to print currency in various formats by using formula column
Q17) what are the two parameters that are mandatory for pl/sql type concurrent program?
Procedure/function (ERRBUF OUT
ERRBUF :- Used to write the error message to log or request file.
RETCODE :- Populate log request file with program submission details info.
Q18.) What is Value Set?
–The value set is a collection (or) container of values.
–When ever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.
n If the list of values needed to be dynamic and ever changing and define a table based values set.
Q19) What r the validation types in Value Set?
1) None ——– validation is minimal.
2) Independent ——input must exist on previously defined list of values
3) Dependent ——input is checked against a subset of values based on a
3) Table —– input is checked against values in an application table
4) Special ——values set uses a flex field itself.
5) Pair —— two flex fields together specify a range of valid values.
6) Translatable independent —– input must exist on previously defined list
of values; translated values can be used.
7) Translatable dependent ——- input is checked against a subset of values
based on a prior values; translated value can be used.
Q20) Who information’s?
1) Created by
2) Creation date
3) Last _updated by
Thanks — Shivmohan Purohit
A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing your hardware capacity. Typically, a concurrent program is a long-running, data-intensive task, such as posting a journal or generating a report.
Reports and concurrent programs can be assembled into request groups and request sets.
o A request group is a collection of reports or concurrent programs. A System Administrator defines report groups in order to control user access to reports and concurrent programs. Only a System Administrator can create a request group.
o Request sets define run and print options, and possibly, parameter values, for a collection of reports or concurrent program. End users and System Administrators can define request sets. A System Administrator has request set privileges beyond those of an end user.
Standard Request Submission is an Oracle Applications feature that allows you to select and run all your reports and other concurrent programs from a single, standard form. The standard submission form is called Submit Request, although it can be customized to display a different title.
o The reports and concurrent programs that may be selected from the Submit Requests form belong to a request security group, which is a request group assigned to a responsibility.
o The reports and concurrent programs that may be selected from a customized Submit Request form belong to a request group that uses a code.
As System Administrator you can limit the number of requests that may be active (status of Running) for an individual user. This ensures that a user cannot monopolize the request queue. For example, if a user with an Active Request Limit of 5 submits 20 requests, only 5 requests will be run at the same time. The remaining requests will be run when the number of active requests for the user drops below 5. Use the Profile Options window to set the Concurrent: Active Request Limit profile. To set a global limit for all users, set this option at the site level. You can then modify limits for individual users by setting this profile option at the User level.
1. What are Oracle Alerts?
Oracle Alerts are used to monitor unusual or critical activity within a designated database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from tablespace sizing to activities associated with particular applications (i.e. AP, GL, FA). Alerts can be created to monitor a process in the database and to notify a specific individual of the status of the process.
2. What types of Oracle Alerts are there?
There are 2 types of alerts: Event Alerts and Periodic Alerts
a) EVENT ALERTS are triggered when an event or change is made to a table in the database.
b) PERIODIC ALERTS are activated on a scheduled basis to monitor database activities or changes.
3. What types of actions can be generated when an Alert is triggered?
When an alert is triggered or the event is true, the alert can Email, send or print a message. Alerts also have the ability to execute a SQL script to perform an action. Using Response Processing, Oracle Alerts can solicit a response from a specific individual and perform an action based on the response that it receives.
4. Can I build an Alert to run with my custom applications or tables?
Event or Periodic Alerts can work with any custom application, as long as the application is properly registered within the Oracle Applications package.
5. Which Email packages work with Alerts?
Oracle Alert is designed to work with Oracle Office, Oracle Interoffice, UNIX Sendmail, and VMS Mail.
6. Can Alerts be triggered by other Tools?
(i.e. other than Oracle Forms and concurrent programs)
Oracle Alerts can only be triggered from an application that has been registered in Oracle Applications. Alerts cannot be triggered via SQL updates or deletes to an Alert activated trigger.
7. What is Response Processing?
Response processing is a component of Alerts which allows the recipients of an alert to reply with a message and have the applications take some action based on the response. Response Processing only works with Oracle Mail products.
8. Do I need Oracle Applications to use Alerts?
Yes. Oracle Applications is required to create and run Alerts.
|Oracle A.I.M. Methodology – template lis||8,384|
|How to insert & character or special||7,527|
|Data flow for Order-to-Cash cycle||7,305|
|Oracle Reports (Report 6i) – Technical –||7,140|
|Oracle PL/SQL – Calculating Weekdays bet||5,501|
|Oracle Applications – Interview Question||5,007|
|Oracle Forms Development (Developer 2000||4,172|
|Accounts Payable Trial Balance – Reconci||3,902|
|Oracle General Ledger – Functional Inter||3,888|
|Form Personalization in Oracle Applicati||3,710|
|Oracle Payables Useful Tables||3,560|
|Useful AR Tables Informations||3,153|
|Oracle Purchasing – Purchase Order FAQ||2,934|
|How to use attachments in Oracle Applica||2,874|
|AutoInvoice Program Overview in Oracle A||2,806|
|Oracle Application – Top useful SQL Quer||2,676|
|Shell Script Tutorial for Oracle Applica||2,511|
|Oracle Forms Development (Developer 2000||2,414|
|Trace a Concurrent Request And Generate||2,351|
|Oracle Financials Accounting – Interview||2,266|
|How to generate a delimiter in spool out||2,246|
|Oracle Applications – FNDLOAD Utility||1,981|
|Oracle Technical Interview Questions and||1,964|
|Interview Questions for Oracle 11i Apps||1,927|
|Variable Input file handling in Oracle S||1,896|
|Oracle SQL / PLSQL Developer – Technical||1,862|
|FAQ on Oracle Workflow Background Engine||1,806|
|AR Interview Questions – Technical and F||1,798|
|Oracle Fixed Assets Useful Tables||1,779|
|Excel output directly from Oracle Applic||1,768|
|Oracle General Ledger – Tables||1,672|
|Setting your Oracle Applications session||1,670|
|UNIX / Shell Programming Basic – Beginne||1,612|
|Oracle HRMS Functional Questions||1,588|
|Oracle Applications – Technical Intervie||1,567|
|Oracle User Management – Password Reset||1,431|
|Oracle Application – General Interview (||1,429|
|Oracle Alerts – FAQ for Beginners||1,419|
|Oracle Applications / Financials – Funct||1,417|
|Oracle 11i Application Developer – Techn||1,402|
|Oracle Order Management – Technical – Ta||1,343|
|Back-to-Back Order – How to||1,333|
|Setting up Invoice Approval Workflow||1,275|
|Oracle Applications Documentation AIM Me||1,226|
|Oracle & Iron Man – Great Combinatio||1,210|
|Oracle Receivables – FAQ , Interview Que||1,158|
|How do you find or delete duplicate rows||1,135|
|Oracle Timecard (OTL) Automation||1,133|
|Working with CONCSUB||1,127|
|Oracle Applications FND Useful Tables||1,108|
|Overview – Oracle Projects||1,085|
|Oracle Database – Technical Questions An||1,043|
|Oracle iExpense- What are the tables inv||1,030|
|Oracle AP – Payables Payment Selection C||1,003|
|To create a customized folder in Oracle||996|
|Tips For Personalizing The E-Business Su||959|
|Oracle Projects Billing Interface with O||949|
|Oracle iExpense – How To Enter Internet||943|
|Mostly asked questions in Account Payabl||941|
|Steps to change the Discoverer Session t||933|
|Very Common Oracle Apps DBA Questions||931|
|Video Tutorial : Oracle SOA Suite||925|
|Oracle Property Manager – Introduction –||897|
|Oracle Applications – Basics – Part 1||895|
|How to Review and Adjust Oracle Project||887|
|Oracle 11i Concept – Multi Org||881|
|Oracle Interview Questions With Answers||870|
|What is Oracle Apps (ERP)?||846|
|How To Identify Where An Expense Report||843|
|Oracle Projects – Revenue Generations an||842|
|Oracle Applications – Commonly Useful SQ||834|
Managing team conflict is one of the core competency area a manager should have. However, it is one of the most difficult skills sou should nurture as a manager. In order to resolve team conflict you need to ask yourself the following five questions.
Each behavior does not necessarily mean serious conflict unless they are extreme. The extreme behavior may be irreparable damage like poor performance or miss the deadline.
On the contrary, a high performance team is a group of people who can understand roles and goals, and they are committed to achieve those goals together. An effective team uses their individual skills and support each other to work together to meet their goals, . They communicate and share information. They believe in team work.
A high-performance team:
* Works together to achieve mutual goals.
* Accepts the fact that each member is responsible, a team player, and committed to achieving team goals.
* Communicates with each other.
* Shares the achievement and failure together.
* Shares information, helps each other, and admits the fact that the success of the group is dependent on each individual.
* They can handle conflict.