EAR9.2: Profile Errors In Cash Drawer Receipt(AR) And Record Deposit(OM)

(Doc ID 2087980.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

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.

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