R12: OIE: Loaded Credit Card Transaction Disappears During Credit Card Transaction Validation Program

(Doc ID 2307613.1)

Last updated on SEPTEMBER 14, 2017

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
invalidated
ap_credit_card_trxns_all table

Symptoms

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.

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