Option Specific Sourcing Not Working For Top Model (Doc ID 2097909.1)

Last updated on JANUARY 18, 2016

Applies to:

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


When attempting to create the star (*) item when models are structured so that the model is also a component of another model, the following error occurs.  This is causing the sourcing rule not to be created correctly for the AutoCreated item

 errored into type 1,2  at 4 err ORA-01403: no data found
 value for l_curr_src_org 4154
 value for l_source_type 2
 value for l_curr_rank
going to insert bcso for type 1,2  
inserted bcso for type 1,2  1
inserted bcso for type 1,2  rcv 4154 org 4154
output query sourcing org type 3
output query sourcing org type 3
 came into type 3
 errored into type 3  at 23 err ORA-01403: no data found
inserted bcso for type 3 1
inserted bcso for type 3  rcv 4154 org 4154
process_sourcing_chain: end p_organization_id 4154
process_sourcing_chain: end px_concat_org_id 4154
process_sourcing_chain: Org deleted from collection: 4154
get_all_item_orgs: after calling process_sourcing_chain::x_return_status::S
Get_All_Item_Orgs: Inserted in BCSO for transfer same org id, rcv org id 0 at stmt 160

The issue can be reproduced at will with the following steps:
1.   Responsibility: Order Management Super User
2.   Navigate: Orders Workbench, Order Organizer > Open the order with the Model on the sales order line
3.   After booking, progress the order to AutoCreate the configuration item
4.   Check the * item, the sourcing is not correct.


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