ORA-01403 No Data Found During Create Settlement Batches (Doc ID 1249814.1)

Last updated on JANUARY 16, 2015

Applies to:

Oracle Payments - Version 12.0.4 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Create Settlement Batch

Checked for relevance on 12-Aug-2013.


Symptoms


Create Settlement Batches is failing with following error:

attempting batch close for batch(payee id=ABC_PTK_CC,account id=null,batch id=1_1)
Profile codes for the batch: [1]
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.IBY_FNDCPT_EXTRACT_GEN_PVT", line 359
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 163
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)

Changes

None

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