Oracle E-Business Suite R12: System Administration Sample Questions:

1. Identify the types of reports generated by the SignOn Audit. (Choose all that apply.)

A) Concurrent Requests
B) Database INSERT, DELETE, and UPDATE
C) Schema
D) Unsuccessful Logins
E) Users
F) Forms

2. One of the Administrators indicated that even 10 minutes after staffing the Standard Manager, it is still not running any requests, and the pending jobs are piling up in the queue. The administrator has requested for your help.
You are looking at the Administer Concurrent Manager screen, and you notice the following:
For the Internal Manager the number of actual processes is 0, target processes is 0, and pending requests is 1.
For the Standard Manager the number of actual processes is 0, target processes is 3, and pending requests is 56.
For the Conflict Resolution Manager the number of actual processes is 0, target processes is 0, and pending requests is 1.
Analyze the state of the concurrent managers and identify the solution for resolving this issue.

A) TheInternal Manager is not running, it must be started before the request to starttheStandardManager can be executed. Entertheoperating system and start the Internal Manager.
B) The Conflict Resolution Manager is not running, it must be startbefore the request to start the Standard Manager can be executed. Place the cursor on theConflictResolutionManager record and press the Restart button.
C) The Internal Manageris not running,it must be started before therequest to start the Standard Managercan be executed. Place the cursor on the Internal Manager record andpress the Restartbutton.

3. Identify the capabilities of the SignOn Audit feature used for auditing system resources Applications. (Choose all that apply.)

A) It enables determining how any data row or element obtained its current value.
B) It provides online access to audit data through the Monitor Users form.
C) It enables monitoring of user activity.
D) It enables auditing at the user level.
E) Itenables auditing at the responsibility or form level.

4. The finance manager has requested the creation of a request set. The intention of the request set is to load GL journals from an external system. All the concurrent programs to be used by the set have been developed. The set includes a combination of custom and standard programs. The finance department is currently running the programs individually and there have been issues. The
purpose of the set is to standardize the submission process.
The first stage of the set should execute a concurrent program to load the flat file containing the Interface records into an interface table. The user should be required to enter the path and file name when submitting the request set.
If the first stage is successful, the set should execute the second stage, which is a concurrent program to pre-validate the contents of the interface table, process them, and put them into GL Interface. This concurrent program currently has a parameter to limit the execution to a certain set of data, but for this particular request set the finance manager does not want the person submitting the report to set or see the parameter.
If the pre validation program in the second stage completes normally, the set should start the third stage which runs journal import. The entire set of parameters for journal import should be defaulted in the report set definition to appropriate values. They should be visible to the user submitting the request, but they should not have the ability to change them.
If the pre validation program fails the set should start the fourth stage, which runs the pre-validation programs exception report. The exception report normally has no parameters but for the execution this set the finance manager would like to add a parameter to limit the exception report to the list of exceptions for this run of the report set. After the exception report is finished the report set should terminate.
After journal import is completed in stage 3, the report set should submit stage 5, which executes one of the journal entry detail reports. This report has the set of books as a parameter. This should to the profile option for the user's responsibility. If the profile option is not set for the responsibility the parameter should be displayed and set by the user running the set. If the profile option is set for the responsibility then the parameter should be hidden from the user.
Analyze the above requirements and identify two requirements that are problematic to implement by (performing the setups required to make the request set. (Choose two.)

A) The request set cannot be configured to default the parameters for journal Import and preventusers from changing them when the set is submitted.
B) Thejournal entry detail report cannot hide the set of books parameter from the user on thebasisof whether or not the default value contains a value or is null.
C) Stage2cannot optionally start stage 3 or stage 5 dependent on the outcome of stage 2.
D) The parameter to limit the output of the pre-validation exception report does not exist. Therefore,the report set cannot use that in the set setup.
E) The user would not be permitted to enter the file name to load in stage 1 because parametervalues can only be assignedinthe set definition.

5. The steps for implementing flexfields, both key and descriptive is shown below:
*1 Define the values for the value sets.
*2 Define the flexfield segments and structures.
*3 Define the flexfield value sets.
*4 Define the flexfield structure and layout
*5 Define the security and cross-validation rules for key flexfields as necessary.
Identify the sequence of steps in correct order.

A) 4,3, 2, 1,5
B) 4,3,1, 5, 2
C) 2, 3,1, 4,5
D) 2, 4, 3, 5,1

Solutions: