Oracle Apps Interview Questions Part - 6

81)Why does Help->Tools->Examine ask for a password

Navigate to the Update System Profile Screen.
(\ navigate profile system) 32
- Select Level: Site
- Query up Utilities:Diagnostics in the User Profile Options Zone.
If the profile option Utilities:Diagnostics is set to NO, people with access to the Utilities Menu must enter the password for the ORACLE ID of the current responsibility to use Examine. If set to Yes, a password will not be required.

82)What are the API used in PO cancellation

Ans. For Partial cancellation -> To modify the Ordered quantity
v_return_flag := apps.gems_public_apis_pkg.po_update_po
( x_po_number => v_po_number
, x_release_number => NULL
, x_revision_number => v_revision_num
, x_line_number => v_line_number
, x_shipment_number => v_shipment_num
, new_quantity => p_quantity
, new_price => NULL
, new_promised_date => NULL
, launch_approvals_flag => 'Y'
, update_source => NULL
, x_interface_type => NULL
, x_transaction_id => NULL
, version => '1.0');
For Full cancellation ->
apps.gems_public_apis_pkg.po_control_document
( p_api_version => v_api_version_number
, p_init_msg_list => apps.fnd_api.g_true
, p_commit => apps.fnd_api.g_false
, x_return_status => p_return_status
, p_doc_type => 'PO'
, p_doc_subtype => v_sub_type
, p_doc_id => v_po_header_id
, p_doc_num => NULL
, p_release_id => NULL
, p_release_num => NULL
, p_doc_line_id => v_po_line_id
, p_doc_line_num => NULL
, p_doc_line_loc_id => p_line_loc_id
, p_doc_shipment_num => NULL
, p_action => 'CANCEL'
, p_action_date => SYSDATE
, p_cancel_reason => 'GPO_WAREHOUSE_DENIAL'
, p_cancel_reqs_flag => 'N'
, p_print_flag => 'N'
, p_note_to_vendor => apps.fnd_api.g_miss_char); 33

83)How an API is initialized

Ans. apps.gems_public_apis_pkg.fnd_apps_initialize
( user_id => p_user_id
, resp_id => p_resp_id
, resp_appl_id => p_resp_appl_id)

84)What is the name of the API parameter when they are True,False and NULL

Ans. apps.fnd_api.g_true, apps.fnd_api.g_false and apps.fnd_api.g_miss_char respectively.

85)What are the different steps in sending a mail from PL/SQL

Ans. PROCEDURE glp_send_mail_po_cancel
( p_org_id IN VARCHAR2
, p_feeder_source IN VARCHAR2
, p_subject IN VARCHAR2
, p_message_body IN VARCHAR2
, p_return_status OUT VARCHAR2
, p_error_message OUT VARCHAR2
)
v_host_name := utl_inaddr.get_host_name();
v_host_ip := utl_inaddr.get_host_address(v_host_name);
v_mailconn := utl_smtp.open_connection(v_host_ip, 25);
utl_smtp.helo(v_mailconn,v_host_ip);
utl_smtp.mail(v_mailconn,v_from_email_id);
utl_smtp.rcpt(v_mailconn,v_to_email_tab(v_addr_cnt));
v_message := v_message || 'To: ' || v_to_email_tab(v_addr_cnt) || '>' || crlf;
utl_smtp.data(v_mailconn,v_message); -- calling mail procedure
utl_smtp.quit(v_mailconn);

86)How do u call a mail program from Shell program

Ans. for file in `find . -name " .com ~$5" -print |cut -c3-120`
do
echo $file
frm=`echo $file | cut -d'~' -f1`
tom=`echo $file | cut -d'~' -f2 | sed 's/,/ /g'`
echo $frm
echo $tom
echo "Sending mail to $tom"
mailx -r "$frm" -s 'Order Shipment Confirmation' "$tom" < "$file"
rc=$
if [ $rc != 0 ]
then
echo 'invalid file name'
fi 34
rm -f "$file"
rc=$
if [ $rc != 0 ]
then
echo 'invalid file name'
fi
done

87)How do submit a concurrent program from PL/SQL

Ans. apps.fnd_global.apps_initialize
(user_id => p_user_id
,resp_id => p_resp_id
,resp_appl_id => p_resp_appl_id)
;
 / p_error_message := p_error_message ||'Calling Receiving transaction processor'||chr(10);
v_request_id := apps.fnd_request.submit_request
('PO'
,'RVCTP'
,NULL
,NULL
,FALSE
,'BATCH'
,p_batch_id
);
dbms_output.put_line('request id is :'||v_request_id); COMMIT;
p_error_message := p_error_message ||'Receiving Transaction Processing Request id :'||v_request_id ||chr(10) ;
IF (v_request_id > 0) THEN
v_complete := FND_CONCURRENT.wait_for_request ( request_id => v_request_id
, interval => 10
, max_wait => 0
, phase => v_phase
, status => v_status
, dev_phase => v_dev_phase 35
, dev_status => v_dev_status
, message => v_message);

88)How do u register a concurrent program from PL/SQL

Ans. apps.fnd_program.executable_exists -> To check if executable file exists

apps.fnd_program.executable -> To make executable file
fnd_program.program_exists -> To check if program is defined
apps.fnd_program.register -> To register/define the program
apps.fnd_program.parameter -> To add parameters
apps.fnd_program.request_group -> To add to a request group

89)How do u initialize an API

Ans. apps.gems_public_apis_pkg.fnd_apps_initialize
( user_id => p_user_id
, resp_id => p_resp_id
, resp_appl_id => p_resp_appl_id)
And U can get the parameters from the following script ->
SELECT DISTINCT f5.user_id
, f4.responsibility_name responsibility_name
, f4.responsibility_id responsibility_id
--INTO
--v_user_id
--, v_responsibility_name
--, v_responsibility_id
FROM applsys.fnd_user_resp_groups f6
, apps.fnd_user f5
, apps.fnd_profile_options f1
, apps.fnd_profile_option_values f2
, apps.fnd_responsibility f3
, apps.fnd_responsibility_tl f4
WHERE SYSDATE BETWEEN f6.start_date AND NVL(f6.end_date,SYSDATE)
AND f5.user_id = f6.user_id
AND UPPER(f5.user_name) like '%GLOBALPARTS%'
AND f6.responsibility_id = f4.responsibility_id
AND f2.profile_option_value = TO_CHAR(13) -- Putting the ORG ID Value
AND f2.profile_option_id = f1.profile_option_id
AND f1.profile_option_name = 'ORG_ID'
AND f3.application_id = 201
AND f2.level_value = f3.responsibility_id
AND f3.responsibility_id = f4.responsibility_id
AND UPPER(f4.responsibility_name) LIKE UPPER('GEMS%PO%MANAGER%') 36
AND ROWNUM = 1;

