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

1. Which two steps are included in the procedure for defining a value set? (Choose two.)

A) using existing value sets when possible
B) defining a list of values if appropriate
C) defining flexfield segments and structures
D) defining security and cross-validation rules

2. You have a specialization rule for the concurrent manager as given below:
Include Oracle ID Oracle Purchasing
Exclude Request Type Oracle Purchasing Month End Rep
Which statement is true about this rule?

A) Manager reads requests for allRequesttypes except Oracle Purchasing and Month-End Rep.
B) Manager does not read requests for Oracle Purchasing because itis assigned in Include andExclude.
C) Managerreads requests for all programs assigned to Oracle Purchasing except programs definedwith the Month-End Rep request type.
D) Manager reads requests for all Oracle IDs and Oracle Purchasing programs but fails to read thatof Requesttypes.

3. 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) The user would not be permitted to enter the file name to load in stage 1 because parametervalues can only be assignedinthe set definition.
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) Stage2cannot optionally start stage 3 or stage 5 dependent on the outcome of stage 2.

4. Identify the components of Oracle Workflow. (Choose all that apply.)

A) Oracle Workflow Builder
B) Notification System
C) Notification Worklist
D) Workflow Engine
E) Business Event System
F) ApplicationID
G) Workflow base path

5. The finance director just submitted an account analysis report and would like to know to which printer it will print. He did not specify the name of the printer when he submitter the request, he just accept the default. He is using the General Ledger Super User responsibility.
You access the System Profile Option screen and select the value of the printer profile option for the site, the General Ledger Application, the General Ledger SuperUser responsibility, and the Finance Director.
You notice that the profile option at the site level does not contain a value.
The profile option at the application level is set to printer1.
The profile option at the responsibility level is set to printer2.
The profile option for the finance director's user account is printer3.
To which printer will his job print?

A) It would print using printer1because of the setting at the application level.
B) It would print using printer2 because of the setting at the responsibility level.
C) It would not print because the default value at the site level is null.
D) This information is inconclusive because it does not identify the profile option value that system would choose.
E) It would print using printer3 because of the setting at the user level.

Solutions: