JBO-27122 / ORA-00904: "EXTBANKSEO"."TAX_PAYER_ID" when attempting to Create a Bank for a Customer (Doc ID 1303083.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 26-Nov-2012.

Symptoms

Find that we get an Unexpected Error message when attempting to create a bank for a customer:

Error Page
Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:

JBO-27122: SQL error during statement preparation.

Statement: SELECT * FROM (SELECT ExtBanksEO.BANK_PARTY_ID, ExtBanksEO.BANK_NAME, ExtBanksEO.BANK_NUMBER, ExtBanksEO.BANK_INSTITUTION_TYPE, ExtBanksEO.BANK_NAME_ALT, ExtBanksEO.SHORT_BANK_NAME, ExtBanksEO.DESCRIPTION, ExtBanksEO.END_DATE, ExtBanksEO.ADDRESS1, ExtBanksEO.ADDRESS2, ExtBanksEO.ADDRESS3, ExtBanksEO.CITY, ExtBanksEO.STATE, ExtBanksEO.POSTAL_CODE, ExtBanksEO.COUNTRY, ExtBanksEO.HOME_COUNTRY HOME_COUNTRY, ExtBanksEO.CREATED_BY, ExtBanksEO.CREATION_DATE, ExtBanksEO.LAST_UPDATED_BY, ExtBanksEO.LAST_UPDATE_DATE, ExtBanksEO.LAST_UPDATE_LOGIN, ExtBanksEO.OBJECT_VERSION_NUMBER, ExtBanksEO.OPERATION_FLAG, countries.territory_code Territory_short_code, countries.TERRITORY_SHORT_NAME, ExtBanksEO.Site_location_id, addrcountries.territory_short_name Address_Country_Name, ExtBanksEO.TAX_PAYER_ID FROM IBY_EXT_BANKS_V ExtBanksEO, fnd_territories_vl countries, fnd_territories_vl addrcountries WHERE ExtBanksEO.HOME_COUNTRY = countries.territory_code(+) AND ExtBanksEO.COUNTRY=addrcountries.territory_code(+)) QRSLT WHERE (BANK_PARTY_ID = :1)

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:761)
at oracle.apps.iby.fundcapture.setup.components.webui.UpdateExtBankAcctCO.processRequest(UpdateExtBankAcctCO.java:159)

.....

java.sql.SQLSyntaxErrorException: ORA-00904: "EXTBANKSEO"."TAX_PAYER_ID": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

...

at oracle.apps.iby.fundcapture.setup.components.server.ExtBanksVOImpl.initQuery(ExtBanksVOImpl.java:62)
at oracle.apps.iby.fundcapture.setup.components.server.ExtBankAccountsAMImpl.initUpdate(ExtBankAccountsAMImpl.java:452)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:761)
at oracle.apps.iby.fundcapture.setup.components.webui.UpdateExtBankAcctCO.processRequest(UpdateExtBankAcctCO.java:159)


### Step to Reproduce ###:
AR Super User
> Customers
> Standard

- Query an existing customer
- Press Account Details
- Press Site Details
- Click on the Payment Details Tab
- Bank Accounts - Press Create
- Enter a Country
- Select the checkbox Create New bank

--> Unexpected Error Page; the details of the error are given above.

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