R12: Reqimport Error "GL date is not in a valid inventory calendar" When Profile Option PO:Validate GL period = Redefault (Doc ID 1663694.1)

Last updated on MAY 11, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Requisition Import with profile option
PO:Validate GL period - ‘Redefault’, the following error occurs
even though the Purchasing, General Ledger and Inventory periods are in OPEN status


ERROR

GL date is not in a valid inventory calendar and open period
Cause: GL date must be in a valid period inventory calendar and open period for a source type of 'INVENTORY' if encumbrance is ON.


Steps to reproduce:

1. Set the profile option PO:Validate GL period - ‘Redefault’
2. Try to import a Internal requisition with new set of data with the suggested script
3. All the PO, INV and GL periods are OPEN status
4. Error is logged in PO_INTERFACE_ERRORS table

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