R12: How to Add New Credit Card Brand With Code Of 'MC'

(Doc ID 2139963.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

Qn1:After upgrading from 11.5.10.2 to 12.2.5, we are receiving the following error when importing an order with a credit card type of 'MC': Validation failed for the field - Credit Card
This same order will import properly in the 12 version if we change the credit card code from 'MC' to 'MASTERCARD'. This order also imports without issue in our 11 version. In OM setup (Quick Codes -> Order Managment) for the "CREDIT CARD" type lookup, you see Master Card setup with a code of 'MC' in both our 11 and 12 environments.

Is there some additional setup or a new lookup that now controls the order validation in the 12 version.
What needs to be done to get the credit card code of 'MC' valid for orders in the 12 version?

You want to add a new card type with a code of MC that would have a name slightly different than MasterCard so that you do nothave to change all of your associations with this card type and orders will process successfully if this is added to the validation used by order import.

What is the the name of the validation lookup used by order import?


Qn2:
You were able to update the credit card code in the base tables for the iby_creditcard_issuers_v view to change the code for MASTERCARD back to MC and was then able to load the order using credit card type of MC without issue.

Is there a way to update the data in this table through the system or is the workaround to change the base tables my only option for this change? 
 

Solution

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