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

Last updated on NOVEMBER 04, 2016

Applies to:

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

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms