Oracle Apps Technical Interview Preparation Guide
Download PDF

Oracle Apps Technical frequently Asked Questions in various Oracle Apps Technical job Interviews by interviewer. The set of Oracle Apps Technical interview questions here ensures that you offer a perfect answer to the interview questions posed to you. Get preparation of Oracle Apps Technical job interview

17 Oracle Apps Technical Questions and Answers:

1 :: Tell me how to debug the report?

Set the profile option Concurrent: Debug Level to 5.
Run the report and get the debug log.

2 :: Do you know is it possible to run the interface without using oracle apps?

The Oracle standard interface code stays in the oracle apps
database in the form of PL/SQL routines. Without the
database up and running, we can not run the interface code.
After all why do we run the interface, when the oracle apps
is not available.

3 :: What is count(*) from po_vendors(any table)? What does it do and
What is count(1) from po_vendors(any table)?
What is count(0) from po_vendors(any table)
the out put is same what is the difference?

Result if count(*), count(1), count(0) will be same.

Howevenr,

When we use count(*) then
first oracle query executer gets all the rows in buffure
cache, including all column and then counts all the rows.
this will impact with less performance.


select count(1) or count(0)
This reduces unwanted I/O by selecting just '1' against all
the rows.


Best practice to getting rowcount of table is

select count(rowid) from table_name;

4 :: Do you know where we can check the status of po?

in po_headers_all authorization_status coloumn is their
we can find through this coloumn
select distinct authorization_status from po_headers_all

5 :: What is pick selection list generation report?

shiping >>release sales order>>release sales order

after releasing sales order

after executing release sales order automatically 3
concurrent programs will run

one of the conc prg is pick selection list

the output of conc prg tells what orders has been booked

6 :: What is back order in OM?

There are few reasons that a scheduled order could be
backordered during pick release process.

1. In-sufficient onhand
2. Order might be put as 'Pick release hold'
3. If it's a lot controlled item being involved then some
of the factors will be checking at picking rule setup (like
Lot- expiration date, etc) and tured to 'Backordered'
incase the criteria does not meet.

7 :: What are the error tables in OM?

In Order ManagementOM) Error Tables are as follows

1.OE_EXP_INTERFACE_ERRORS
2.OE_UPGRADE_ERRORS

8 :: Tell me where we find the status of order information?

Order header status is in oe_order_headers_all table
reference with flow_status_code column and order line
status would be oe_order_lines_all table reference with
flow_status_code column.

9 :: Explain what are the tables of auto invoice?

RA_INTERFACE_LINES_ALL ,
RA_INTERFACE_DISTRIBUTIONS_ALL ARE THE TWO INTERFACE TABLES
MAINLY USED BT AUTOINVOICE.

FURTHER DATA READ FROM THESE TABLES WILL BE INSERTED INTO
RA_CUSTOMER_TRX_ALL , TA_CUSTOMER_TRX_LINES_ALL ,
RA_CUST_TRX_LINE_GL_DIST_ALL , AR_PAYMENT_SCHEDULES_ALL
AFTER VALIDATING.

10 :: What is the difference between request group and request security group in oracle apps?

Request group is where the concurrent programs are attached
to which internally make them available under a
responsibility that the request group is attached to. If
request groups won't be there the program will not be
visible to the user who has a responsibilty attahced.
Data group is nothing but the data base user details with
oracle apps connects UI to DB