My Oracle Support Banner

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

Last updated on JULY 10, 2020

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.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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