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
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
No comments:
Post a Comment