Create Settlement Batches ended with error "IBY_20220#ERRMSG=Local Instrument is required" (Doc ID 1682219.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

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

Symptoms

When running Create Settlement Batches for SEPA payments, the program ends in error.
The exception is :

java.sql.SQLException: ORA-20000: IBY_20220#ERRMSG=Local Instrument is required. (ERR_OBJECT=Batch name)
ORA-06512: at "APPS.IBY_TRANSACTIONEFT_PKG", line 2209
ORA-06512: at "APPS.IBY_TRANSACTIONEFT_PKG", line 1224
ORA-06512: at line 1

    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)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    at oracle.apps.iby.database.AccXfrPaymentDB.createBatchClose(AccXfrPaymentDB.java:811)
    at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:730)
    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)
java.sql.SQLException: ORA-20000: IBY_20220#ERRMSG=Local Instrument is required. (ERR_OBJECT=Batch name)
ORA-06512: at "APPS.IBY_TRANSACTIONEFT_PKG", line 2209
ORA-06512: at "APPS.IBY_TRANSACTIONEFT_PKG", line 1224
ORA-06512: at line 1

    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)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    at oracle.apps.iby.database.AccXfrPaymentDB.createBatchClose(AccXfrPaymentDB.java:811)
    at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:730)
    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: Format-specific batch validation error: Local Instrument is required. (ERR_OBJECT=Batch name)
    at oracle.apps.iby.util.bpsUtil.raiseException(bpsUtil.java:127)
    at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:194)
    at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)
    at oracle.apps.iby.database.AccXfrPaymentDB.createBatchClose(AccXfrPaymentDB.java:868)
    at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:730)
    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)



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