Manufacturing Operations Center - Item Hierarchy Staging Table Not Clearing
(Doc ID 2026605.1)
Last updated on MARCH 08, 2017
Oracle Manufacturing Operations Center - Version 12.2.4 and later Information in this document applies to any platform.
On : 12.2.4 version, Data Model and ETL
ACTUAL BEHAVIOR --------------- Manufacturing Operations Center - Item Hierarchy Staging Table Not Clearing
There are records "stuck" in the Item Hierarchy Staging table (MTH.MTH_ITEM_HIERARCHY_STG). This most likely occurred after a failed job, but that is not certain. This is causing a scheduled load plan to have errors on the item hierarchy steps (MTH_PKG_ITEM_HIERARCHY_EXT and MTH_PKG_ITEM_HIERARCHY_SF). However, if the Item Hierarchy scenario (MTH_PKG_ITEM_HIERARCHY_EXT) is executed manually following the failed scheduled run, it completes successfully and data is correctly loaded. NOTE: This is being discussed with MOC development.
EXPECTED BEHAVIOR ----------------------- Expect the records to clear
STEPS ----------------------- The issue can be reproduced at will with the following steps:
- Schedule load plan with MTH_PKG_ITEM_HIERARCHY_EXT as the last step - Create CSV load file for MTH_ITEM_HIERARCHY.csv - Review session list after scheduled plan runs - Execute scenario MTH_PKG_ITEM_HIERARCHY_EXT
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!