Discussion in 'Oracle Apps Technical' started by jagadekara, Jan 29, 2015.
I need AP Invoice Interface Sample Script in R12. Does any one have this?
insert into AP_INVOICES_INTERFACE (
'MANUAL INVOICE ENTRY',
insert into AP_INVOICE_LINES_INTERFACE (
With this code I am able to create invoice with lines and distributions.
But I need to insert one Invoice Header with 10000 amount and 3 line item with 2000, 5000 and 3000, and 4 distributions. Means for second line item I need 2 distributions with 1000 and 4000 amounts.
So how can I achieve this?
You can have 1 invoice header with multiple line items: in your case, you can have something like:
However, it's not possible to have 2 distribution lines for 1 invoice line.
The Payables Open Interface Import process currently does not support entering one invoice line with multiple distributions. There's a request for enhancement (ER) which has been logged with Oracle to request the ability to have multiple distributions for each line when importing invoices. Please see note 1279776.1 and ER 10087267 for more information.
However, as a work around you can use a distribution set to generate multiple distributions.
You need to specify a distribution set in the row in AP_INVOICE_LINES_INTERFACE.Distribution_Set_Name or AP_INVOICE_LINES_INTERFACE.Distribution_Set_ID.
Thank you so much Rajen.