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

(Doc ID 2294209.1)

Last updated on AUGUST 05, 2017

Applies to:

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

Symptoms

On : 12.2.6 version, User Defined Attributes

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') )


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 Lifecycle and Select Lifecycle
5. Under Change Policy, Select Policy for Attribute and Click on GO
6. Click on Update LOV
7. Select specific Phase and click on GO
8. Click on ADD
9. In the attribute Group search box, enter AG name or %, Click on GO.

 

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