R12/CE: Cannot Access Bank Account Setups - JBO-27122 Error

(Doc ID 2161199.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

R 12.1.3 version, 

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)
...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Access bank Account
2. View error

Changes

 

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