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.
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.
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
Million Knowledge Articles and hundreds of Community platforms