PIM - Error Adding A Member To A Group: JBO-27122 / ORA-01722: invalid number [Video] (Doc ID 1386076.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Product Catalog - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

Receive an error trying to add new members to any of the Advanced Product Catalog Groups.

Error
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
...
Statement: SELECT * FROM (SELECT * FROM (
FROM EGO_PEOPLE_V A, FND_GRANTS B
WHERE B.INSTANCE_PK1_VALUE = :1
AND a.PERSON_ID = SUBSTR(B.GRANTEE_KEY,INSTR(B.GRANTEE_KEY,':')+1)
UNION
...
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
...


Steps

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