90)How Do u register a table & a column

Ans. EXECUTE ad_dd.register_table( 'GEMSQA', 'gems_qa_iqa_lookup_codes', 'T', 512, 10, 70);
EXECUTE ad_dd.register_column('GEMSQA', 'gems_qa_iqa_lookup_codes', 'LOOKUP_CODE', 1, 'VARCHAR2', 25, 'N', 'N');

91) What resources are provided for developing applications which will be
integrated into Oracle Applications Release 11

a. The Oracle Applications Developer's Guide Release 11 and the Oracle
Applications User Interface Standards Release 11.
b. The AU_TOP/forms/US/TEMPLATE.fmb for developing a new form.
c. The AU_TOP/forms/US/APPSTAND.fmb contains standard property classes
for your runtime platform.
d. The AU_TOP/resource/FNDSQF.pll contains routines for Flexfields,
Function Security, User Profiles, Message Dictionary.
e. The AU_TOP/resource/APPCORE.pll contains standard User Interface routines.
f. The AU_TOP/resource/APPDAYPK.pll contains the Calendar Widget routines.
g. The AU_TOP/resource/CUSTOM.pll for adding custom code which affects Oracle
Applications forms without changing Oracle Applications code.
h. The AU_TOP/resource/GLOBE.pll allows Oracle Applications developers to
incorporate global or regional features into Oracle Applications forms
without modifying the base Oracle Applications forms. Globe calls routines
JA, JE, and JL libraries.
i. The AU_TOP/resource/JA.pll called from Globe and contains Asia/Pacific code.
j. The AU_TOP/resource/JE.pll called from Globe and contains EMEA
(Europe/Middle East/Africa) code.
k. The AU_TOP/resource/JL.pll called from Globe and contains Latin America code.
l. The AU_TOP/resource/VERT.pll allows Oracle Applications developers to
incorporate vertical industry features (for automotive, consumer packaged
goods, energy, and other industries) into Oracle Applications forms
without modifying the base Oracle Applications forms. 37
m. Oracle Developer/2000 Server Release 1.6.1.
NOTE: All FMB and PLL files must be migrated to your desktop if you intend to
develop and integrate custom applications into Oracle Applications
Release 11.

92. What are the supported versions of Forms and Reports used for developing
on Oracle Applications Release 11

Answer------
a. The following supported versions are provided in Developer/2000
Release 1.6.1:
i. Forms 4.5
ii. Reports 2.5

Oracle Apps Interview Questions Part - 5

41) How to submit concurrent program through l/sql

fnd_request.submit_request(parameters) by using this we can submit the concurrent program thru pl/sql.
FND_GLOBAL.APPS_INITIALIZE (user_id,resp_id, resp_appl_id)

42) What are the types of Concurrent Managers 25

3 MASTER CONCURRENT MANAGERS:
1. Internal Conccurent Manager (ICM): This is the one which monitors all other CMs
2. Standard Manager (SM) : This takes care of report running and batch jobs
3. Conflict Resolution Manager (CRM): checks concurrent program definitions for incompatability checks.
We cannot delete a concurrent manager... but we can disable it... but it's not recommended.

43) multi org set up

Begin dbms_application_info.set_client_info('ORG_ID');
end;

44. What is the relation between Responsibility, Menu and Request Group

Responsibility: - A responsibility is a set of authority in Oracle Apps that lets users access only that functionality of the application appropriate to their roles.
Menu: - A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it.
Request Group: - it 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.

45. What is a function, how to create one

A function is apart of an application‟s functionality that is registered under a unique name for the purpose of assigning to it to, or excluding it from, a menu (and by extension, responsibility). There are several types of functions: - Form Functions, SubFunctions, and
Non-form functions. We often refer to a form function simply as a form.

46. What is meant by APPL_TOP

Environment variable
An operating System variable that describes an aspect of the environment in which your application runs. For example, you can define an environment variable to specify a directory path. 26
$APPL_TOP: An environment variable that denotes the installation directory for Oracle Application Object Library and your other Oracle applications. $APPL_TOP is usually one directory level above each of the product directories (which are often referred to as $PROD_TOP or $PRODUCT_TOP or $<prod>_TOP).

47. Explain briefly where are the Custom.pll, Forms, Reports, Sql Loader Control files, Shell Script source
code and executables files kept

Custom.pll - $AU_TOP/resource
Forms - $PROD_TOP/Forms/US
Reports - $PROD_TOP/Reports/US
SQL Control Files - $PROD_TOP/Bin
Shell Scripts - $PROD_TOP/Bin

48. When is Custom.pll used

Custom.pll is used while making new or customizing standard oraclke forms in apps. It contains all the forms libraries for apps.

49. What are profile options; at what levels can these be set

A user profile is a set of changeable options that affects the way the applications run. Oracle
Applications object Library establishes a value for each option in a user‟s profile when the
User logs on or changes responsibility.
System Profile: - Profile option can be set for the user community.
User Profile: - Provide Oracle Apps with standard information which describes a user,
Application, Responsibility and site. At each profile level user profile options can be set.

50. How can you know the form (fmb) name when you open a form in Apps

Help

51. Where do you create a table and sequence in Apps  Is it APPS schema

In custom schema and then grant privileges on it to APPS schema.

52. Where are Views and Procedures created  27

Views: - Views are to be created only in APPS.
Procedures: - In custom schema and the grant it to APPS schema.

53. How can you tell who last updated a particular row in a form

54. You have logged onto a Responsibility, how do you know what operating unit are you on

55) Can new profiles be created  If so how
Yes. Application Developer.

56)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.

57) 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.

58. 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 28
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.

59. How do you create a table validated value set dependent on another value set
Use :$FLEX$.<Value set name> in the where condition.

60. What is difference between a concurrent request and a concurrent request set

61. What are the two mandatory parameters required for running a PL/SQL Procedure based concurrent program
Errbuf, Retcode

62. How can you ensure that only one instance of a concurrent program runs
Check the „Run Alone‟ check box in Concurrent program registration window.

63. Within a PL/SQL procedure which API is to be used to extract a profile value
FND_PROFILE.GET

64. How do you set the operating unit context in a report
Begin
Dbms_application_info.set-client-info(<Organization_Id>);
End;

