My Oracle Support Banner

Create/Update WIP Job Does Not Insert Into MRP_RELIEF_INTERFACE - Jobs Not Seen In MRP Plan (Doc ID 2617923.1)

Last updated on DECEMBER 06, 2019

Applies to:

Oracle Work in Process - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

After upgrade they no longer see WIP jobs in the MRP plan. The change to the job dates which should trigger WIP_DISCRETE_JOBS_BRU to insert row in mrp_relief_interface table.

Triggers are valid and enabled.
WIP_DISCRETE_JOBS_BRD (delete)
WIP_DISCRETE_JOBS_BRU (update)
WIP_DISCRETE_JOBS_BRI (insert)

EXPECTED BEHAVIOR

Expect the work orders should be visible in the MRP plan.

STEPS

1. MRP Responsibility.
2. Launch PLanning Workbench.
3. No Jobs available.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.