Order Stuck In Amending During Revision Of Upgrade Promotion (Doc ID 2202187.1)

Last updated on NOVEMBER 11, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.2.4 to 7.2.4 [Release 7.2]
Information in this document applies to any platform.

Symptoms

Order is stuck in amending state during revision of upgrade promotion . Existing Product is deleted and a new Product is added during Revision.

Following error is displayed:

<[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'>


<[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'> ORA-06512: at "ORDERMGMT10.OM_ORCHESTRATION_PKG", line 370
ORA-01403: no data found
ORA-06512: at "ORDERMGMT10.OM_ORCHESTRATION_PKG", line 657
ORA-06512: at line 1
 : java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ORDERMGMT10.XFK3OM_ORCH_ITEM_DEP_PRED) violated - parent key not found
ORA-06512: at "ORDERMGMT10.OM_ORCHESTRATION_PKG", line 370
ORA-01403: no data found
ORA-06512: at "ORDERMGMT10.OM_ORCHESTRATION_PKG", line 657
ORA-06512: at line 1

Steps to Reproduce:

1. On a completed Asset, place an Upgrade Promotion
2. Place a revision order for Upgrade Promotion order by modifying a Product
3. Order will be stuck in amending state with the specified 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