R12:AP:Export Button Error: Invalid Column Type In Search Supplier Bank Account Assignment (Doc ID 2059991.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Payables - Version 12.1.1 and later
Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On :  R12.1.X version, SEARCH SUPPLIER BANK ACCOUNT ASSIGNMENT window
 
  When a user uses export button
  in SEARCH SUPPLIER BANK ACCOUNT ASSIGNMENT window,
  the following error occurs.

Error Page  
Exception Details.  
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.  
Statement: SELECT * FROM (SELECT
PaymentInstrumentUsesEO.INSTRUMENT_PAYMENT_USE_ID,
       PaymentInstrumentUsesEO.EXT_PMT_PARTY_ID,
       PaymentInstrumentUsesEO.INSTRUMENT_TYPE,
       PaymentInstrumentUsesEO.INSTRUMENT_ID,
       .....
       .....

## Detail 0 ##
java.sql.SQLException: Invalid column type at
oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8516)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:11907)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:815)
at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3919)

.....

.....

 

The issue can be reproduced at will with the following steps:

1.Payables Responsibility
2.Suppliers->Search Supplier Bank Account Assignment
3.Search the Supplier Bank Accounts
4.Select EXPORT button

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