Records in the MTH_WORKDAY_SHIFTS_D Table have an Unassigned Value for SYSTEM_FK_KEY (Doc ID 2026662.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

In a 12.1.3 MOC Instance:
Need to load calendar data from the MTH_WORKDAY_SHIFTS_STG staging table to the MTH_WORKDAY_SHIFTS_D fact table.
Trying to populate the workday shift calendar from EBS by running the MTH_WORKDAY_SHIFTS_EBS_INIT_PF process flow in the MTH Utilities project under the MTHEBIIP module, but the data is only added to the MTH_WORKDAY_SHIFTS_STG table. It never gets loaded to the MTH_WORKDAY_SHIFTS_D table. There are no records in the MTH_WORKDAY_SHIFTS_ERR table.

Need to identify which process is truncated, or which process is running incorrectly in order to get Shifts from EBS. The records can neither get loaded using templates nor can create shifts through the user interface.  Besides, the shifts created via the user interface have
SYSTEM_FK_KEY = -99999
instead of the correct value for SYSTEM_PK_KEY from the MTH_SYSTEMS_SETUP table.

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