EAR9.2: FS_CCHOST_CV Creates One Profile for Each Order
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.
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.
3. Ran FS_CCHOST_CV.
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