EAR9.2: FS_CCHOST_CV Creates One Profile for Each Order (Doc ID 2078309.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Credit Card processing

ACTUAL BEHAVIOR
---------------
Issue: App Engine FS_CCHOST_CV (credit card conversion process) creates a credit card profile for each transaction line that has a credit card number instead of consolidating/grouping similar cc numbers and creating a single profile for each group.
 Current behavior:
 Order AAA, $23.50, cc Visa 411111111111111, exp 07/2017
 Order BBB, $58.70, cc Visa 411111111111111, exp 07/2017
 Order CCC, $50.00, cc Visa 411111111111111, exp 07/2017
 Run FS_CCHOST_CV. It will create one profile for each order which results in 3 profiles for the same credit card number.

EXPECTED BEHAVIOR
-----------------------
Create one profile for the same credit card number with the same cc data (exp date, name, email, billing address)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created multiple orders with same cc numbers but different expiration dates.
2. Checked CRCARD_HST table and there were existing data in there for Billing that use the same cc number and same expiration date.
3. Ran FS_CCHOST_CV.
The process created a profile for every transaction line.


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