65. Can you submit a concurrent request from the operating system directly
Write a Shellscript.
Login to database
Run the function FND_REQUEST.Submit()

66. 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. 29

67. How do you “write” to the concurrent request Log and Output file
FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, <Text>);

68. What is the difference between Operating Unit and Inventory Organization
Operating Unit :- An Organization that uses Oracle Cash management, Order management and Shipping Execution, Oracle Payables, Oracle Purchasing, and Oracle Receivables. It may be a sales Office, a division, or a dept. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications. Each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.
An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products. Examples, include (but are not limited to) manufacturing plants, warehouses, distribution centers, and sales offices. The following applications secure information by inventory organization: Oracle inventory, Bills of Material, Engineering, and Work in Process, Master Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of these applications, you must choose an organization that has been classified as an inventory organization.

69. What is Set of Books

A financial reporting entity that uses a particular chart of accounts, functional currency,
And accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.

70. What is Item Validation Organization

The organization that contains your master list of items. You define it by setting the OM: Item Validation Organization parameter. You must define all items and bills in your Item Validation Organization, but you also need to maintain your items and bills in separate organizations if you want to ship them from other warehouses.
OE_System_

71. Mention the table or views where Inventory Org, Items, Set of Books, GL Code Combinations,
Operating Unit, Location, Customers, Vendors, and Invoices are stored in Apps.

Inventory Org: - MTL_PARAMETERS/ORG_ORGANIZATION_DEFINITIONS
Items: - MTL_SYSTEM_ITEMS_B
Set of Books: - GL_SETS_OF_BOOKS 30
GL Code Combinations: - GL_CODE_COMBINATIONS
Operating Unit: - HR_ALL_OPERATING_UNITS
Location: - MTL_ITEM_LOCATIONS
Customers: - RA_CUSTOMERS
Vendors: - PO_VENDOR_CONTACTS
Invoices: - AP_INVOICES_ALL

72. What is the profile to be read to find out what Inventory Organization and Operating Unit are you on
(mfg_organization_id is the Inventory Org)

73)What is Inventory Master Organization

Items are defined in an Inventory Master Organization.

74)What is the difference between key flexfield and Descriptive flexfield

Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number, a cost centre etc Desc Flex is used to just capture extra information. Key Flexfields have qualifiers whereas Desc Flexfields do not. Desc Flexfields can have context sensitive segments while Key flexfields cannot.
And one more differenct that KFF displays like text item but DFF displays like [ ] .

75)Which procedure should be called to enable a DFF in a form

FND_DESCR_FLEX.DEFINE (BLOCK => 'BLOCK_NAME' ,FIELD => 'FORM_FIELD_NAME' ,APPL_SHORT_NAME => 'APP_NAME' ,DESC_FLEX_NAME => 'DFF_NAME' );

76)Which procedure should be used to make the DFF read only at run time

FND_DESCR_FLEX.UPDATE_DEFINITION()

77)What is the difference between flexfield qualifier and segment qualifier

Flexfiled qualifier identifies segement in a flexfield and segment qualifier identifies value in a segment.
There are four types of flexfiled qualifier 1) Balancing segment qualifier 2) cost center 3) natural account and 4) intercompnay
segemtn qualifier :- 1) allow budgeting 2) allow posting 3) account type 4) contral account and 5) reconciliation flag

78)Where do concurrent request logfiles and output files go

The concurrent manager first looks for the environment variable $APPLCSF If this is set, it creates a path using two other environment variables: $APPLLOG and $APPLOUT It places log files in $APPLCSF/$APPLLOG Output files go in $APPLCSF/$APPLOUT So for example, if you have this environment set: $APPLCSF = /u01/appl/common $APPLLOG = log $APPLOUT = out The concurrent manager will place log files in /u01/appl/common/log, and output files in /u01/appl/common/out Note that $APPLCSF must be a full, absolute path, and the other two are directory names. If $APPLCSF is not set, it places the files under the product top of the application associated with the request. So for example, a PO report would go under $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT Logfiles go to: /u01/appl/po/9.0/log Output files to: /u01/appl/po/9.0/out Of course, all these directories must exist and have the correct permissions. Note that all concurrent requests produce a log file, but not necessarily an output file.

79)How do I check if Multi-org is installed

SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to 'Y', Then its Multi Org.

80)How do I find out what the currently installed release of Applications is  /How do I find the name of a form

We can also find out through Help > About Oracle Applications

Oracle Apps Interview Questions Part - 4

31. what are Handlers
  Handler is a group of packaged procedures which is used by Oracle Applications to organize . PL/SQL code in forms.
- Handlers provide a way to centralize the code so that it becomes easier to develop, maintain and debug.
- The packaged procedures available in a handler are called form the triggers by passing the name of the trigger as an argument for the procedure to process.
  Handlers are types :- 1) Item Handlers
2) Event Handlers
3) Table Handlers
4) Business Rules
- Handlers reside in program units in the form or in stored packed in the database.

32)Adding Table handler Logic

Coding logic for window and alternative region control.
Adding fin-windows and/or ROW-LOV‟S and enable query-find.
Coding logic for item relations such as dependent fields.
Coding messages to use message dictionary. 16
Adding FF logic if required.
Adding choices to the special mence and logic to modify choices the default menu and tool bar behavior is necessary.
Coding any other logic.
Creating a form function for the developed form and registering any sub functions.
Testing the form by it self.
Registering the form with AOL.
Adding the form function to a menu or creating custom mence.
Assigning the menu to the responsibility and assigning the responsibility to the user.
Testing the form within Oracle Applications.

33)Registering of Application, form and a concurrent program through Application developer Responsibility
Application:-

oper
<Application / Register >
Form:-
<Application / Form>
<Application / Function>
Menu:- <Application / Menu>
Messages:- <Application / Messages>
Table:- <Database /Table>
Sequence:- <Database / View>
Concurrent Programme:- <Concurrent / Executable>
<Concurrent / Program> 17
Application Developer (Responsibility)
 Flexfield
+Key
+Descriptive
-Test
 Concurrent
-Program
-Executable
-Library
 Application
-Register
-Form
-Function
-Menu
-Messages
+Database
+Lookups
+Validation
 Profile
 Attachments
- Document Entities 18
- Document Categories
- Attachment Functions
 Other
 Requests
