PO:Validate GL Period -Redefault With Null GL Date Doesn't Work For REQIMPORT Process

(Doc ID 1683716.1)

Last updated on OCTOBER 06, 2014

Applies to:

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


On : 12.1.3 version, Accounting related

When attempting to import  requisition via Requisition Import Process with profile option PO:Validate GL period - Redefault ang GL date as NULL  , the following error occurs :

GL date must be in a valid period if encumbrance is ON

The issue can be reproduced at will with the following steps:

1. Set the profile option PO:Validate GL period - Redefault

2. All the PO, INV and GL periods are OPEN status

3. Populate the data  into the PO_REQUISITIONS_INTERFACE_ALL by using the below query

 values ('IMPORT_INT', --Interface Source
 204, --Operating Unit
 'INVENTORY', --Destination Type
 'INCOMPLETE', --Status
 29, --This comes from per_people_f.person_id
 13401, --Code Combination ID from Inventory  Org Parameters
 'INVENTORY', --Source Type
 'Each', --UOM
 1, --Line Type of Goods
 25, --quantity
 207, --Represents M1 Seattle.
 207, --Represents M1-Seattle
 29, --This is the Deliver to Requestor
 484, --Item CM96713
 NULL,-------GL Date
 13401, ----Encumbarnce Account from Inventory  Org Parameters  or Sub
 sysdate+2 --Need By Date

4. Run the Requistion Import program 

5. PO_INTERFACE_ERRORS shows the above error


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