My Oracle Support Banner

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

Last updated on APRIL 16, 2020

Applies to:

Oracle Payables - Version to [Release 11.5]
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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