1. How to move the one file from one instance to another instance? And your scripts also?

Using FNDLOAD commands, which creates.ldt files and import
those .ldt files in new instance using same command.

2. What is instead of trigger in where we will use?

Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.

4. How to Create a purchase order without a requisition?

We can create po three ways
(1)required sheet->requisition->RFQ->Quotation->po
(2) required sheet->requisition->po
(3) required sheet-po(with out requisition for po)

5. i have 3 parameters like p1,p2,p3. In p1 i have 2 parameters like a,b.if pass parameter a p2 should be enable and p3 should be disable then if pass parameter b the vice versa?

you can create two more dummy parameters(like
p2_dummy,p3_dummmy ) and set display property to no.

now set the default value for p2_dummy as "decode
(p1,'a','Y',null) in the same way for p3_dummmy.

now in the valueset for p2 use where $FLEX$.p2_dummy ='Y'
and similarly for p3.

6. Tell me how to find the custom directory in front end?

From Application Developer responsibility, navigate to
Application --> Register. Query for the custom application
name. The value in the field Basepath, is the OS system
variable that stores the actual directory info.

7. Suppose for report i have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is less then it must shows some error how we will make?

while defining Parameters you can set range option(in
concurrent prog parameters window).
Select low for from_Date and high for to_Date.Then it will
not allow for from_date > to_date.

8. 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

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. 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.

Download Interview PDF