When running Standard Data Collection,ORA-1 occurs on ADD_NEW_IMPL_ITEM_ASL (Doc ID 1680513.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

When running Standard Data Collection,ORA-1 occurs for MSC_ITEM_SUPPLIERS.

Errors
----------
Error in PROCEDURE=ADD_NEW_IMPL_ITEM_ASL, TABLE=MSC_ITEM_SUPPLIERS
COLUMN=ITEM_NAME, VALUE=ITEM_001
COLUMN=ORGANIZATION_CODE, VALUE=TST:M2
ORA-00001: unique constraint (MSC.MSC_ITEM_SUPPLIERS_U1) violated
Procedure LOAD_SUPPLIER_CAPACITY started.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 1.Create Items and assigne it to M1.
 Inventory(N)Items - Master Items
 ITEM:ITEM_001(Template=Purchased Item)

 2.Create Global ASL.
 Purchasing(N)Supply Base - Approved Supplier list
 Org:M1

 Type:Item
 Item:ITEM_001
 Business:Direct
 Supplier:Advanced Network Devices
 Site:FRESNO
 Status:Approved
 (T)Record Details
 Global?:Yes
 Save
 
 (B)Attributes
 (B)Create Local
 (T)Planning Constraints
 Processing Lead Time:11
 Save
 
 3.Run Standard Data Collection.
 Advanced Planning(N)Advancd Supply Chain Planning - Collections - Oracle
 Systems - Standard Collection

 #ORA-1 for msc_item_supplies does not occur at this time.

 4.Assigne item to other organization.
 Inventory(N)Items - Master Items
 Query ITEM_001 and assign it to other organization.

 5.Run Standard Data Collection again.
 #ORA-1 for mtl_item_supplies occur.

Changes

Assigne the item which has global ASL with local attributes to organization.

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