My Oracle Support Banner

GP CHE - Swissdec Dashboard: SQLData Conflict When Adding EMPLID (Doc ID 2474465.1)

Last updated on MARCH 09, 2020

Applies to:

PeopleSoft Enterprise HCM Global Payroll Switzerland - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Can't add individual EMPLID to the dashboard
Impossible to prepare the Certificate of salary (LAW_CDS) report for individual EMPLID

Customer statement
=================
When adding iddividual EMPLID to the dashboard the report cannot be executed as there appears an sql error message which refers to a conflict in the database.
The table PS_GPCH_RC_EMPLID should store the individual EMPLIDs.
It work as foreseen when PS_GPCH_RC_EMPLID is filled up using sql.

ErrorMSG in ENG (by Google):
Added data in conflict with existing data. (18.2)
By adding a new item to the database, the system has detected a conflict with an existing item.
This problem may be caused by another user entering similar data at the same time as you. Note the changes you made, cancel the page, and try again.
If the problem persists, it may be another programming error or the application that should be reported to technical support.
This error occurs when the keys of the inserted record match a record already in the database. The application verifies that each record has unique keys.

Replication steps
=================
- Main menu -> SetUp HCM -> Product related -> GP and Abs Mgmt -> Social security -> "Organismes - CHE"
- "Param domaine ELM - CHE"
- Correspondence administrative ->: Generation etats XML - CHE -> XML fin d'annee CHE.

Cause

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
Symptoms
Cause
Solution
References


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