Getting "ORA-01722: invalid number" - Unable To Add Attribute Group Under Change Policy

(Doc ID 2294209.1)

Last updated on MAY 02, 2018

Applies to:

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

Symptoms

When attempting to setup for Change Policy, the following error occurs.

ERROR
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement:
select * from
 (SELECT AGA.ATTR_GROUP_ID attr_code,AGA.ATTR_GROUP_DISP_NAME attr_name FROM
EGO_ATTR_GROUPS_V AG,EGO_OBJ_ATTR_GRP_ASSOCS_V AGA,FND_OBJECTS O WHERE AG.ATTR_GROUP_ID = AGA.ATTR_GROUP_ID
AND AGA.DATA_LEVEL_INT_NAME in ('ITEM_LEVEL', 'ITEM_REVISION_LEVEL', 'ITEM_ORG') AND AGA.CLASSIFICATION_CODE IN
( SELECT ICG.ITEM_CATALOG_GROUP_ID FROM MTL_ITEM_CATALOG_GROUPS_B ICG
CONNECT BY PRIOR ICG.PARENT_CATALOG_GROUP_ID = ICG.ITEM_CATALOG_GROUP_ID START
WITH ICG.ITEM_CATALOG_GROUP_ID = :1) AND AGA.OBJECT_ID = O.OBJECT_ID AND AGA.ENABLED_CODE = 'Y'
AND O.OBJ_NAME = 'EGO_ITEM' AND AG.ATTR_GROUP_TYPE NOT IN ('EGO_ITEM_TRANS_ATTR_GROUP') )
.
.
.
.
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number


STEPS
The issue can be reproduced at will with the following steps:

1. Login to applications
2. Select Development Manager responsibility
3. Navigate to Setup > Setup Workbench > Select any ICC
4. Go to Lifecycles and Select Lifecycle
5. Under Change Policy, Select Policy for Attributes and Click on GO
6. Click on Update LOV
7. Select specific Phase and click on GO
8. Click on Add Another Row
9. In the attribute Group search box, enter AG name or %, Click on GO.
10. Error page is shown; clicking on "Click here for exception details" displays error as shown above.

 

Changes

 

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