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 .
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 to know the number of invoices generated for one PO from front end (navigation)?
is UOM maintained at master level or organization level or both?
whats the use of after parameter form and before report?
what is mean by confine mode and flexi mode?
In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
In Per_all_people_f table what is the significance of '_f ' ?
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 .
Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?
what is meant by bind parameter?
how can i print random rows in plsql table