R12 ROI Receiving Transaction Processor Fails PO_CNL_NO_PERIOD Gl Date Is Not In An Open Period (Doc ID 1239403.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor


Symptoms

On Release 12

When attempting to run ROI for Internal Requisitions / Internal Sales Order receipts the following error occurs in RVCTP log file although GL, PO and Inventory Periods for the related Operating Unit are open:

Error Message from PO_INTERFACE_ERRORS table :

ERROR_MESSAGE Error: The GL date is not in an open period.
Cause: The GL date that you entered does not fall within an open period.
Action: Choose a different GL date or open the period for this date.
ERROR_MESSAGE_NAME  PO_CNL_NO_PERIOD


Steps
The issue can be reproduced at will with the following steps:
1. Populate RCV_TRANSACTIONS_INTERFACE and RCV_HEADERS_INTERFACE tables for ISO receipts
In rcv_transactions_interface
TRANSACTION_TYPE RECEIVE
RECEIPT_SOURCE_CODE INTERNAL ORDER
SOURCE_DOCUMENT_CODE REQ

2. Ensure GL, PO, and PO periods are open

3. Run RVCTP

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