Can't seem to get the distribution account to build when importing project related invoices through
I'm on 11.5.10.2 and I'm passing the following information for project related invoices, however when I run the payables import program it fails with account overlay errors.
( invoice_id,
invoice_line_id,
line_number,
line_type_lookup_code,
amount,
dist_code_concatenated, --null when project data provided
description,
creation_date,
project_id,
task_id,
expenditure_type,
expenditure_organization_id,
expenditure_item_date
)
values
( ap_invoices_s.currval,
ap_invoice_lines_interface_s.nextval,
Is there something else I should be passing?
I'd prefer not to have to call the project account generator from my sql code if it's avoidable.
insert into ap_invoice_lines_interface( invoice_id,
invoice_line_id,
line_number,
line_type_lookup_code,
amount,
dist_code_concatenated, --null when project data provided
description,
creation_date,
project_id,
task_id,
expenditure_type,
expenditure_organization_id,
expenditure_item_date
)
values
( ap_invoices_s.currval,
ap_invoice_lines_interface_s.nextval,
Tagged:
0