My Oracle Support Banner

The Credit Card Validation Error Occurs When Sales Loading By Saimptlog Batch (Doc ID 1195254.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Retail Sales Audit - Version 13.1 and later
Information in this document applies to any platform.


Although the credit card validation ReSA functionality is disabled  i.e. CC_SEC_LVL_IND=’N’ and CC_VAL_REQD=’N’ in SA_SYSTEM_OPTIONS table, Credit Card validation is still performed when a sale transaction with the Debit Card payment type is loaded and audited in ReSA.
The following store error occurs - INVLD_CC_CCVT –“Invalid Credit Card validation type”.

This validation should not be performed when SA_SYSTEM_OPTIONS.CC_SEC_LVL_IND=’N’ and SA_SYSTEM_OPTIONS.CC_VAL_REQD=’N’.

Steps to reproduce:
1. Update sa_system_options.s_cc_val_reqd=’N’.
2. Upload a RTLOG containing a tender record with a ‘Credit Card’ into ReSA.
3. Notice that ReSA throws an ‘INVLD_CC_LEN’ error for this Credit Card in SA_ERROR table.


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.