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.

Symptoms

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 :

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

STEPS TO REPRODUCE THE ISSUE
-------------------------------------------------
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

 Insert into PO_REQUISITIONS_INTERFACE_ALL
 (INTERFACE_SOURCE_CODE,
 ORG_ID,
 DESTINATION_TYPE_CODE,
 AUTHORIZATION_STATUS,
 PREPARER_ID,
 CHARGE_ACCOUNT_ID,
 SOURCE_TYPE_CODE,
 SOURCE_ORGANIZATION_ID,
 UNIT_OF_MEASURE,
 LINE_TYPE_ID,
 QUANTITY,
 DESTINATION_ORGANIZATION_ID,
 DELIVER_TO_LOCATION_ID,
 DELIVER_TO_REQUESTOR_ID,
 ITEM_ID,
 GL_DATE,
 BUDGET_ACCOUNT_ID,
 NEED_BY_DATE)
 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
 208,
 '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
 Inventory
 sysdate+2 --Need By Date
 );

4. Run the Requistion Import program 

5. PO_INTERFACE_ERRORS shows the above error


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