Periodic Cost Update Fails With: No Open Period Found For Date Entered (Doc ID 1910865.1)

Last updated on JULY 24, 2014

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
Periodic Cost Update interface transactions fail in the transaction open interface (TOI / MTL_TRANSACTIONS_INTERFACE - MTI as well as MTL_TXN_COST_DET_INTERFACE) with the following error.

EXPECTED BEHAVIOR
The Periodic Cost Update should NOT require an open inventory period (in ORG_ACCT_PERIODS) but should use the periodic accounting period (CST_PAC_PERIODS).

Note : For example, one customer was receiving this error after working with PAC since 2008. The Customer updates Periodic Cost Update for closed inventory periods.  The update is taking place in the master organization for which customer never opened any period. Customer notes: "Transaction open interface is Periodic Cost Update which should evaluate the transaction date against the periodic period and not the inventory period."

ERROR
No open period found for date entered.

(Error code: INV_NO_OPEN_PERIOD)

STEPS
1. Insert records into the interface (MTL_TRANSACTIONS_INTERFACE and MTL_TXN_COST_DET_INTERFACE)
2. Run Periodic Cost Update
3. Find that the transactions fail in 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