Archives

Oracle Apps Interview Questions › Author "shailenderoracleappsdna-com"
Filter:QuestionsSubscribes
What is Multi Org Flow in Oracle Apps?
ResolvedQuestions Master asked 11 years ago • 
4062 views0 answers0 votes
How do you create a table validated value set dependent on another value set?
ResolvedQuestions Master asked 11 years ago • 
10656 views0 answers0 votes
How to ensure that only one instance of a concurrent program runs at a time?
ResolvedQuestions Master asked 11 years ago • 
4430 views0 answers0 votes
How to submit a concurrent request directly from the operating system(unix)?
ResolvedQuestions Master asked 11 years ago • 
3301 views0 answers0 votes
How to generate a trace file for a PL/SQL based concurrent program?
ResolvedQuestions Master asked 11 years ago • 
5060 views0 answers0 votes
How to "write" to the concurrent request Log and Output?
ResolvedQuestions Master asked 11 years ago • 
5871 views0 answers0 votes
List all different types of Data Types in PL/SQL?
ResolvedQuestions Master asked 11 years ago • 
5241 views0 answers0 votes
What is %TYPE and %ROWTYPE in PL/SQL??
ResolvedQuestions Master asked 11 years ago • 
5412 views0 answers0 votes
What is the disadvantage of using %ROWTYPE in PL/SQL?
ResolvedQuestions Master asked 11 years ago • 
6085 views0 answers0 votes
What is difference between % ROWTYPE and TYPE RECORD?
ResolvedQuestions Master asked 11 years ago • 
9766 views0 answers0 votes
What are the Disadvantages of Cursor Variables?
ResolvedQuestions Master asked 11 years ago • 
5611 views0 answers0 votes
What is Cursor Variables or REF CURSOR ?
ResolvedQuestions Master asked 11 years ago • 
5347 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 11 years ago • 
5241 views0 answers0 votes
Is it mandatory to close the Cursor in a PL/SQL block ?
ResolvedQuestions Master asked 11 years ago • 
5260 views0 answers0 votes
What is the different between Analytic and Group function in SQL?
ResolvedQuestions Master asked 11 years ago • 
5672 views0 answers0 votes
How to find SQL statements which takes more time to run on Database?
ResolvedQuestions Master asked 11 years ago • 
4136 views0 answers0 votes
What is the purpose of WHERE CURRENT OF statement in PL/SQL?
ResolvedQuestions Master asked 11 years ago • 
4918 views0 answers0 votes
How to avoid usage of Cursors in PL/SQL?
ResolvedQuestions Master asked 11 years ago • 
5119 views0 answers0 votes
What are the different stages of Sales Order Lines Status in life cycle of a Sales Order?
OpenQuestions Master asked 11 years ago • 
6649 views0 answers0 votes
What are the different stages of Sales Order Header Status in life cycle of a Sales Order?
OpenQuestions Master asked 11 years ago • 
5977 views0 answers0 votes
How to make an Item eligible for Customer Order in Sales Orders?
OpenQuestions Master asked 11 years ago • 
6163 views0 answers0 votes
What are the different types of Sales Orders in Order Management?
OpenQuestions Master asked 11 years ago • 
32557 views0 answers0 votes
What is BULK COLLECT in PL/SQL?
ResolvedQuestions Master asked 11 years ago • 
7057 views0 answers0 votes
What is Workflow Background Process?
ResolvedQuestions Master asked 11 years ago • 
2074 views0 answers0 votes
How is Workflow Background Process called from both back end and front end?
ResolvedQuestions Master asked 11 years ago • 
4920 views0 answers0 votes
Why should Workflow Background Process be scheduled to run in frequent intervals?
ResolvedQuestions Master asked 11 years ago • 
2093 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 11 years ago • 
1856 views0 answers0 votes
What is ITEM TYPE in workflows?
ResolvedQuestions Master asked 11 years ago • 
2592 views0 answers0 votes
What is Item Key in Workflows?
ResolvedQuestions Master asked 11 years ago • 
3592 views0 answers0 votes
What is Logical Apps in brief ???
ResolvedQuestions Master asked 11 years ago • 
3166 views0 answers0 votes
Name any 5 PL/SQL exception types
ResolvedQuestions Master asked 11 years ago • 
6777 views0 answers0 votes
What is the difference between Views and Materialized Views in Oracle?
ResolvedQuestions Master asked 11 years ago • 
5611 views0 answers0 votes
What is difference between a PROCEDURE & a FUNCTION ?
ResolvedQuestions Master asked 11 years ago • 
5225 views0 answers0 votes
What are the Advantages of Using Database Triggers??
ResolvedQuestions Master asked 11 years ago • 
5253 views0 answers0 votes
How is the Cursor declared in Procedure is different from Cursor defined in Package Specification?
ResolvedQuestions Master asked 11 years ago • 
4265 views0 answers0 votes
What is RAISE_APPLICATION_ERROR in PL/SQL Exception handling??
ResolvedQuestions Master asked 11 years ago • 
4917 views0 answers0 votes
What is PRAGMA EXECPTION_INIT?
ResolvedQuestions Master asked 11 years ago • 
5173 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 11 years ago • 
4630 views0 answers0 votes
What are two virtual tables available during database trigger execution in PL/SQL?
ResolvedQuestions Master asked 11 years ago • 
7466 views0 answers0 votes
Why cant we use SQLERRM and SQLCODE in INSERT Statement?
ResolvedQuestions Master asked 11 years ago • 
4483 views0 answers0 votes
1234…6