- Run
-Set
-Profile
-Concurrent
-Change Organization
-Running Jobs
+Key +Descriptive
-Register -Register
-Segments -Segments
-Aliases -Values
-Cross Validation
-Values +Lookups
-Groups -Application Object Library
-Accounts -Common
+Database +Validation
-Table -Set
-View -Values
-Sequence 19
Lexical references cannot be made in Pl/SQL statements.
Bind references can be done in a PL/SQL statements.
Lexical parameters can be referenced by entering an ampusand ( ) followed immediately by the column name or parameter.
Before creating the query, a column or parameter in the data model should be created for each lexical reference in the query.
For lexical parameters, initial value must be defined so that report builder uses this value to validate the query with a lexical reference.
Token
If Oracle reports are executed by a concurrent program, (for Oracle Reports Program), then a keyword or a parameter with the same name as in the report builder, should be defined which for each parameter, which is known as taken.
This is used to pass the parameters to the reports from the application (SRS Window)
Request Set
Request set is the group of requests, that can be submitted regularly using a single transaction.
Incompatibility
These are the list of programs that can be defined as incompatible with a pertain program.
If any program is defined as incompatible to a particular program, then that program should not run simultaneously with the concurrent program, because they might interfere with its execution.
Application Developer Responsibility
Various Screens
Different Executable Methods
1 Host
2 Immediate
3 Java Stored Procedure
4 Java Concurrent Programme 20
5 Multi Language Function
6 Oracle Reports
7 PL/SQL stored Procedure
8 Request set stage function
9 Spawned
10 SQL Loader
11 SQL Plus
<Concurrent/Library> Concurrent Library
Library types Transaction Library
<Lookups>
User
Access Levels Extensible
System
<Validation/Set>
List of values
List types Long List of Values
Poplist
No security
Security type Hireaxhial Security
Non-hireaxhial Security
Char
Format type Date
Date time
Number 21
Standard date
Standard date time
Time
Validation types Respondent
Independent
None
Pair
Special
Table
Translatable Independent
Translatable Dependent
<Attachments / Attachment Functions>
function
type form
report

34. What is a Data Group

- A data group is a group of oracle applications and the Oracle ID‟s of each application
- Oracle ID grants access privileges to tables in an Oracle Database
- Data group determines which Oracle Data base accounts a responsibilities forms, concurrent programs and reports connect to.

35. What is a Responsibility

- Responsibility defines Applications Privileges
- A responsibility is a level of authority in Oracle Applications that lets users only those Oracle Applications functions and data appropriate to their roles in an organization.
- Each user has at list one or more responsibilities and several users can share the same responsibility 22
  Each responsibility allows access to
- a specific application or a set of applications.
- A set of books
- A restricted list of windows that an user can navigate
- Reports in a specific application.

36. What are security Attributes

- Security Attributes are used by Oracle self service web Applications to allow rows of data to be visible to specified users responsibilities based on the specific data contained in the row.

37. What is a Profile Option

- profile options are the set of changeable options that affects how the application looks and behaves.
- By setting profile options, the applications can be made to react in different ways for different users depending on the specific user attributes.

38. What are steps involved in developing a flex field

- designing the table structure
- creating fields on the form (Visible/Hidden)
- calling appropriate routines
- registration of the flex field.
- Definition of the flex field.
<Flex fields / key/ Register>
<Flex fields/Descriptions / Register>

39. What is an application /Module

- Application is a collection of forms, function and menus

40)FND_PROGRAM Package

FND_PROGRAM.Executable:-
Procedure FND_PROGRAM. Executable IS 23
(executable in Varchar2,
application in varchar2, (full name)
short_name in varchar2, (executable short name)
description in varchar2 default NULL,
execution_method in varchar2,
execution_file_name in varchar2 default null,
Subrowline_name in varchar2 default null, (only for spawned immediate)
Icon_name in varchar2 default null,
Language_code in varchar2 default „US‟,
Execution_file_path in varchar2 default null);
For Java Concurrent Program.
FND. PROGRAM. REGISTER:-
Procedure FND_PROGRAM.Register IS
(Program in varchar2,
application in varchar2,
enabled in varchar2,
short_name in varchar2,
description in varchar2, default null,
executable_short_name in varchar2,
executable_application in varchar2,
execution_options in varchar2, default null,
priority in number default null,
save_output in varchar2 default „Y‟, 24
print in varchar2 dafault „Y‟,
cols in varchar2 default null,
rows in varchar2, default null,
style in varchar2, default null,
style_required in varchar2, default „N‟,
printer in varchar2, default null,
Requets_Type in varchar2, default null,
Request_type_Application in varchar2 default null,
Use_in_Srs in varchar2, default „N‟,
Allow_disabled_valuer in varchar2 default „N‟,
Run_alone in varchar2 default „N‟,
Output_type in varchar2 default „TEXT‟,
Enable_trace in varchar2 default „N‟,
Restart in varchar2 default „Y‟,
nls_complaint in varchar2 default „Y‟,
icon_name in varchar2 default null,
language_code in varchar2, default „US‟,
mls_function_short_name in varchar2 default null,
mls_function_application in varchar2 default null,
incrementor in varchar2 default null);

Oracle Apps Interview Questions Part - 3

21) APPCORE API’S

APP_COMBO
APP_DATE
APP_EXCEPTION
APP_FIELD
APP_FIND
APP_ITEM
APP_ITEM_PROPERTY
APP_NAVIGATE
APP_RECORD
APP_REGION 7
APP_STANDARD
APP_WINDOW

22)FNDSQF API’S

FND_CURRENCY
FND_DATE
FND_GLOBAL
FND_ORG
FND_STANDARD
FND_UTILITIES.OPEN_URL
FND_UTILITIES. PARAM_EXISTS

23)How to call flex fields in the form

By using FND_FLEX.EVENT (EVENT varchar 2)
How to register an executable and define a concurrent program through backend
By using concurrent processing API’S
1. FND_CONC_GLOBAL.REQUES_DATA
.SET_REQUEST_GLOBALS
2. FND_CONCURRENT.AF_COMMIT
.AF_ROLLBACK
.GET_REQUEST_STATUS
.WAIT_FOR_REQUEST
.SET_COMPLETION_STATUS
3. FND_FILE . PUT
. PUT_LINE
.NEW_NAME 8
.PUT_NAMES
.CLOSE
4. FND-PROGRAM . MESSAGE
. EXECUTABLE
. REGISTER
. PARAMETER
. IN COMPATIBILITY
. EXECUTABLE_EXISTS
5. FND_REQUEST . SET-OPTIONS
.SET_REPEAT_OPTIONS
.SET_PRINT_OPTIONS
.SUBMIT_REQUEST
.SET_MODE
6. FND_REQUEST_INFO . GET_PARAM_NUMBER
. GET_PARAM_INFO
. GET_PROGRAM
. GET_PARAMETER
7. FND_SET . MESSAGE
.ADD_PROGRAM
.ADD_STAGE
.IN COMPATIBILITY
8. FND_SUBMIT . SET_MODE
.SET_REQUEST_STATUS
.SUBMIT_PROGRAM 9
.SUBMIT_SET
  FND_PROGRAM.EXECUTABLE
