MasterCard CDF3 Transaction Loader And Validation Program Errors With ORA-01086 (Doc ID 1550842.1)

Last updated on MARCH 02, 2016

Applies to:

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

Symptoms

When attempting to run the
APXMCCDF3 module: MasterCard CDF3 Transaction Loader and Validation Program,
the program completes with error,
and the following error can be seen in the log file:

ERROR
-----------------------
INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found
An unexpected error occurred during the credit card transaction upload. No transactions were uploaded.
JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
at oracle.jbo.server.DBTransactionImpl.rollbackToSavepoint(DBTransactionImpl.java:2857)
at oracle.jbo.server.DBTransactionImpl.restoreTmpPostState(DBTransactionImpl.java:1833)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2823)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2640)
at oracle.apps.ap.oie.cc.cp.DBCreditCardTrx.save(DBCreditCardTrx.java:270)
at oracle.apps.ap.oie.cc.cp.CreditCardTrx.save(CreditCardTrx.java:395)
at oracle.apps.ap.oie.cc.cp.CreditCardTrx.runProgram(CreditCardTrx.java:197)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established

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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the APXMCCDF3 module: MasterCard CDF3 Transaction Loader and Validation Program against the real data file, with the appropriate parameters
2. Review the log file which is created.


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