Change Orders Fail Updating Organization Level Attributes With Error: ORA-06502: PL/SQL: numeric or value error in Package Eng_Workflow_Util Procedure SetAttributes (Doc ID 2039757.1)

Last updated on AUGUST 17, 2015

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Engineering Change Orders (CO/ECO) error only for some organizations while updating organization level attributes.
Similar change orders work fine in other organizations.

Error
ORA-06502: PL/SQL: numeric or value error in Package Eng_Workflow_Util Procedure SetAttributes
 

Expected Behavior
Change order (CO) should be submitted for approval

Steps
1. Search an item in certain org to deactivate
2. Create an item COE Change order for that org
3. Submit the change order
4. Promote the change order for approval

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