My Oracle Support Banner

"Delete Item Information" With Delete Type:Operation, Archive Flag:Checked Completed with Error Status, but There Is No Error Message. (Doc ID 2664197.1)

Last updated on MAY 05, 2020

Applies to:

Oracle Bills of Material - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Problem Statement

"Delete Item Information" with delete type:operation, archive flag:checked completed with error status,
but there is no error message.

So, "Delete Item Information" re-run with "MRP:Debug Mode" is yes,
Then, below SQL was shown in the log file of "Delete Item Information".

But "REPLACEMENT_GROUP_NUM" column does not exist on "BOM_OP_RESOURCES_ARCHIVE" table.

Expected Behavior
Need to add "REPLACEMENT_GROUP_NUM" column on "BOM_OP_RESOURCES_ARCHIVE" table.

Steps to Reproduce

  1. Run Delete Item Information with delete group Id, action type:delete group, delete type:operation, archive flag:checked

Changes

 

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
Changes
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.