Concurrent Programs
- How do you register a report? Explain passing of parameters between a concurrent program Definition and report?
After
developing the report (.rdf), FTP it to the UNIX server.
Define
executable.
Define
concurrent program and attach the executable.
Attach
the concurrent program to a request group.
2 2.
What is the
approach to create a new form to be used in Oracle Apps?
The TEMPLATE form is the required starting point of all development
of new forms. Start Developing each new form by copying the TEMPLATE.fmb file,
located in $AU_TOP/forms/US(or your language and platform equivalent), to local
directory and rename it as appropriate.
- Explain
Value Set? Difference between a Table Validated and Independent Value Set?
A set of values against
which Oracle Application Object Library validates values your end users enter
when running your program. You define your value set by specifying validation rules,
format constraints and other properties. For example, you could define a value
set to contain values that are character strings, validated from a table in
your application. You can specify that oracle application Object Library use
the same value set to validate different report parameters. You can also use
value sets that you use in your flex fields to validate your report parameters.
- How do you create a table
validated value set dependent on another value set?
Use :$FLEX$.<Value set
name> in the where condition.
- What
is difference between a concurrent request and a concurrent request set?
Concurrent request set is the combination of multiple requests
which will run in a sequence.
- What are the two mandatory parameters required for running a PL/SQL Procedure based concurrent program?
Errbuf, Retcode
7. How
can you ensure that only one instance of a concurrent program runs?
Check the ‘Run Alone’ check box in
Concurrent program registration window.
8. Within
a PL/SQL procedure which API is to be used to extract a profile value?
FND_PROFILE.GET
9. How
do you set the operating unit context in a report?
Begin
Dbms_application_info.set_client_info(<Organization_Id>);
End;
10. Can
you submit a concurrent request from the operating system directly?
Write a Shellscript.
Login to database
Run the function
FND_REQUEST.Submit()
11. Explain
how to generate a trace file for a pl/sql concurrent program for tuning?
Check the ’Enable
Trace’ check box in concurrent program registration window.
12. How
do you “write” to the concurrent request Log and Output file?
FND_FILE.PUT(FND_FILE.LOG
or FND_FILE.OUTPUT, <Text>);
