Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16822 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 |
How can u populate data into po_headers_all segment2 column?
define steps of assigning items to an organization.
what are the pl/sql tables
what is unit of measure classes? give atleast two examples. name the underlying table.
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
Where we can write a PL/SQL code in report triggers?
What are the Import Programs We need to run after creating Interface table for all modules
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????
What are documents and test cases u followed.
what are the tables of auto invoice.
Define MultiOrg Structure
Oracle Apps Technical 