- is used to define a concurent program executable
- it takes 8 parameters ( all are IN mode )
syntax procedure FND_PROGRAM.EXECUTABLE
(executable IN varchar2,
(Full name)
description IN varchar2 default null
execution_method IN varchar2,
execution_file_name IN varchar2 default null,
icon_name IN varchar2 default null,
language_code IN varchar2 default (VS)
  FND_PROGRAM.REGISTER
- this procedure no used to define a concument program.
- It has 30 IN paranmeters. Out of which 9 are mandatory, the remaining are default.
(program IN varchar2,
application IN varchar2,
enabled IN varchar2,
short_name IN varchar2,
description IN varchar2, default null, 10
executable_application IN varchar2,
mls_function_shelt_name IN varchar2,
mls_function_application IN varchar2,
inerementor IN varhcar2);

24. How to register a table and columns through back end

  by using AD_DD package
- for registering a table
-
- AD_DD BPI doesn‟t check for the existence of the registered table or column in the data base schema, but only updates the required SQL tables.
- It should be ensured that, all the tables and columns registered exist actually and have the same format as that defined using AD_DD API.
- Views need not be registered.

25. How to write to a file through concurrent program.

  By using FND_FILE package and it can be used only for log and output files.
1. FND_FILE.PUT
- this is used to write text to a file with out a new line character
- Multilane calls to FND_FILE.PUT will produce consummated text.
Procedure FND_FILE.PUT (which IN Number, Buff IN varchar2);
- can be FND_FILE.LOG or FND_FILE.OUTPUT.
2. FND_FILE.PUT_LINE 11
- this procedure as used to write a line of text to a file followed by a new line character.
Procedure FND_FILE.PUT_LINE (which IN number, buff IN varchar2);
EX:- FND_FILE.PUT_LINE( FND_FILE.LOG, find_message_get);
3. FND_FILE.NEW_LINE
- this procedure is used to write line terminators to a file
procedure FND_FILE.NEW_LINE (which IN number LINES IN NATURAL:=1);
Ex:- to write two newline characters to a log file
Fnd_file.new_line (fnd_file.log,2);
4. FND_FILE.PUT_NAMES
- this procedure as used to set the temporary log file and output filenames and the temporary directory to the user specified values.
- This should be called before calling my other FND_FILE procedure and only once per a session.

26)Function FND_REQUEST.SUBMIT_REQUEST

( application in varchar2 default null,
program in varchar2 default null,
description in varchar2 default null,
start-time in varchar2 default null,
sub_request in bookan default False,
argument1,
arguemnt2,
argument 100) return number;
  If this is submitted from oracle forms, all the arguments ( 1 to 100 ) must be specified. 12

27. How to submit concurrent programs through OS

- From the operating system the utility .CONCSUB is used to submit is concurrent propgram.
- This is basically used to test a concurrent program .
- By using the WAIT token. The utility checks the request status every 60 seconds and returns the OS prompt upon completion of the request.
- Concurrent manager doesnot abort, shutdown or start up until the concurrent request completes.
  If the concurrent program is compatible with it self, it can be checked for data integrity and dead locks by submitting it many times so that it runs concurrently with it self.
 PL/SQL procedures can submit a request to run a program as a concurrent process by calling.
FND_REQUEST. SUBMIT_REQUEST.
  Before submitting a request, the following functions also should be called optionally.
FND_REQUEST.SET_OPTIONS
FND_REQUEST.SET_REPEAT_OPTIONS
FND_REQUEST.SET_PRINT_OPTIONS
FND_REQUEST.SET_MODE

28. How to checks the request states

- A PL/SQL procedure can check the status of a concurrent request by calling.
FND_CONCURENT.GET_REQUEST_STATUS
FND_CONCURRENT.WAIT_FOR_REQUEST
- FND_CONCURRENT.GET_REQUEST_STATUS
- This function returns the status of a concurrent request
- If the request is already computed, it also returns the completion message.
- This function returns both user friendly (translatable) phase and status values as well as developer phase and status vales that can drive program logic. 13
( request_id in out number,
application in varchar2 default null,
program in varchar2 default null,
phase out varchar2,
status out varchar,
dev_phase out varchar2,
dev_status out varchar2,
message out varchar2) return BOOLEAN;
- when application and program are specified, the request_id of the last request for the specified program should be returned to request_id.
- Phase, and status values should be taken from
FND_LOOKUPS
dev_phase dev_status
pending normal, standby, scheduled, paused
running normal, waiting, resuming, terminating.
Complete normal, Error, warning, cancelled, terminated
Inactive disabled, on-hold, No-manager, supended
- FND_REQUEST.WAIT_FOR_REQUEST
- This function waits for request completion, then returns the request phase/status and completion message to the caller.
- Goes to sleep between checks for request completion.
Syntax
( request_id in number default null,
interval in number default 60,
max_wait in numbe default 0, 14
phase out varchar2,
status out varchar2,
dev_phase out varchar2,
dev_status out varchar2,
message out varchar2) return BOOLEN;
  FND_CONCURRENT.SET_COMPLETION_STATUS
- this function should be called from a concurrent program to set its completion states.
- This function returns TRUE on success, other wise FALSE.
ENT.SET_COMPLETION_STATUS
( status in varchar2,
message in varchar2) return BOOLEAN;
normal
status warning
Error

29. What is the reason for not getting any data when a multi org view is quired

- to get the data correctly, the xxx-ALL must be referenced and the ORG_ID value should be specified to extract portioned data.
- Multiorg views are partitioned by using ORG_ID.
- So access through multiorg views will not return any roes, as the CLIENT_INFO Value is not set
- Use HR_OPERATING UNITS to identify the organization _id of the OU on which query is based.
- Use FND_CLIENT_INFO package to set the value in CLIENT INPO using set_org_contest.
- Execute fnd_client_info. Set_org_context („<org_id>‟);
- Now qurying of multiorg views can be done. 15

30. How do you find that muliorg is installed

