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
Overview of Concurrent Programs and Requests
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.
Request Groups and Request Sets
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 and Request Groups
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.
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.
- What are the symptoms of the conflict: Conflict can be defined as a serious disagreement for the successful completion of the project. They include:
- Not completing work in time
- Not returning phone calls or e-mails
- Not responding to requests for information
- Finger Pointing
- Complaints, verbal abuse and hostility
- Not attending the meeting
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.
- What are the reasons for the conflict: Conflict occurs when the goal is not very clear or unrealistic. The ability to resolve conflict effectively is an important team skill. The reason of conflict includes:
- Poor or no communication.
- Lack of problem solving skills
- Lack of clarity in purpose, goals, objectives, team and individual roles
- Not sure about resources and sources for help support
- Bad time management
- Bad leadership and management
- Job is not challenging
- Lack of skill set in team members
- Personal problems
- How to address the conflict:
- You need to define the problem first: Most people jump to resolve the problem first without knowing what the problem is all about. We should initially focus to define the problem together. Problem definition may change while gathering the data or may be further refined during problem solving.
- Gather Data: The next step is to gather data on what is actually happening. This means collecting facts that that are actual,
observable, and measurable. It also means observing through meetings, teleconferencing, or video conferencing.We need to know about individual performances, who’s meeting deadlines and goals, who works independently, who comes up with good ideas, who initiates, who takes on extra work and performs it etc.
- Analyze the data: Analyzing the data means we can address what is going on with the team itself, and figure out the role the manager is playing. To diagnose the performance we should consider a> Lack of Communications, b> lack of problem solving skills c> Lack of clarity of goal, team and individual roles d> Poor time management e> lack of leadership f> Personality Conflicts etc.
- Choose the Best solution: As we analyze our data, we have to separate it into small areas such as communications, turnover, etc.We have to look into “root causes” versus symptoms. If we get answers to questions in each area, we can focus in on distinct areas of the problem.We can work on solutions and then find out the best solution.
- Implement the solution: After we analyze the data
and develop solutions, we select the best solution for our problem areas and begin to construct a plan. This plan will include actions to address each problem area, and will include a schedule for implementation with measurements. Work on one or two areas versus trying to fix everything at once