Create Settlement Batches Throws SQLException: ORA-20000: IBY_20512# - NO instrument matched (Doc ID 2020939.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Create Settlement Batches fails with the following error for bank account transactions:

Processing EFT BATCH CLOSE operations ..

java.sql.SQLException: ORA-20000: IBY_20512#
ORA-06512: at "APPS.IBY_FNDCPT_EXTRACT_GEN_PVT", line 470
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 174
ORA-06512: at line 1

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:85)
    at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:56)
    at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:876)
    at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
    at oracle.apps.iby.scheduler.SchedEFTBatchClose.schedPmt(SchedEFTBatchClose.java:421)
    at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:326)
    at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:423)
    at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:215)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

oracle.apps.iby.exception.DatabaseException: NO instrument matched

    at oracle.apps.iby.util.bpsUtil.raiseException(bpsUtil.java:104)
    at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:194)
    at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)
    at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89)
    at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:56)
    at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:876)
    at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
    at oracle.apps.iby.scheduler.SchedEFTBatchClose.schedPmt(SchedEFTBatchClose.java:421)
    at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:326)
    at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:423)
    at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:215)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Exception occured while processing profile codes  : 1 NO instrument matched


The Stack Trace is -
oracle.apps.iby.exception.DatabaseException: NO instrument matched

    at oracle.apps.iby.util.bpsUtil.raiseException(bpsUtil.java:104)
    at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:194)
    at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)
    at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89)
    at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:56)
    at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:876)
    at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
    at oracle.apps.iby.scheduler.SchedEFTBatchClose.schedPmt(SchedEFTBatchClose.java:421)
    at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:326)
    at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:423)
    at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:215)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

 

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