- multi organization architecture is meant to allow muliple companies or subsidiaries to store their records with in a single data base.
- Multiple organization Architecture allows this by partitioning data through views in APPS schema.
- Implementation of Multi org generally includes more than one business group.
  To know whether multiorg is existing or not
select multi_org_flag
form fnd_product_groups)
- if the result is „Y‟ means the database is group for multiorg

Oracle Apps Interview Questions Part - 2

16 In which tables FF are stored

A) FND - ID - FLEXS
B) FND-ID-FLEX-STRUCTURES 5

17)Oracle Applications Architecture

- Internet computing Architecture is a frame work for 3-tired, distributed computing that supports Oracle Applications products.
- The Three tiers are
1 Data Base Tier
2 Application Tier
3 Desk Top Tier
- Database tier manages Oracle 8i database.
- Application tier manages Oracle Applications and other tools.
- Desktop tier provides the user interface displace.
- With internet computing architecture, only the presentation layer of Oracle Applications is on the Desk Top tier in the form of a plug-in to standard internet brows

18) List of some API’S

FND_PROGRAM.EXECUTABLE
FND_PROGRAM.REGISTER
FND_PROGRAM.PARAMETER
FND_PROGRAM.ADD_TO_GROUP
FND_REQUEST.SUBMIT_REQUEST
FND_PROFILE.VALUE
FND_PROFILE.GET

19)How to get second parameter value based on first parameter

$fle x $ value set name.

20)How to call WHO columns into the form

By using FND_STANDARD API‟S
1. FND_STANDARD.FORM_INFO 6
Provides information about the form.
Should be called form when_new_form - instance - instance trigger.
2. FND_standard.set_who
loads WHO columns with proper user information.
Should be called from PRE_UPDTE and PRE_INSERT
Triggers for each block with WHO fields
If this is used FND-GLOBAL need not be called. (FND_GLOBAL.WHO)
3. FND_STANDARD.SYSTEM_DATE
This is a function which returns date.
Behave exactly like SYSDATE built-in.
4. FNID_STANDARD.USER
This is a function which returns varchar2
Behaves exactly like built in USER.

Oracle Apps Interview Questions Part - 1

1) What is SET-OF-BOOKS OR Ledgers?

Collection of Chat of Accounts and Currency and Calendars, Convention is called SOB

2) How can u call a standard interface program from sql or pl/sql code

FND_REQUEST.SUBMIT_REQUEST (PO,EXECUTABLE NAME,,,,PARAMETERS)

3) API’s FOR CUSTOMER INTERFACE

HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C
HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C
FND_PROFILES
FND_APPLICATIONS
FND_GLOBAL
FND-FILE
FND_CONCSUB(can submit conc program in host environment)

4) PL/SQL stored procedure parameters or what are the two parameters that are mandatory for pl/sql type concurrent program

Procedure/function (ERRBUF OUT RETCODE OUT ………………….)
ERRBUF :- Used to write the error message to log or request file.
RETCODE :- Populate log request file with program submission details info.

5) 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.
-- If the list of values needed to be dynamic and ever changing and define a table based values set.

6) What r the validation types

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 prior value.
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.

7) What is template

a) The TEMPLATE form is the required starting point for all development of new Forms.
b) The TEMPLATE form includes platform–independent attachments of several Libraries.
APPSCORE :- It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS.
APPSDAYPK :- It contains packages that control the oracle applications CALENDER FEATURES.
FNDSQF :- it contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.
CUSTOM :- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)

8) What are ad-hoc reports

Ans.: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a
particular purpose. For example, ad hoc tax codes or an ad hoc database query

9) What is responsibility

Is collection of menus, request security groups and data groups
Menus: collection of forms is nothing but menus
Request security groups: collection of programs.
Data groups: is a group of modules to be made accessible by the user through Responsibility
System admin

10) What are different execution methods of executabls

FlexRpt The execution file is wrnitten using the FlexReport API.
FlexSql The execution file is written using the FlexSql API.
Host The execution file is a host script.
Oracle Reports The execution file is an Oracle Reports file.
PL/SQL Stored Procedure The execution file is a stored procedure.
SQL Loader The execution file is a SQL script.
SQL Plus The execution file is a SQL Plus script.
SQL Report The execution file is a SQL Report script.
Spawned The execution file is a C or Pro C program.
Immediate The execution file is a program written to run as a subroutine of the concurrent manager. We recommend against defining new immediate concurrent programs, and suggest you use either a PL/SQL Stored Procedure or a Spawned C Program instead.
Composite Data types :
PL/SQL TABLES / PL/SQL RECORDS / Nested TABLE / VARRAY
What is the sequence of functions – group by, having , order by in a select statements
Select…..Group by…Having…Order by..
Difference between User and Super User
User : login user or front end user
Super user : it has full access of particular module

11) Oracle E-Business suite

Oracle apps + analytical components software.
(Oracle discover) (Oracle sales analyzer) (Oracle financial analyzer) (Oracle marketing analyzer)

12) 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.
operating unit.
c) Operating unit --- secures AR, OE, AP, PA and PO Information.
d) Organizations --- is a specialize unit of work at particular locations

13) What is ERP and Architecture of apps

A packaged business software system that lets a company automate and integrate the majority of its business processes; share common data and practices across the enterprise; [and] produce and access information in a real-time environment.

. 14)What is invoice and Send you a request for payment

15 Data Link

- Data links relate the results of multiple queries.
- A data link (Parent - Child Relation Ship) causes the child query to be executed once for each instance of its parent group.

Concurrent Processing APIs for PL/SQL Procedures

This POSTdescribes concurrent processing APIs you can use in both client–side and server–side PL/SQL procedures. This section also includes example PL/SQL procedure code using these concurrent processing APIs.
The following packages are described:
FND_CONC_GLOBAL.REQUEST_DATA: Sub–request Submission
FND_CONCURRENT: Information on Submitted Requests
FND_FILE: PL/SQL: File I/O
FND_PROGRAM: Concurrent Program Loaders
FND_SET: Request Set Creation
FND_REQUEST: Concurrent Program Submission
FND_REQUEST_INFO: Request Information
FND_SUBMIT: Request Set Submission

