GL Date Not Assigned Properly in Payables Open Interface Import
Last updated on NOVEMBER 04, 2016
Applies to:Oracle Payables - Version 18.104.22.168 to 22.214.171.124 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms