R12:AP Error Occurs When Using Export Button in SEARCH SUPPLIER BANK ACCOUNT ASSIGNMENT Window

(Doc ID 2108897.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

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)


(Reproduce steps of the issue)
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