Cannot Create Config Item - User Defined Exception Error When Progressing - Config Eligible (Doc ID 1535739.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Symptoms

On : 11.5.10.2 version, Configuration Process

Cannot create CFG Item, "User Defined Exception" Error when progressing "Config Eligible"

ERROR
----------------------
inherit_op_seq_ml: Error: Others excpn : ORA-01427: single-row subquery returns more than one row
create_bom_ml: Failed in inherit_op_seq for line id: 16565793
create_in_src_orgs: Returned from Create_bom_ml with status: 0
create_in_src_orgs: Failed in Create_bom.
create_in_src_orgs: expected error::125::User-Defined Exception



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Responsibility,
2. Navigate to the Sales Order Line Items tab,
3. Enter a configurable item,
4. Attempt to progress an eligible item,
5. Error is seen.
6. When changing the BOM profile option "Inherit Operation Seq from Option Class" to NO the progression finishes OK.
7. However all items are at Op Seq #1.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete sales orders and ship products.

Cause

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