what could be the problem if invoice_id is same in
ap_invoices_all and ap_invoices_interface.
while the Ord_id , invoice_num, and other things is
diffrent .
- 3 Answers
- 15202 Views
- Infosys, Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharat
it is having no problem,because invoice id of the interface
table and base table are generated using different sequence
value so it is very rare that they will match.
AS The rest inforemation is matching
invoice is created correctly.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / shiva
There is no chance of being the invoice_id of
ap_invoices_all and ap_invoices_interface to be same. Since
the invoice_id will be first generated in
ap_invoices_interface table, then later running the
standard program the data from the standard table will be
moved to the base table. Hence there will be no chance of
being the invoice_id is same in both ap_invoice_interface
and ap_invoices_all table.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / kris
Invoice_id has to be same in interface and base tables as
you are first populating invoice_id in interface table
through a sequence.
It is not possible that the data in interface and base
table can mismatch for the same invoice_id.
| Is This Answer Correct ? | 2 Yes | 9 No |
Except the SRS window in which we can submit the concurrent program.
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
How to find which company will be conducted Oracle appa interview? Plz help me
what is the differences between internal requisition and internal sales order?
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
Who information?s?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Registering parametric report?
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
what are the match approvals in PO?
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
Oracle Apps Technical 
