OracleAppsDNA

Oracle Apps Interview Questions

Filter:AllOpenResolvedClosedUnanswered
AP module
ResolvedAnonymous asked 9 years ago • 
1521 views0 answers0 votes
Flexfeilds
ResolvedAnonymous asked 9 years ago • 
1605 views0 answers0 votes
List all different types of Data Types in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
3985 views0 answers0 votes
What is %TYPE and %ROWTYPE in PL/SQL??
ResolvedQuestions Master asked 9 years ago • 
4156 views0 answers0 votes
What is the disadvantage of using %ROWTYPE in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
4854 views0 answers0 votes
What is difference between % ROWTYPE and TYPE RECORD?
ResolvedQuestions Master asked 9 years ago • 
8530 views0 answers0 votes
What are the Disadvantages of Cursor Variables?
ResolvedQuestions Master asked 9 years ago • 
4462 views0 answers0 votes
What is Cursor Variables or REF CURSOR ?
ResolvedQuestions Master asked 9 years ago • 
4144 views0 answers0 votes
Can we write When OTHERS Exception at the beginning of the exception block and some other exceptions after that ?
ResolvedQuestions Master asked 9 years ago • 
3641 views0 answers0 votes
Is it mandatory to close the Cursor in a PL/SQL block ?
ResolvedQuestions Master asked 9 years ago • 
4109 views0 answers0 votes
What is the different between Analytic and Group function in SQL?
ResolvedQuestions Master asked 9 years ago • 
4499 views0 answers0 votes
How to find SQL statements which takes more time to run on Database?
ResolvedQuestions Master asked 9 years ago • 
2994 views0 answers0 votes
What is the purpose of WHERE CURRENT OF statement in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
3810 views0 answers0 votes
How to avoid usage of Cursors in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
3845 views0 answers0 votes
What are the different stages of Sales Order Lines Status in life cycle of a Sales Order?
OpenQuestions Master asked 9 years ago • 
6029 views0 answers0 votes
What are the different stages of Sales Order Header Status in life cycle of a Sales Order?
OpenQuestions Master asked 9 years ago • 
5399 views0 answers0 votes
How to make an Item eligible for Customer Order in Sales Orders?
OpenQuestions Master asked 9 years ago • 
5631 views0 answers0 votes
What are the different types of Sales Orders in Order Management?
OpenQuestions Master asked 9 years ago • 
29666 views0 answers0 votes
What is BULK COLLECT in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
5723 views0 answers0 votes
Can there be any step/procedure of Expiry of a Sales Order whether all shipments have been made or not?
OpenAnonymous asked 9 years ago • 
3961 views0 answers0 votes
What is Workflow Background Process?
ResolvedQuestions Master asked 9 years ago • 
1456 views0 answers0 votes
How is Workflow Background Process called from both back end and front end?
ResolvedQuestions Master asked 9 years ago • 
4270 views0 answers0 votes
Why should Workflow Background Process be scheduled to run in frequent intervals?
ResolvedQuestions Master asked 9 years ago • 
1481 views0 answers0 votes
In workflows, assume you have two different notifications and upon approval from both the notifications certain action should be performed. How do you achieve this?
ResolvedQuestions Master asked 9 years ago • 
1254 views0 answers0 votes
What is ITEM TYPE in workflows?
ResolvedQuestions Master asked 9 years ago • 
1976 views0 answers0 votes
What is Item Key in Workflows?
ResolvedQuestions Master asked 9 years ago • 
2931 views0 answers0 votes
What is Logical Apps in brief ???
ResolvedQuestions Master asked 9 years ago • 
2462 views0 answers0 votes
What is the purpose of setting grants and roles in order management
OpenAnonymous asked 9 years ago • 
5936 views0 answers0 votes
how to find out table name and column name of OAF page in apps
ResolvedAnonymous asked 9 years ago
5759 views0 answers0 votes
how to debug your pl/sql procedure
OpenAnonymous asked 9 years ago • 
4661 views0 answers0 votes
What is Diagnostics in Oracle Apps??
ResolvedAnonymous asked 9 years ago • 
3299 views0 answers0 votes
Name any 5 PL/SQL exception types
ResolvedQuestions Master asked 9 years ago • 
5433 views0 answers0 votes
What is the difference between Views and Materialized Views in Oracle?
ResolvedQuestions Master asked 9 years ago • 
4445 views0 answers0 votes
What is difference between a PROCEDURE & a FUNCTION ?
ResolvedQuestions Master asked 9 years ago • 
4039 views0 answers0 votes
What are the Advantages of Using Database Triggers??
ResolvedQuestions Master asked 9 years ago • 
4137 views0 answers0 votes
How is the Cursor declared in Procedure is different from Cursor defined in Package Specification?
ResolvedQuestions Master asked 9 years ago • 
3084 views0 answers0 votes
What is RAISE_APPLICATION_ERROR in PL/SQL Exception handling??
ResolvedQuestions Master asked 9 years ago • 
3702 views0 answers0 votes
What is PRAGMA EXECPTION_INIT?
ResolvedQuestions Master asked 9 years ago • 
3979 views0 answers0 votes
What happens if a procedure which updates a column of table X is called in a database trigger of the same table?
ResolvedQuestions Master asked 9 years ago • 
3425 views0 answers0 votes
What are two virtual tables available during database trigger execution in PL/SQL?
ResolvedQuestions Master asked 9 years ago • 
6181 views0 answers0 votes
12345…8
Exit mobile version