My Oracle Support Banner

Credit Card Refunds Failing With IBY_40000 (Doc ID 1309726.1)

Last updated on FEBRUARY 16, 2019

Applies to:

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


Find that Automatic Remittance request for credit card refund errors with IBY_40000.

iby.log shows the following error:

iby.database.DBWrapper.raiseDBException]:java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 885
ORA-06512: at line 1

at oracle.jdbc.driver.SQLStateMapping.newSQLException(
at oracle.jdbc.driver.DatabaseError.newSQLException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.jdbc.driver.OracleCallableStatement.execute(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
at oracle.apps.iby.payment.CreditCardPayment.insertTrxnResults(
at oracle.apps.iby.payment.proc.BatchCCPayment.areturn(
at oracle.apps.iby.ecapp.PmtECApp.oraPmtReturn(
at oracle.apps.iby.ecapp.PaymentServiceImpl.oraPmtReturn(
at oracle.apps.iby.ecservlet.ReturnService.service(
at oracle.apps.iby.ecservlet.ECServlet.doPost(


Other possible error is:

EXCEPTION:[iby.database.DBWrapper.raiseDBException]:java.sql.SQLException: ORA-04063: package body "APPS.IBY_TRANSACTIONCC_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.IBY_TRANSACTIONCC_PKG"
ORA-06512: at line 1

### Steps to Reproduce ###
1. Apply a receipt to Credit Card Refund (this is a receipt created initially from a sales order that was processed and paid with a credit card, then a return order entered and processed referenced by the original sales order).

2. Run the Automatic Remittances Creation Program.

3. See that the error IBY_40000 is returned in the execution report and the receipt created from the Credit Card Refund is still in a confirmed status

### Recent Changes ###

Applied patches 9509812, 10052557, 11741690 and/or 11800457.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.