Winners : Ganesh Kamble , Raj kumar
This Quiz is closed now
Oracle Apps – Regularly Asked Interview Question – Good for Beginners
Some of the Sample Questions can be asked on any New or recently trained person. Most of them are descriptive and subjective.I am sure if a candidate can answer 12-15 Questions comfortably then candidate will be comfortable with Oracle Apps in general.
Like to know if you want to give a try and submit your answer, You can either put your answers in Comment section or send me at shivmohan.purohit@gmail.com
For who give most correct answer will get a PRIZE ! , A Office Document Folder –
- What are the key benefits of forms personalization over custom.pll?
- How can you import invoices into Oracle Receivables?
- Which responsibility do you need to extract Self Service Personalization?
- Which Form in Oracle Applications has most number of Form Functions?
- How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
- What are the basic steps when defining a concurrent program?
- What are the more common pseudo-columns.
- What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
- What are the various report triggers? What is their order of firing?
- Describe the main tables involved in AR?
- Describe the main tables involved in AP?
- Describe the main tables involved in GL?
- Describe the main tables involved in Inventory?
- Describe the main tables involved in Purchasing?
- Describe the main tables involved in Application Developer Module?
- How to register a Form to invoke it from Menu?
- How to create an BI Publisher Report?
- What are steps involve in Data conversion activity.
- What is the difference between upgrade and migration?
- Where we monitor concurrent manager and names of different type of Concurrent Managers?
— We got following Answer so far, waiting few more before closing this and publish the answers and winner .
following people has submitted Answers so far:
1. Lokesh Surana
2. Shrikanth VGR
3. Raj Kumar
4. Shrikant Nawale
5. Ganesh Kamble
1.What are the key benefits of forms personalization over custom.pll?
— Easy of use, Flexibility
Scalable
Minimal Coding
Changes Effective Almost Immediately
No Shared Library
No Patches
Recommended by Product Development
2.How can you import invoices into Oracle Receivables?
3.Which responsibility do you need to extract Self Service Personalization?
— Functional Administrator
4.Which Form in Oracle Applications has most number of Form Functions?
— Run Reports
5.How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
— register the script as in answer to step 6 and assign the responsibility (of the request group) to user.
6.What are the basic steps when defining a concurrent program?
— Define the executable with ececutable method type
Define the concurrent program by attaching the executable
If it is part of Request Set add to the request set then add the request set to the request group
if not then add to the request group
7.What are the more common pseudo-columns.
— ROWNUM, ROWID, LEVEL ,CURRVAL , NEXTVAL
8.What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
— DELETE
data is deleted but table definition is intact
Can be rollbacked
WHERE clause can be used
TRUNCATE
Data is deleted
cannot be rollbacked
WHERE clause cannot be used
9.What are the various report triggers? What is their order of firing?
–There are eight report triggers.
(1) Before Parameter Form
(2) After Parameter Form
(3) Before Report
(4) Between Pages
(5) After Report
(6) Validation Triggers
(7) Format Triggers
(8) Action Triggers
1 to 5 is the sequence of report triggers.
6,7,8 are event based triggers.
10.Describe the main tables involved in AR?
— RA_CUSTOMER_TRX_ALL , RA_CUSTOMER_TRX_LINES_ALL ,RA_BATCHES_ALL ,RA_INTERFACE_ERRORS ,RA_INTERFACE_LINES_ALL
11.Describe the main tables involved in AP?
— AP_INVOICES_ALL,AP_AE_HEADERS_ALL,AP_INVOICE_DISTRIBUTIONS_ALL , AP_AE_LINES_ALL , AP_PAYMENT_DISTRIBUTIONS_ALL
12.Describe the main tables involved in GL?
— GL_JE_HEADERS , GL_JE_LINES , GL_CODE_COMBINATIONS, GL_PERIODS , GL_LEDGERS,GL_SETS_OF_BOOKS,GL_BALANCES
13.Describe the main tables involved in Inventory?
— MTL_SYSTEM_ITEMS_B , MTL_ITEM_CATEGORIES, MTL_ITEM_SUB_INVENTORIES ,MTL_ITEM_CATEGORIES
14.Describe the main tables involved in Purchasing?
— PO_REQUISITION_HEADERS_ALL,PO_REQUISITION_LINES_ALL,PO_DISTRIBUTIONS_ALL, PO_HEADERS,PO_LINES,PO_VENDORS ,RCV_TRANSACTIONS
15.Describe the main tables involved in Application Developer Module?
— FND_USERS, FND_RESPONSIBILITES, FND_REQUEST_GROUPS, FND_CONCURRENT_REQUESTS , FND_CONCURRENT_PROGRAMS ,FND_EXECUTABLES, FND_PROFILE_VL
16.How to register a Form to invoke it from Menu?
— 1> Find the menu of the responsibility from the responsibility definition of the sysadmin responsibility( Security>Responsibility>Menu(field)
2>first define the form in the FUNCTION
3>Query the Menu in the MENU menu of the sysadmin (Application>Menu)
4> assign the form name to the required SUBMENU
From the Databse point..herewith are the helpful queries:
After finding the menu attached to the Responsibility:
SELECT *–MENU_ID, MENU_NAME
FROM FND_MENUS_VL
WHERE USER_MENU_NAME = ‘GL_OPERATIONS_USER’
/
SELECT * –sub_menu_id, entry_sequence,function_id ,prompt
FROM FND_MENU_ENTRIES_VL
WHERE MENU_ID=69509
AND PROMPT=’External Interfaces’
/
SELECT *–menu_id, entry_sequence,function_id,prompt
FROM FND_MENU_ENTRIES_VL
WHERE MENU_ID=1003058
AND PROMPT=’Open Link JE Interface’
/
SELECT * –function_id, function_name, form_id, parameters
FROM FND_FORM_FUNCTIONS_VL
WHERE FUNCTION_ID=27280
/
17.How to create an BI Publisher Report?
— http://technology.amis.nl/blog/1620/my-first-steps-with-oracle-bi-publisher-enterprise-edition-10132-create-a-report-based-on-the-orablogs-rss-feed
18.What are steps involve in Data conversion activity.
— Load data from csv into a stagin table
Throguh CC program validate the data by pl/sql before pushing it into interface table or base table (through API if avialable)
recheck the data in the application for verification
19.What is the difference between upgrade and migration?p
— Upgrade is from Oracle lower version to newer version and Migration is from one instance to another(it can be oracle to oracle or legacy to oracle).
20.Where we monitor concurrent manager and names of different type of Concurrent Managers?
— SYSADMIN [Resp] : Concurrent : Manager : Administer
LikeLike
What are the key benefits of forms personalization over custom.pll?
Ans :
1.CUSTOM.pll is a single file/entity, hence only one developer can make changes to CUSTOM.pll at any given point in time.
2. If for some reasons CUSTOM.pll causes issues in Production, you will have to re-release the code changes after another round of UAT.
Form Personalizations makes this much simpler by allowing you to disable specific personalizations.
3. You do not need to resort to programming for trivial tasks like changing prompt, and more so for changing prompts in Muli-Lang environment.
Lets do a quick comparison between Forms Personalization and CUSTOM.pll
Task/Business Requirement CUSTOM.pll Forms Personalization
Change LOV Query Yes Yes
a. Create a New Record Group
b. Attach new RG to LOV
Change field properties like Mandatory/Display etc Yes Yes
Zoom to another screen Yes Yes
a. Enable Menu
b. Trap the Menu event
Disable a Menu entry when certain conditions are met Yes No
Display messages, warnings, hints etc Yes Yes
Display message with Questions, and conditionally execute code based on users response to the question Yes No
Execute PL/SQL Stored procedures Yes Yes
Change Navigation and Navigational Properties Yes Yes
Change block properties like “Query Where Clause” etc Yes Yes
Change is applicable across multiple screens, like Changing window title for all screens within one Organization/Responsibility Yes Yes
Show FND Messages with their tokens replaced Yes Yes
How can you import invoices into Oracle Receivables?
Ans : Use import invoice open interface or ar_invoice_api_pub.create_single_invoice API.
Which responsibility do you need to extract Self Service Personalization?
Ans : Functional Administrator
Which Form in Oracle Applications has most number of Form Functions?
Ans : Run Reports
How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
Ans : Develop a concurrent request which user can run at any time.
What are the basic steps when defining a concurrent program?
Ans :
1. Connect to the application and select system administrator create Executable
2. Executable Name (Any User defined Name)
3. Application Name(e.g. Where the .rdf file located)
4. Execution Method (e.g. Oracle Reports for reports)
5. Execution File (e..g .rdf file Name)
6. Create Concurrent program and attach Executable
7. Parameters
8. Incompatible Programs
9. create Request Group attach Concurrent Program
10. Create responsibility attach
11. Request Group
12. Menu
13. Data Group
14. Create User Attach Responsibility to the User
15. User will submit the request from SRS (Standard Request Submission) Window
What are the more common pseudo-columns.
Ans : Rowid, rownum,currval, nextval , level
What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
Ans : The TRUNCATE command provides a fast, efficient method for deleting all rows from a table or clustered table.
A TRUNCATE statement does not generate any rollback information and it commits immediately; it is a DDL statement and cannot be rolled back.
A TRUNCATE statement does not affect any structures associated with the table being truncated (constraints and triggers) or authorizations (grants).
A TRUNCATE statement also specifies whether space currently allocated for the table is returned to the containing tablespace after truncation.
As a Truncate statement deletes rows from a table (or cluster), triggers associated with the table are not fired.
A TRUNCATE statement does not generate any audit information corresponding to DELETE statements if auditing is enabled. Instead, a single audit record is generated for the TRUNCATE statement being issued.
What are the various report triggers? What is their order of firing?
Ans :
• Before Parameter
• After Parameter
• Before Report
• Between Pages
• After Report
Apart from above 5 report triggers, there are 3 other triggers as well.
• Validation Trigger
• Format Trigger
• Action Trigger
Describe the main tables involved in AR?
Ans :
AR Base Tables
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLES_TRX_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR Interface Tables
AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_CUSTOMERS_INTERFACE_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
Describe the main tables involved in AP?
Ans :
AP Base Tables
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_HOLDS_ALL
AP_AE_LINES_ALL
AP_AE_HEADERS_ALL
AP Interface Tables
AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE
Describe the main tables involved in GL?
Ans :
GL Base Tables
gl_je_batches
gl_je_headers
gl_je_lines
gl_je_sources
gl_periods
gl_code_combinations
gl_set_of_books
GL Interface Tables
GL_INTERFACE
GL_INTERFACE_HISTORY
GL_INTERFACE_CONTROL
GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_IEA_INTERFACE
Describe the main tables involved in Inventory?
Ans :
INV Base Tables
mtl_system_items_b
mtl_item_locations
mtl_item_categories
cst_item_costs
hr_all_organization_units
INV Interface Tables
MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
(If importing revisions)
MTL_ITEM_CATEGORIES_INTERFACE (If importing categories)
MTL_INTERFACE_ERRORS (View errors after import)
Describe the main tables involved in Purchasing?
Ans :
PO Base Tables
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL
PO_HEADERS_ALL
PO_LINES_ALL
PO_VENDORS
PO_VENDOR_SITES_ALL
PO Interface Tables
PO_HEADER_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO_INTERFACE_ERROR
Describe the main tables involved in Application Developer Module?
FND_USER
FND_CONCURRENT_PROGRAM
FND_CURRENCY
FND_LOOKUP
FND_APPLICATION
How to register a Form to invoke it from Menu?
Ans :
A)Open up TEMPLATE.fmb, and save this as XXHELLOAPPS.fmb
B) Create a new window, by right clicking on Window/new
Name this window as XXHELLOAPPS,and assign it SubClass Type “WINDOW” from picklist.
C) Create a new canvas and name it XXHELLOAPPS , ensuring its Sublcass Type is “Content”
D) Make the windows property reference canvas XXHELLOAPPS and vice versa make the canvas reference windows XXHELLOAPPS.
E) Now create a block named XXHELLOAPPS . Lets keep this a control block for simplicity.
F) go to form level property, and set first navigation block to XXHELLOAPPS.
G) Add a label and a field named “Hello_World” to this block.
H) Generate the form on PC using Control-T keystrokes. This will ensure that nothing critical has been missed out.
I) FTP the form file to $XXPO_TOP/forms/US
Surely, this XX will be replaced by the naming convention at your client/company.
J) cd to $XXPO_TOP/forms/US
And f60gen on XXHELLOAPPS.fmb
This will create a file executable as XXHELLOAPPS.fmx
[command : f60gen module=XXORIG.fmb userid=$USER_APPS/$PASS_APPS output_file=XXORIG.fmx compile_all=yes]
K) Go to Application Developer responsibility
Menu /applicaton/form
Register the form
L) Register the Forms Function
Have you read he article form functions[http://getappstraining.blogspot.com/2006/10/oracle-forms-functions-menus-and-their.html] yet?
This forms function must be registered against application “XX Purchasing”.
M) Now add a menu item so that this forms function becomes available to specific responsibility.
Thats it, you will be able to open up this form from the responsibility.
How to create an BI Publisher Report?
Ans : http://www.scribd.com/doc/30749065/How-to-Create-Reports-in-BI-Publisher-UI
What are steps involve in Data conversion activity.
Ans :
1 ) Provide sample data in the prescribed format.
2) Upload to staging
3) Validate
4) move to interface tables by custom or seeded interface concurrent program
5) Finally move the data to base from interface tables.
What is the difference between upgrade and migration?
Ans : Upgrade is moving from one version to another. It may include database upgrade also.
Migration is uploading data to the existing system, it could be from a traditional legacy system or from a third party system.
Where we monitor concurrent manager and names of different type of Concurrent Managers?
Ans :
System Administrator > Concurrent: Managers > Administer
Conflict Resolution Manager (CRM)
Product Specific Concurrent Manager
Internal Concurrent Manager (ICM)
Scheduler Manager
Standard Manager
Transaction Managers
LikeLike
18. What are steps involve in Data conversion activity.
A18 steps are:
a) Identify the source data
b) Load data into oracle staging tables.
c) Do basic technical validation and business validation.
d) Load data to interface table and Call concurrent program to load data from interface table to base table.
OR
e) Write program to do business and functional validation and call API to load data to base tables.
f) Verify the data in target instance and error / load reporting.
LikeLike
5.How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password (and rightly so)?
A5. Create the concurrent program based on the script as executable and assign it to the user so that user can run the program from the application.
LikeLike
Q1.What are the key benefits of forms personalization over custom.pll?
A1
1) Easy portablility of changes done to forms
2) No need of Extensive technical knowledge to do plsql coding in Custom.pll
3) Upgrades of forms is more easy.
LikeLike
Q6. What are the basic steps when defining a concurrent program?
A6
1. Develop the procedure as per client requirements.
2. Create Executable with execution method as PL/SQL stored procedure/
3. Create Concurrent Program attach Executables, Parameters, Incompatibilities.
4. we will attach this concurrent program to request group.
5. Attach request group to responsibilities
6. Attach the responsibilities to user with submit from SRS window.
LikeLike
Q16.How to register a Form to invoke it from Menu?
A16. Forms Development and Registration Steps:
1.Download Template .fmb from AU top//Resource folder.
2.Delete existing Canvas, Window, Data Block having the name called ‘Block_name’ then create new Canvas, Window, Data Block.
3.Assign the Standard oracle Applications Property classes to the new Objects.
4.Customize the following triggers at form level.
a. Pre_form -> Used for New Window
b. When_new_form Instance -> Used for new form
c APP_Custom Package -> Used for First Window
5. Transfer the .fmb into Corresponding path according to module. Ex:- PO/11.5.0/Forms/US -> for PO module
6.Compile the form we will get .FMB(ctrl+K) then execute the form we will get .FMX(Ctrl+T)
7.Select application Developer Responsibility and create the form
8.Create the Function attach the Form to Function.
9.Create Menu attach the Function to menu.
10.Create Responsibilty attach menu to Responsibilty and Responsibilty will be attach to user.
LikeLike
What are the various report triggers? What is their order of firing?
Ans : There are eight report triggers.
Global triggers called the Report Triggers :
(1) Before Parameter Form
(2) After Parameter Form
(3) Before Report
(4) After Report
(5) Between Pages
Other Triggers :
(1) Validation Triggers
(2) Format Triggers
(3) Action Triggers
Report Triggers Firing Sequence:
i) Before parameter form trigger
ii)After Parameter form trigger
iii)Before report trigger
iv)Between pages trigger
v)After report trigger
LikeLike
What are the more common pseudo-columns?
Ans:
CURRVAL –> Returns the current value of a sequence.
NEXTVAL –> Returns the next value of a sequence.
NULL –> Return a null value.
ROWID –> Returns the ROWID of a row.
ROWNUM –> Returns the number indicating in which order Oracle selects rows.
For First row rownum = 1 and for Second rownum 2 and so on.
SYSDATE –> Returns current date and time.
USER –> Returns the name of the current user.
UID –> Returns the unique number assigned to the current user
LikeLike
What are the basic steps when defining a concurrent program?
The steps to register concurrent programs in apps are as follows :
· Register the program as concurrent executable.
· Define the concurrent program for the executable registered.
· Add the concurrent program to the request group of the responsibility
What are the more common pseudo-columns?
SYSDATE, USER , UID, CURVAL, NEXTVAL, ROWID, ROWNUM
LikeLike
Describe the main tables involved in Inventory
MTL_CATEGORIES_B is the code combinations table for item categories.
MTL_CATEGORY_SETS_B contains the entity definition for category sets.
MTL_ITEM_CATEGORIES stores the item assignments to categories within a category set.
MTL_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item.
RCV_TRANSACTIONS – It stores historical information about receiving transactions that you have performed.
RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES
When a Ship Confirm is processed, one record is inserted in rcv_shipment_headers and one record is inserted in rcv_shipment_lines for each of the Sales Order Lines. The rcv_shipment_lines are linked to the one rcv_shipment_header record by shipment_header_id.
Describe the main tables involved in Purchasing?
po_requisition_headers_all
po_requisition_lines_all
po_req_distributions_all
po_headers_all
po_lines_all
po_distributions_all
rcv_transactions
po_requisitions_interface_all
po_reschedule_interface
po_headers_interface
po_lines_interface
po_distributions_interface
LikeLike
What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command.
Hence DELETE operation can be rolled back, but TRUNCATE
operation cannot be rolled back. WHERE clause can be used
with DELETE and not with TRUNCATE.
Describe the main tables involved in AR?
RA_BATCHES_ALL
– INFORMATION ABOUT TRANSACTION BATCHES
RA_CUSTOMER_TRX_ALL
– HEADER INFORMATION ABOUT TRANSACTION
RA_CUSTOMER_TRX_LINES_ALL
– LINES INFORMATION ABOUT TRANSACTION
RA_CUST_TRX_LINE_GL_DIST_ALL
– DISTRIBUTION INFORMATION ABOUT TRANSACTIONS
RA_CUST_TRX_LINE_SALESREPS_ALL
– SALES REPS OF TRANSACTIONS INFORMATION
AR_PAYMENT_SCHDULES_ALL
– INFORMATION ABOUT PAYMENT SCHDULES
AR_APPLICATION_PAYABLES_ALL
RA_INTERFACE_ERRORS
– ERRORS IN AUTO INVOCIE INTERFACE DATA
RA_INTERFACE_LINES_ALL
– USE THIS TABLE TO ENTER HEADER AND LINES INFORMATION IN AUTO INVOICE INTERFACE PROGRAM
RA_INTERFACE_DISTRIBUTIONS_ALL
– DISTRIBUTION TABLE IN AUTO INVOICE INTERFACE PROGRAM
RA_INTERFACE_SALESCREDITS_ALL
– SALESCREDITS INFORMATION TABLE IN AUTO INVOICE INTERFACE PROGRAM
Describe the main tables involved in AP?
AP_INVOICES_ALL – AP_INVOICES_ALL contains records for invoices you enter
AP_INVOICE_DISTRIBUTIONS_ALL – AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution line
information that you enter for invoices.
AP_EXPENSE_REPORT_HEADERS_ALL
AP_EXPENSE_REPORT_LINES_ALL -Expense Report information is stored
AP_AE_HEADERS_ALL
AP_AE_LINES_ALL
AP_INVOICE_PAYMENTS_ALL
AP_PAYMENT_DISTRIBUTIONS_ALL
Describe the main tables involved in GL?
GL_INTERFACE – (For Journal Import) is the table you use to import journal entry batches through Journal Import.
GL_JE_CATEGORIES_TL stores journal entry categories.
Gl_JE_BATCHES – Stores journal entry batches. Each row includes the batch name, description, status,running total debits and credits, and other information.
GL_JE_HEADERS – hEADER LEVEL INFORMATION JE
GL_JE_LINES – Stores the journal entry lines that you enter in the Enter Journals form.
GL_CODE_COMBINATIONS –
GL_BALANCES
GL_DAILY_RATES
GL_PERIODS :Stores information about the accounting periods you define using the Accounting Calendar form.
GL_PERIOD_TYPES stores the period types you define using the Period Types form.
GL_SETS_OF_BOOKS stores information about the sets of books you define in your Oracle General Ledger application.
GL_DAILY_BALANCES
GL_CONSOLIDATION
LikeLike
What are the key benefits of forms personalization over custom.pll
# Many users can develop form personalization at a given time.
# By using form personalization it becomes fairly easy to enable and disable forms personalization.
# Hide/disable fields or buttons functionality is removed.
# Provides more visibility on customizations to the screen
How can you import invoices into Oracle Receivables?
This can be done in two ways defines below:
We can either use AutoInvoice. Which can be possible by populating following table name RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL and RA_INTERFACE_SALESCREDITS_ALL.
Alternately by using API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.
Which responsibility do you need to extract Self Service Personalizations?
–Functional Administrator
LikeLike