FND_CONC_GLOBAL Package
This package is used for submitting sub–requests from PL/SQL concurrent programs.
FND_CONC_GLOBAL.REQUEST_DATA
Summary  :-function FND_CONC_GLOBAL.REQUEST_DATA return varchar2;
Description :- FND_CONC_GLOBAL.REQUEST_DATA retrieves the value of the REQUEST_DATA global.
FND_CONC_GLOBAL.SET_REQ_GLOBALS
Summary   :- function FND_CONC_GLOBAL.SET_REQ_GLOBALS();
Description :-  FND_CONC_GLOBAL.REQUEST_DATA retrieves the value of the REQUEST_DATA global.
Example
/*
* This is sample PL/SQL concurrent program submits 10 * sub–requests. The sub–requests are submitted one at a
* time. Each time a sub–request is submitted, the parent * exits to the Running/Paused state, so that it does not
* consume any resources while waiting for the child * request, to complete. When the child completes the
* parent is restarted.
*/
create or replace procedure parent (errbuf out varchar2, retcode out number) is
i number;
req_data varchar2(10);
r number;
begin
––
–– Read the value from REQUEST_DATA. If this is the

–– first run of the program, then this value will be
–– null.
–– Otherwise, this will be the value that we passed to
–– SET_REQ_GLOBALS on the previous run.
––
req_data := fnd_conc_global.request_data;
––
–– If this is the first run, we’ll set i = 1.
–– Otherwise, we’ll set i = request_data + 1, and we’ll
–– exit if we’re done.
––
if (req_data is not null) then
i := to_number(req_data);
i := i + 1;
if (i < 11 ) then
errbuf := ’Done!’;
retcode := 0 ;
return;
end if;
else
i := 1;
end if;
––
–– Submit the child request. The sub_request parameter
–– must be set to ’Y’.
––
r := fnd_request.submit_request(’FND’, ’CHILD’,
’Child ’ || to_char(i), NULL,
TRUE, fnd_conc_global.printer);
if r = 0 then
––
–– If request submission failed, exit with error.
––
errbuf := fnd_message.get;
retcode := 2;
else
––
–– Here we set the globals to put the program into the
–– PAUSED status on exit, and to save the state in
–– request_data.
––
fnd_conc_global.set_req_globals(conc_status => ’PAUSED’,
request_data => to_char(i));
errbuf := ’Sub–Request submitted!’;
retcode := 0 ;
end if;
return;
end;

FND_CONCURRENT Package

FND_CONCURRENT.AF_COMMIT
Summary  :- function FND_CONCURRENT.AF_COMMIT;
Description :-  FND_CONCURRENT.AF_COMMIT is used by concurrent programs that use a particular rollback segment. This rollback segment must be  defined in the Define Concurrent Program form.
FND_CONCURRENT.AF_COMMIT executes the COMMIT command for the specified rollback segment. FND_CONCURRENT.AF_COMMIT has no arguments.


FND_CONCURRENT.AF_ROLLBACK
Summary :-  function FND_CONCURRENT.AF_ROLLBACK;
Description:-  FND_CONCURRENT.AF_ROLLBACK is used by concurrent programs that use a particular rollback segment. This rollback segment must be defined in the Define Concurrent Program form. FND_CONCURRENT.AF_ROLLBACK executes the ROLLBACK command for the specified rollback segment.
FND_CONCURRENT.AF_ROLLBACK has no arguments.



FND_CONCURRENT.GET_REQUEST_STATUS (Client or Server)
Summary:-  function FND_CONCURRENT.GET_REQUEST_STATUS
(request_id IN OUT number,
application IN varchar2 default NULL,
program IN varchar2 default NULL,
phase OUT varchar2,
status OUT varchar2,
dev_phase OUT varchar2,
dev_status OUT varchar2,
message OUT varchar2) return boolean;

Description :- Returns the status of a concurrent request. If the request has already completed, also returns a completion message.
FND_CONCURRENT.GET_REQUEST_STATUS returns both
“user–friendly” (i.e., translatable) phase and status values, as well as “developer” phase and status values that can drive program logic.
Arguments (input)  request_id  The request ID of the program to be checked.
Application :- Short name of the application associated with the concurrent program. This parameter is necessary
only when the request_id is not specified.
Program :- Name of the concurrent program. This parameter is necessary only when the request_id is not
specified. When application and program are provided, the request ID of the last request for this
program is returned in request_id.

Arguments (output)
Phase :- The user–friendly request phase from
FND_LOOKUPS.
Status The user–friendly request status from
FND_LOOKUPS.
dev_phase  The request phase as a constant string that can be used for program logic comparisons.
dev_status The request status as a constant string that can be used for program logic comparisons.
Message  The completion message supplied if the request has completed.
Example
begin
call_status boolean;
rphase varchar2(80);
rstatus varchar2(80);
dphase varchar2(30);
dstatus varchar2(30);
message varchar2(240);
call_status :=
FND_CONCURRENT.GET_REQUEST_STATUS(<Request_ID>, ’’, ’’,
rphase,rstatus,dphase,dstatus, message);
end;
In the above example, rphase and rstatus receive the same phase and
status values as are displayed on the Concurrent Requests form. The
completion text of a completed request returns in a message.
Any developer who wishes to control the flow of a program based on a
request’s outcome should use the following values to compare the
request’s phase and status.
Possible values for dev_phase and dev_status are:



_
FND_FILE: PL/SQL File I/O
The FND_FILE package contains procedures to write text to log and output files. In Release 11i, these procedures are supported in all types of concurrent programs. For testing and debugging, you can use the procedures
FND_FILE.PUT_NAMES and FND_FILE.CLOSE. Note that these two procedures should not be called from a concurrent program.
FND_FILE supports a maximum buffer line size of 32K for both log and output files.
Attention: This package is not designed for generic PL/SQL text I/O, but rather only for writing to request log and output files.

FND_FILE.PUT
Summary ;- procedure FND_FILE.PUT
(which IN NUMBER,
buff IN VARCHAR2);
Description  :- Use this procedure to write text to a file (without a new line character).
Multiple calls to FND_FILE.PUT will produce concatenated text.
Typically used with FND_FILE.NEW_LINE.
Arguments (input)
which :  Log file or output file. Use either FND_FILE.LOG or FND_FILE.OUTPUT.
buff  : Text to write.

FND_FILE.PUT_LINE
Summary : - procedure FND_FILE.PUT_LINE
(which IN NUMBER,
buff IN VARCHAR2);
Description :- Use this procedure to write a line of text to a file (followed by a new
line character). You will use this utility most often.


Arguments (input)
Which  Log file or output file. Use either FND_FILE.LOG or FND_FILE.OUTPUT.
Buff  Text to write.
Example
Using Message Dictionary to retrieve a message already set up on the server and putting it in the log file (allows the log file to contain a translated message):
FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
Putting a line of text in the log file directly (message cannot be translated because it is hardcoded in English; not recommended):
fnd_file.put_line(FND_FILE.LOG,’Warning: Employee ’||
l_log_employee_name||’ (’||
l_log_employee_num ||
’) does not have a manager.’);



