Manufacturing Operations Center - Item Hierarchy Staging Table Not Clearing (Doc ID 2026605.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Manufacturing Operations Center - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

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

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