My Oracle Support Banner

EOM 9.2: Primary To Bill, Primary Ship To, and Primary Sold To Flags Get Automatically Unselected from Historic Effective Dated Rows at Contact Customers Page (Doc ID 2765627.1)

Last updated on MARCH 31, 2021

Applies to:

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


It has been detected that at the Contact Customers page (CONTACT_CUST_PAGE), the below check-boxes get automatically un-selected from all historic/existing Effective Date rows, if on the newest added one the same check-boxes are manually un-checked for a certain Customer value.

    - Primary Bill To = Record Field PS_CONTACT_CUS_WK.PRIMARY_BILL_CNTCT
    - Primary Ship To = Record Field PS_CONTACT_CUS_WK.PRIMARY_SHIP_CNTCT
    - Primary Sold To = Record Field PS_CONTACT_CUS_WK.PRIMARY_SOLD_CNTCT


    1.- Log into the FSCM Online Application as a Functional User
    2.- Navigate to: Customers > Contact Information
    3.- Open an existing Contact ID
    4.- At the Maintain Contacts page, click on the Contact Customers link
    5.- Once at the Contact Customers page, make sure that for all existing listed Customers, the below flags are selected in the Customer tab
              - Primary Bill To
              - Primary Ship To
              - Primary Sold To
    6.- Save the changes if anything needed editing on the above flag
    7.- Click on the Contact Information link
    8.- At the Maintain Contacts page, click + icon to add a new Effective Date row
    9.- Click on the Contact Customers link
    10.- On the new Effective Dated row, un-select the below listed check-boxes for some of the listed Customers
              - Primary Bill To
              - Primary Ship To
              - Primary Sold To
    11.- Now, save the changes
    12.- Click on the View All link, to ensure all Effective Date rows on the 'Link Contact to Customer' grid are displayed
    13.- Confirm that in the initial Effective Date row, which has become history row now, and where the 3 flags were checked in the first place, are no longer selected

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

The system is wiping out the selection of the 3 mentioned check-boxes, (Primary Bill To, Primary Ship To, and Primary Sold To), on all existing Effective Date rows for the affected Customers on the newest row. This causes audit problems on historic data.

The configuration on prior Effective Date rows should remain untouched, regardless of what new configuration is being entered, and saved, on the latest/newest Effective Date row at the Contact Customers page (CONTACT_CUST_PAGE).

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.