Autocreate Configuration Items Fails With Create_And_Link_Item: Create_and_link_item (Doc ID 2202972.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Configure to Order - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Configuration Process

When attempting to run AutoCreate Configuration Items, the following error occurs.

ERROR
-----------------------
Create_And_Link_Item: calling oss processing
  CREATE_OSS_SOURCING_RULE: Inside Create OSS Sourcing Rule API
  CREATE_OSS_SOURCING_RULES: assignment count = 0
Create_Item: c_copy_src_rules LOOP 1
Create_Item: next iteration
Create_Item: c_copy_src_rules LOOP 1
Create_Item: Copying src rule for cfg item XXXXXXX in org YYYY
CTO_MSUTIL_PUB.create_sourcing_rules: Default assignment set is 1
CTO_MSUTIL_PUB.create_sourcing_rules: Upgrade assignment set is 1
CTO_MSUTIL_PUB.create_sourcing_rules: lAssnType::6::lAssnId::ZZZZZZZZ
CTO_MSUTIL_PUB.create_sourcing_rules: after query row
CTO_MSUTIL_PUB.create_sourcing_rules: after forming lAssignmentTbl
CTO_MSUTIL_PUB.create_sourcing_rules: after forming lAssignmentSetRec
CTO_MSUTIL_PUB.create_sourcing_rules: before Process_Assignment
CTO_MSUTIL_PUB.create_sourcing_rules: error in process_assignment::ORA-0000: normal, successful completion
CTO_MSUTIL_PUB.create_sourcing_rules: count:1
CTO_MSUTIL_PUB.create_sourcing_rule: MRP_ATTRIBUTE_VALUE_ERROR (ATTRIBUTE=Inventory_Item_Id)
CTO_MSUTIL_PUB.create_sourcing_rules: MSG:S
Failure!
CTO_MSUTIL_PUB.create_sourcing_rules: Create_Src_Rules::exp error::60::User-Defined Exception
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
Create_Item: Create_Sourcing_Rules returned with expected error.
Create_And_Link_Item: create_and_link_item::exp error in stmt 140

 

Additional information :

-----------------------

Model has these sourcing rules:
In Shipping org : transfer from YYY
In org YYY : make at YYY


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Via the Order Management Responsibility.
2. Navigate: Orders, Returns > Sales Orders,
3. Create and book a SO on a model item and progress the line. OR
  from any BOM responsibility, click on ATO Menu and select 'AutoCreate Configuration Items' and in parameters, enter the SO # and run.

Have a model item with SO booked with shipping warehouse as F91 InvOrg and with sourcing rule created for the item in F91 to transfer from 100 InvOrg and in 100 to make in 100. Looks like, when the AutoCreate Config item tries to copy the sourcing rule assignment to the star item it is encountering the above errors.



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