OracleAppsDNA

Oracle Apps Interview Questions

Filter:AllOpenResolvedClosedUnanswered
How to display those employees who joined the company before 15 of the month?
ResolvedQuestions Master asked 9 years ago • 
11272 views1 answers0 votes
How to display employee name and his salary whose salary is greater than highest average of department number?
ResolvedQuestions Master asked 9 years ago • 
8944 views1 answers0 votes
How to display those employee whose joining of month and grade is equal?
ResolvedQuestions Master asked 9 years ago • 
5800 views1 answers0 votes
How to display the 10th record of emp table(without using rowid) ?
ResolvedQuestions Master asked 9 years ago • 
9524 views1 answers0 votes
How to display all enames in reverse order? (SMITH:HTIMS)
ResolvedQuestions Master asked 9 years ago • 
6764 views1 answers0 votes
How to display those employee whose joining DATE is available in deptno?
ResolvedQuestions Master asked 9 years ago • 
8122 views1 answers0 votes
How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)
ResolvedQuestions Master asked 9 years ago • 
6493 views1 answers0 votes
How to Delete the rows of employees who are working in the company for more ?
ResolvedQuestions Master asked 9 years ago • 
6109 views1 answers0 votes
Write a Query to Delete The Repeated Rows from emp table?
ResolvedQuestions Master asked 9 years ago • 
8297 views1 answers0 votes
HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
ResolvedQuestions Master asked 9 years ago • 
13228 views1 answers0 votes
How to display 9th record from EMP table?
ResolvedQuestions Master asked 9 years ago • 
14236 views1 answers0 votes
In outbound interface is der any way to load the data (large data-millions of records) except UTL_FILE package?
ResolvedAnonymous asked 9 years ago • 
1346 views1 answers0 votes
How to display the employee name and annual salary for all employees including commission?
ResolvedQuestions Master asked 9 years ago • 
12636 views1 answers0 votes
How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?
ResolvedQuestions Master asked 9 years ago • 
4942 views1 answers0 votes
How to display the names of the employees who are working in the company for the past 5 years?
ResolvedQuestions Master asked 9 years ago • 
13977 views1 answers0 votes
How to display the names of employees whose names have second alphabet A in their names?
ResolvedQuestions Master asked 9 years ago • 
8057 views1 answers0 votes
How to display name,salary,hra,pf,da,total salary for each employee. The output should be in the order of total salary,hra 15% of salary,da 10% of salary,pf 5% salary,total salary will be(salary+hra+da)-pf?
ResolvedQuestions Master asked 9 years ago • 
11772 views1 answers0 votes
How to display the names of clerks who earn a salary more than the lowest salary of any salesman?
ResolvedQuestions Master asked 9 years ago • 
3939 views1 answers0 votes
How to display the names of the employees who earn highest salary in their respective departments?
ResolvedQuestions Master asked 9 years ago • 
22159 views1 answers0 votes
How to display the Job groups having total salary greater than the maximum salary for managers?
ResolvedQuestions Master asked 9 years ago • 
7224 views1 answers0 votes
How to display employee name, dept name, salary and comm for those sal in between 2000 to 5000 while location is Chicago?
ResolvedQuestions Master asked 9 years ago • 
4185 views1 answers0 votes
How to display those employees who are working in the same dept where his manager is work?
ResolvedQuestions Master asked 9 years ago • 
9102 views1 answers0 votes
How to display grade and employees name for the dept no 10 or 30 but grade is not 4 while joined the company before 31-dec-82?
ResolvedQuestions Master asked 9 years ago • 
5292 views1 answers0 votes
PLSQL Clob Document,showing Numeric or value error in the Notification
OpenAnonymous asked 9 years ago • 
1826 views1 answers0 votes
invoice details in AR AND AP MODULES
OpenAnonymous asked 9 years ago • ,
1650 views1 answers0 votes
what r the major difference between 11i and R12 in PO,AP,AR modules? pls post ur comments
OpenAnonymous asked 9 years ago • 
2018 views0 answers0 votes
What are the two different file extensions that are created by Oracle Reports ?
ResolvedQuestions Master asked 9 years ago • 
1895 views1 answers0 votes
Which API used to get the current application user id ?
ResolvedQuestions Master asked 9 years ago • 
4627 views1 answers0 votes
How to skip a Header record in SQL Loader without modifying control file??
ResolvedQuestions Master asked 10 years ago • 
9282 views1 answers0 votes
What are Modifiers and Qualifiers?
ResolvedQuestions Master asked 10 years ago • 
6726 views1 answers0 votes
Why does NULL = NULL Fail in SQL statements?
ResolvedQuestions Master asked 10 years ago • 
2334 views1 answers0 votes
How different is Alert from a database trigger
ResolvedQuestions Master asked 9 years ago • 
6025 views1 answers0 votes
Is there a limit for number of parameters of a concurrent program??
ResolvedQuestions Master asked 9 years ago • 
4969 views1 answers0 votes
How to findout base path of a Custom Application top only from front end ?
ResolvedQuestions Master asked 9 years ago • 
10346 views1 answers0 votes
When you try to update or delete a record in People screen or some other screens in HR Module, a Window appears with two Options for Update or Corrections. What are they?
ResolvedQuestions Master asked 9 years ago • 
1332 views1 answers0 votes
What are the steps involved in Order to Cash (O2C) life cycle?
OpenQuestions Master asked 9 years ago • 
8455 views1 answers0 votes
Why ROWNUM =(> 1) will not work ?
ResolvedQuestions Master asked 9 years ago • 
11778 views1 answers0 votes
What is IN parameter and OUT parameter in PLSQL?
OpenQuestions Master asked 10 years ago • 
3968 views0 answers0 votes
In seeded XMLP reports we see parameters of concurrent program are defined as variables in package , but why is this followed?
OpenQuestions Master asked 10 years ago • 
1591 views1 answers0 votes
What is a trigger and what is the difference between Row Level and Statement Level trigger??
OpenQuestions Master asked 10 years ago • 
4796 views0 answers0 votes
1…5678
Exit mobile version