-
Kranthi Reddy Mula posted an update in the group Oracle Financials 12 years, 5 months ago
Hi,
I have done payable invoice import for this i populated both ap_invoice_interface and ap_invoice_lines_inteface and i ran the payable open invoice import,but my problem is
Data is being populated in both invoice headers and invoice lines but not data is not populating invoice distributions table.Please let me know.
It’s very urgent issue .
thanks in advance.Kranthi Mula.
Are u creating invoice with PO information ? Could you share what fields u populated in invoice_lines_interface ?
Distributions information is derived from invoice_lines_interface, I am guessing you didn’t populate some information.
Refer http://docs.oracle.com/cd/A60725_05/html/comnls/us/ap/openin02.htm
Hi,
Here am not passing any PO info.yesterday i researched something on this when i run the payable open invoice import only distributions table is not populating,but in invoice workbench form distributions are appearing. and once i validate the invoice from application level then distribution table getting reflecting.
Pls can you let me know how to validate the invoice from back end? it may solve my problem.
INSERT INTO ap_invoice_lines_interface
(invoice_id,
invoice_line_id,
line_number, line_type_lookup_code, amount,
accounting_date, last_update_date,
creation_date, org_id,DIST_CODE_COMBINATION_ID
— ,DISTRIBUTION_SET_ID
,DIST_CODE_CONCATENATED
)
VALUES (ap_invoices_interface_s.CURRVAL,
ap_invoice_lines_interface_s.NEXTVAL,
j.LINE_NUMBER, ‘ITEM’, j.LINE_AMOUNT,
j.gl_date, SYSDATE,
SYSDATE,l_org_id,l_dist_cc_id
— ,ap_distribution_sets_s.nextval
,j.DIST_ACCOUNT
);
These are the columns am populating into interface table.
Thanks,
Kranthi.