My Oracle Support Banner

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 MARCH 12, 2021

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 A. Patch
 B. Workaround
References


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