OracleAppsDNA

Oracle Apps Interview Questions

Filter:AllOpenResolvedClosedUnanswered
What is PRAGMA keyword in Oracle PL/SQL?
AnsweredQuestions Master asked 9 years ago • 
2551 views0 answers0 votes
How to display a number in words?
AnsweredQuestions Master asked 9 years ago • 
2927 views0 answers0 votes
How to select odd number records from a table?
AnsweredQuestions Master asked 9 years ago • 
2807 views0 answers0 votes
When to use EXISTS over IN?
AnsweredQuestions Master asked 9 years ago • 
2833 views0 answers0 votes
To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause?
AnsweredQuestions Master asked 9 years ago • 
2495 views0 answers0 votes
To optimize the performance of an SQL statement what should be the order of tables in FROM clause?
AnsweredQuestions Master asked 9 years ago • 
2751 views0 answers0 votes
What is the standard execution sequence of an SQL Statement followed by Oracle Database engine?
AnsweredQuestions Master asked 9 years ago • 
2342 views0 answers0 votes
How to find record count of a table without using count(*) ?
AnsweredQuestions Master asked 9 years ago • 
3063 views0 answers0 votes
Where does the concurrent request log files and output files go ? where are they stored in database?
AnsweredAnonymous asked 9 years ago • 
7528 views0 answers0 votes
What is the structure of DUAL table?
AnsweredQuestions Master asked 9 years ago • 
2776 views0 answers0 votes
what is the diffrence between EXISTS and IN? when to use EXISTS and when to use IN?
AnsweredAnonymous asked 9 years ago • 
2329 views0 answers0 votes
What is the difference between ORG_ID and Organization_id?
OpenAnonymous asked 9 years ago • 
2106 views0 answers0 votes
What is a Work Structure or define work structure?
OpenAnonymous asked 9 years ago • 
2022 views0 answers0 votes
A table is uploaded with partial number of records and then a table is created without using a commit on the previous table. How many records do we find in a different session?
ResolvedAnonymous asked 9 years ago • 
1618 views0 answers0 votes
how to Call Fast Formula from PL/SQL
ResolvedAnonymous asked 9 years ago • 
4125 views0 answers0 votes
Lets say there is a table with 500 rows. Write a query to display rows from 101 to 500.
ResolvedAnonymous asked 9 years ago • 
2912 views0 answers0 votes
Query to find records inserted in last 2 hours
ResolvedAnonymous asked 9 years ago • 
14605 views0 answers0 votes
Using decode function how do determine a given value is greaten zero or less zero or zero?
OpenAnonymous asked 9 years ago • 
1601 views0 answers0 votes
How do you check whether a given string has only the alpha numerics (a-z or A-Z or 0-9)
OpenAnonymous asked 9 years ago • 
1411 views0 answers0 votes
How to Add Preparer full name of the Requsition in PO Communication Layout Template
AnsweredAnonymous asked 9 years ago • 
1746 views0 answers0 votes
How to hide a Submit button on Workflow Notification.
AnsweredAnonymous asked 9 years ago • 
3532 views0 answers0 votes
interface
OpenAnonymous asked 9 years ago • 
1710 views0 answers0 votes
I am trying create new account in SOLUTION BECAN for practising oracle apps but they ask CSI NUMBER I don’t know CSI number please help me anyone?
AnsweredAnonymous asked 9 years ago • 
2159 views0 answers0 votes
How to display the GL Periods in order (like Jan,Feb,Mar…..)
ResolvedAnonymous asked 10 years ago • 
4476 views0 answers0 votes
What is Available to Reserve & Available to Transact??
ResolvedQuestions Master asked 9 years ago • 
2988 views0 answers0 votes
What is Trip Stops in Order Management?
OpenQuestions Master asked 9 years ago • 
10858 views0 answers0 votes
What is Delivery legs in Order Management?
OpenQuestions Master asked 9 years ago • 
5338 views0 answers0 votes
What are Deliveries in Order Management?
OpenQuestions Master asked 9 years ago • 
4577 views0 answers0 votes
What are Delivery Lines in Order Management?
OpenQuestions Master asked 9 years ago • 
3844 views0 answers0 votes
What are LPN’s in Oracle Apps?
OpenQuestions Master asked 9 years ago • 
7113 views0 answers0 votes
What is Ship From in Order Management?
OpenQuestions Master asked 9 years ago • 
4234 views0 answers0 votes
What is Ship To in Order Management?
OpenQuestions Master asked 9 years ago • 
5232 views0 answers0 votes
Can we use RETURN STATEMENT and RETURN key word in Procedure, if we use what will happen?
ResolvedQuestions Master asked 9 years ago • 
4618 views0 answers0 votes
What is Multi Org in Oracle Apps?
ResolvedQuestions Master asked 9 years ago • 
2942 views0 answers0 votes
What is Multi Org Flow in Oracle Apps?
ResolvedQuestions Master asked 9 years ago • 
2947 views0 answers0 votes
How do you create a table validated value set dependent on another value set?
ResolvedQuestions Master asked 9 years ago • 
9636 views0 answers0 votes
How to ensure that only one instance of a concurrent program runs at a time?
ResolvedQuestions Master asked 9 years ago • 
3483 views0 answers0 votes
How to submit a concurrent request directly from the operating system(unix)?
ResolvedQuestions Master asked 9 years ago • 
2496 views0 answers0 votes
How to generate a trace file for a PL/SQL based concurrent program?
ResolvedQuestions Master asked 9 years ago • 
4128 views0 answers0 votes
How to "write" to the concurrent request Log and Output?
ResolvedQuestions Master asked 9 years ago • 
5057 views0 answers0 votes
1234…8
Exit mobile version