ERS 9.2: Data Conflict Error Message (18,5) Faced At Rating Model Level When Multiple Effective Date Rows Exist

(Doc ID 2135785.1)

Last updated on MAY 09, 2016

Applies to:

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

Symptoms

ISSUE:


There seems to be a fundamental difference between PeopleSoft Enterprise HRMS and PeopleSoft Enterprise FSCM systems in the way Rating Models are handled. In HRMS systems the functionality has been built to support Effective Dated logic. On the other hand, this does not seem to be the case in FSCM environments.

Via the delivered RATING_MODEL_SYNC Service Operations, the configuration set up at HRMS systems can be successfully interfaced in FSCM environments. As such, and noting that HRMS systems provide Effective Dated logic, a specific Rating Model could have multiple rows based on different Effective Date values (stored within delivered Records PS_RATING_MDL_TBL, and PS_REVW_RATING_TBL. While such configuration is interfaced and properly stored in FSCM systems, when a User tries to perform any small update/modification at the FSCM side of Rating Model set up page, the system throws an (18,5) Error Message.

REPLICATION STEPS:

     - Perform the complete configuration for Service Operations RATING_MODEL_SYNC between HRMS and FSCM systems
     - Log into the HRMS Online Application as User ID PS
     - Navigate to: Set Up HCM > Product Related > Profile Management > Content Catalog > Rating Model
     - Create a brand new Rating Model, using Effective Date January 1st 1900, and save the changes
     - Log into the FSCM Online Application as User ID VP1
     - Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Data > Rating Models
     - Confirm that the new Rating Model confirmation has been properly interfaced
     - Log into the HRMS Online Application as User ID PS
     - Navigate to: Set Up HCM > Product Related > Profile Management > Content Catalog > Rating Model
     - Open the recently created Rating Model
     - Click on the + sign, to add a new Effective Date row, using a value of January 1st 2000
     - Modify the existing value at the Description level, and save the changes
     - Log into the FSCM Online Application as User ID VP1
     - Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Data > Rating Models
     - Open the existing Rating Model
     - Confirm that at this stage, there are 2 Rating Model effective date instances: January 1st 1900 and January 1st 2000
     - At the January 1st 2000 Effective Date row, add some values in the 'Review Pts' column, and save the changes
     - The system throws an Error Message

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

ERROR MESSAGE:

     " Changes conflict with another data item. (18,5)
       When trying to save your changes, the system found a conflict with other information in the database.
       This problem may be because of changes made simultaneously by another user. Make a note of the changes you have made, then cancel the page. Reload the page and look for changes. Ensure that your changes are still appropriate, then retry them.
       If the problem persists, it may be due to an application programming error and should be reported to technical support staff.
       This message occurs when a key is changed on an existing record, and the new set of key values conflicts with an existing record. The application should ensure that any changes to keys result in a unique record. "

ACTUAL RESULT:

No changes, nor modifications are possible at the Rating Models set up page (RS_CM_REVW_RAT_TBL), as the (18,5) data conflicts Error Message prevents any saving of such updates.

EXPECTED BEHAVIOR:

The Rating Model functionality in FSCM systems should be prepared to handle multiple Effective Date settings, and enable Verity and/or Oracle SES functionalities to properly work with Effective Dated logic, just as in PeopleSoft Enterprise HRMS systems.

 

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