My Oracle Support Banner

R12: OIE: Loaded Credit Card Transaction Disappears During Credit Card Transaction Validation Program (Doc ID 2307613.1)

Last updated on JULY 13, 2021

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
APXCCVAL module: Credit Card Transactions Validation Program
ap_credit_card_trxns_all table


When running the APXCCVAL module: Credit Card Transactions Validation Program and a credit card transaction fails validation with: Rows failed due to an invalid card number the program removes/deletes the transaction from the ap_credit_card_trxns_all table.

Steps to Recreate
1. Load data through either a seeded or custom Credit Card Transaction Loader concurrent program.
2. Review the Rejections Report.
3. Run a table dump against the ap_credit_card_trxns_all table searching by the reference_number of the rejected invalid transactions and have no rows returned.


To view full details, 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 a vibrant support community of peers and Oracle experts.