My Oracle Support Banner

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

Last updated on JANUARY 15, 2020

Applies to:

Oracle Product Hub - Version 12.1.3 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
 

  1. Navigate to Development Manager > People and Roles > People, Groups and Companies
    Choose the Groups tab.
    Find an existing group.
    Choose the Add (Button)
    Enter a User Name > Press Go (Button)
  2. Receive an error.
    Choose the exception details link.
  3. Review the errors.

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
 Solution Explained
 Solution Steps
References


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