GMI ERES ITEM CREATE IS FAILING WITH ERROR APP-FND-01934: ORA-01722 (Doc ID 1080295.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Records - Version 11.5.10 and later
Oracle Process Manufacturing Inventory - Version 11.5.10 and later
Information in this document applies to any platform.
*** Checked for relevance on 17-Oct-2013 ***


Symptoms


On Applications 11.5.10
After having gone through the setup steps for GMI ERES Item Create:
When saving an item expect the ERES form to come up and it does not. Running the ERES Setup report gives an ORA-01722 invalid number error. The workflow business event test fails with:

-- Error
ORA-20002: 3825: Error '-20001 - ORA-20001: APP-FND-01934: ORA-01722: invalid number in Package EDR_PSIG_RULE Procedure PSIG_RULE' encountered during execution of Rule function 'EDR_PSIG_RULE.PSIG_RULE' for event 'oracle.apps.gmi.item.create' with key 'ic_item_mst_b.item_id'. ORA-06512: at "APPS.WF_EVENT", line 2884 ORA-06512: at line 1

-- Steps
The issue can be reproduced at will with the following steps.
1. Perform setup steps for GMI ERES Item Create.
2. OPM inventory > setup > item master
3. Create an item and save it

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