GL Date Not Assigned Properly in Payables Open Interface Import (Doc ID 2023234.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Payables Open Interface Import(APXIIMPT) assigns a value to GL Date from the first source
it finds, and it searches the following sources in the following order:
1) GL Date field in invoice record line, if not at line then look at
2) GL Date field in invoice record header, if not not at header look at
3) GL Date parameter from import submission,if not entered at submission look
4) GL Date Basis Payables option

When importing invoice from Pay On Receipt AutoInvoice(POXPOIV) -> APXIIMPT,
as 1), 2), 3) are null, it should refer to 4)GL Date Basis Payables option.

But when user set GL Date Basis to "Goods Received / System Date",
after import, GL date was set by System Date instead of Goods Received Date though the Goods Received Date was not null.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.