FND_REQUEST Package

FND_REQUEST.SUBMIT_REQUEST (Client or Server)
Summary : function FND_REQUEST.SUBMIT_REQUEST
(application IN varchar2 default NULL,
program IN varchar2 default NULL,
description IN varchar2 default NULL,
start_time IN varchar2 default NULL,
sub_request IN boolean default FALSE
argument1,
argument2, ..., argument99,
argument100) return number;
Description : - _
Submits a concurrent request for processing by a concurrent manager. If the request completes successfully, this function returns the concurrent request ID; otherwise, it returns 0.
Attention: FND_REQUEST must know information about the user and responsibility from which the request is submitted. Therefore, this function only works from concurrent programs or forms within Oracle Applications. The FND_REQUEST.SUBMIT_REQUEST function returns the concurrent request ID upon successful completion. It is then up to the caller to issue a commit to complete the request submission. Your code should retrieve and handle the error message generated if there is a submission problem (the concurrent request ID returned is 0). Use FND_MESSAGE.RETRIEVE and FND_MESSAGE.ERROR to retrieve and display the error (if the request is submitted from the client side).
You must call FND_REQUEST.SET_MODE before calling FND_REQUEST.SUBMIT_REQUEST from a database trigger. If FND_REQUEST.SUBMIT_REQUEST fails from anywhere but a database trigger, database changes are rolled back up to the point of the function call. After a call to the FND_REQUEST.SUBMIT_REQUEST function, all
setup parameters are reset to their default values.
Arguments (input)  application  Short name of the application associated with the
concurrent request to be submitted.
Program :-  Name of the concurrent program for which the
request should be submitted.
description  :- Description of the request that is displayed in the Concurrent Requests form (Optional.)
start_time  Time at which the request should start running, formatted as HH24:MI or HH24:MI:SS (Optional.)
sub_request  Set to TRUE if the request is submitted from another request and should be treated as a sub–request.
Starting with Release 11, this parameter can be used if you are submitting requests from within a PL/SQL stored procedure concurrent program.
argument1...100 Arguments for the concurrent request; up to 100 arguments are permitted. If submitted from Oracle
Forms, you must specify all 100 arguments.

Example Request Submissions
Example 1     /* Submit a request from a form and commit*/
:parameter.req_id :=
FND_REQUEST.SUBMIT_REQUEST (
:blockname.appsname,
:blockname.program,
:blockname.description,
:blockname.start_time,
:blockname.sub_req = ’Y’,
123, NAME_IN(’ORDERS.ORDER_ID’), ’abc’,
chr(0), ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’);
IF :parameter.req_id = 0 THEN
FND_MESSAGE.RETRIEVE;
FND_MESSAGE.ERROR;
ELSE
IF :SYSTEM.FORM_STATUS != ’CHANGED’ THEN
IF app_form.quietcommit THEN
/*form commits without asking user to save changes*/
fnd_message.set_name(’SQLGL’,
’GL_REQUEST_SUBMITTED’);
fnd_message.set_TOKEN(’REQUEST_ID’,
TO_CHAR(:PARAMETER.REQ_ID), FALSE);
fnd_message.show;
ELSE
fnd_message.set_name(’FND’,
’CONC–REQUEST SUBMISSION FAILED’);
fnd_message.error;
END IF;
ELSE
DO_KEY(’COMMIT_FORM’);
IF :SYSTEM.FORM_STATUS != ’CHANGED’ THEN
/*commit was successful*/
fnd_message.set_name(’SQLGL’,
’GL_REQUEST_SUBMITTED’);
fnd_message.set_TOKEN(’REQUEST_ID’,
TO_CHAR(:PARAMETER.REQ_ID), FALSE);
fnd_message.show;
END IF;
END IF;
END IF;
Example 2
/* Submit a request where no setup is required */
declare
req_id number;
begin
req_id := FND_REQUEST.SUBMIT_REQUEST (’FND’,
’FNDMDGEN’, ’Message File Generator’,
’01–NOV–02 00:00:00’, FALSE, ...arguments...);
if (req_id = 0) then
/* Handle submission error */
FND_MESSAGE.RETRIEVE;
FND_MESSAGE.ERROR;
else
commit;
end if;
end;
Example 3
/* Submit a request from a database trigger */
result := FND_REQUEST.SET_MODE(TRUE);
req_id := FND_REQUEST.SUBMIT_REQUEST (FND’,
’FNDMDGEN’, ’Message File Generator’,
’01–NOV–02 00:00:00’, FALSE, ...arguments...);
Example 4
/* Submit a request inserting NULL arguments.
This call inserts 6 arguments with arguments 1, 3,
4, and 6 being NULL */
req_id := FND_REQUEST.SUBMIT_REQUEST (’FND’,
’FNDPROG’,
’Description of FNDPROG’,
’01–FEB–01 00:00:00’, FALSE,
’’, ’arg2’, ’’, NULL, arg5, ’’);
Example 5
/* Submit a repeating request */
result := FND_REQUEST.SET_REPEAT_OPTIONS (’’, 4, ’HOURS’,
’END’);
req_id := FND_REQUEST.SUBMIT_REQUEST (’CUS’,
’CUSPOST’, ’Custom Posting’,
’01–APR–01 00:00:00’, FALSE,
...arguments...);
Attention: You may not want to submit a request if
FND_REQUEST.SET_REPEAT_OPTIONS returns failure.
Thus, you may wish to test the result of
FND_REQUEST.SET_REPEAT_OPTIONS before issuing the
call to FND_REQUEST.SUBMIT_REQUEST.
Example 6
/* Submit a request for 5 copies of a menu report */
result := FND_REQUEST.SET_PRINT_OPTIONS (’hqunx138’,
’Landscape’,
5,
’Yes’,
FALSE);
req_id := FND_REQUEST.SUBMIT_REQUEST (’FND’,
’FNDMNRMT’,
’’,
’’,
’N’, 0, 101);
Example 7
/* Submit a protected request that repeats at noon */
result := FND_REQUEST.SET_OPTIONS (’YES’);
result := FND_REQUEST.SET_REPEAT_OPTIONS (’12:00’);
req_id := FND_REQUEST.SUBMIT_REQUEST (’CUS’,
’CUSPOST’, ’Custom Posting’,
’01–APR–01 00:00:00’, FALSE,
... args ...);