My Oracle Support Banner

GPCH: Incorrect Keys Defined for History Record GPCH_RP_FK1_HST on Microsoft SQL Server Database (Doc ID 2958240.1)

Last updated on JULY 12, 2023

Applies to:

PeopleSoft Enterprise HCM Global Payroll Switzerland - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When testing payroll archival, the process fails for record GPCH_RP_FK01 because the keys for its history record, GPCH_RP_FK1_HST, are incorrectly defined.

SQL error triggered: 


Steps to replicate the issue:

1. Navigate to PeopleTools > Data Archive Manager > Archive Data To History and perform the below steps to test payroll archival:

2. Navigate to PeopleTools > Data Archive Manager > Audit Archiving > Audit Archiving to confirm the results of the payroll archival process.
Notice the process fails for record GPCH_RP_FK01 because the keys for its history record, GPCH_RP_FK1_HST, are incorrectly defined.

Changes

 

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
Changes
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.