Orphan/Invalid Row Created in PS_CONTACT_CUST When Customer Removed From Inactive Contact.

(Doc ID 1941337.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Customers/Contacts

ACTUAL BEHAVIOR
---------------
Orphan/invalid row is created in PS_CONTACT_CUST when customer is removed from inactive contact.

EXPECTED BEHAVIOR
-----------------------
There should not be any orphan/invalid row in PS_CONTACT_CUST when customer is removed from inactive contact.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Navigate to Main Menu > Customers > Contact Information and open an existing contact with just one customer associated to it. (The number of contacts is not critical, it just makes the test go faster).
  2. Press the 'Contact Customers' link to see the associated customers.
  3. One customer is associated and one row is present in PS_CONTACT_CUST, as expected.
  4. Press the 'Contact Information' link to go back to the Contact Information.
  5. Insert a new effective dated row, Inactivate and press Save.
  6. Click Yes to the following message pop-up:
    • All customer flags will be unchecked for an inactive contact. Continue with current status? (9030,135)
    • All primary flags will be unchecked at save time if the contact status is 'Inactive'.
  7. Data in PS_CONTACT_CUST still looks as we’d expect.
  8. Press the 'Contact Customers' link to see the associated customers.
  9. Delete the row for the customer.
  10. The row is deleted and the “default’ blank row is shown where the SetID defaults to SHARE (SetID from User Preferences). Do not enter a customer. Press Save.
  11. Upon save, the system created an empty row in PS_CONTACT_CUST (Customer ID is blank) for that contact.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, PS_CONTACT_CUST contains corrupted data.

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