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
- 17317 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 |
What is the difference between buyer&employee in PO module?
what type of testing u r doing?
In oracle application how do you debug or trace errors?
How to develop XML report without rdf?
what are the prerequisites for costing transactions?
how many groups we can create for query?
How can u call a standard interface program from sql or pl/sql code?
which parameters passed in report in oracle developer how to pass
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
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 lessthen it must shows some error how we will make?
Who information?s?
tell me the scenarios of between pages in reports
Oracle Apps Technical 
