Cannot Add New Column In Oracle Incentive Compensation Configure Tables And Columns.Getting Error "JBO-27122: SQL error during statement preparation" (Doc ID 2975179.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Symptoms

Cannot add new column in Oracle Incentive Compensation Configure tables and columns .When adding new column to custom table in Incentive Compensation Administrator->Setup->Configuration Workbench->Collection->Configure Tables and Columns, Save fails with following error:


ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT data_type,data_length
  FROM all_tab_columns col, user_synonyms syn
  WHERE syn.synonym_name = :2
  AND col.owner = syn.table_owner
  AND col.table_name = syn.table_name
AND col.column_name = :3
AND col.data_type IN ('CHAR','NCHAR','VARCHAR2','VARCHAR','NVARCHAR2','LONG','NUMBER','DATE')
  AND NOT EXISTS
  (SELECT name
  FROM cn_objects
  WHERE table_id = :4
  AND name = :5
  AND org_id=:6
  AND object_type = :7)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:836)
...
## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:6363)


The issue can be reproduced at will with the following steps:
1. Login to Applications
2. Go to Incentive Compensation Administrator responsibility
3. Navigate to Setup->Configuration Workbench->Collection->Configure Tables and Columns
4. Select existing custom table and try to add new column and save.

Changes

Cause

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