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.


On : 9.2 version, Credit Card processing

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.

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

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.
The process created a profile for every transaction line.


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