Answer / dinesh

For example if you want to upload the data from
ap_supplier_site_int interface table to its base table, Run
the standard interface program called Supplier sites open
interface import. which will upload the Data.

All the validations for duplicates checking should be done
in the staging table level..As no validation can be done
from in to base table.

Thanks,
Dinesh.

Answer / srinibas

It is good question
i m giving a example to under stand this
suppose we have make some invoice transaction in payable
module.and we need to transafer them to the gl module.
first run the payable trnsfer to gl program
after running this program the data go to the gl interface
table.
so u need to import them to the gl table
just go to gl module and import the data which are exist in
the gl interface table to gl base table
in ap and ar module there are certain import program
avilable to transfer data from interface to base table also
for example-payable invoice import program,auto invoice
import program etc.

srinibas
oracle_sri08@rediffmail.com

Answer / amit

I never heard this question before in my last 4 years Apps
career.
When interface tables and base tables are part of oracle
package, it is Oracle responsibility to supply you the
interface programme name to do this job.There are different
interface programs specific to a module as part of Oracle
seeded inbound programs which generally do these activities.

Answer / charan

Interface:Before validate the data will store in interface
tables.
Base Tables: After validate the data will store in base tables

Can you end-date the SOB's in 11i or in R12 version?

5 Answers   Oracle,

---

We have raised the requisition and PO, and also raised the Invoice and made the payment but did not match with PO. What we need to do with that pending PO ?

4 Answers   HP, Oracle,

---

What do you mean by Category Set ? and what is its Relevance ?

0 Answers   FIC, IBM, Wipro,

---

How many views are generated when compiling flexfield structure ?

1 Answers   Oracle,

---

Give examples & explain the below mentioned activity. "Analyzing the documents provided by the client and thereby identifying the test cases to be tested for the application assigned (FA, AP and GL)"

0 Answers   IBM,

---

---

What is multi org? What is difference between 11i and 12i multi org structure?

0 Answers  

---

I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.

0 Answers   Student, TCS,

---

At what level FA is implemented?

13 Answers   DELL,

---

in Oracle Payable s we are not matching Po how to clear accrual account in P2p cycle?

1 Answers   Hitachi,

---

why we need to run "Payables accounting process" for interest invoices? What are the accounting entries created?

1 Answers  

---

If the COA of the parent and child are difference then how will the consolidation be done?

1 Answers  

---

what is accounting entry once we receive GRN and inventory accounting.?

3 Answers   Ernst Young, Tech Mahindra,

---