Periodic Cost Update Fails With: No Open Period Found For Date Entered
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.
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.
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).
No open period found for date entered.
(Error code: INV_NO_OPEN_PERIOD)
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms