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:
Oracle Incentive Compensation - Version 12.2.12 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
References |