R12.1/CE: Cannot Access Bank Account Setups - JBO-27122 Error
(Doc ID 2161199.1)
Last updated on DECEMBER 28, 2021
Applies to:
Oracle Cash Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to access the bank account setups page for any bank accounts.
the following error occurs.
ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT BankAccountEO.BANK_ACCOUNT_ID,
BankAccountEO.BANK_ACCOUNT_NAME,
BankAccountEO.LAST_UPDATE_DATE,
BankAccountEO.LAST_UPDATED_BY,
BankAccountEO.LAST_UPDATE_LOGIN,
...
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "BANKACCOUNTEO"."AUTORECON_AR_MATCHING_ORDER5": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
...
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT BankAccountEO.BANK_ACCOUNT_ID,
BankAccountEO.BANK_ACCOUNT_NAME,
BankAccountEO.LAST_UPDATE_DATE,
BankAccountEO.LAST_UPDATED_BY,
BankAccountEO.LAST_UPDATE_LOGIN,
...
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "BANKACCOUNTEO"."AUTORECON_AR_MATCHING_ORDER5": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
...
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 |