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:
- Select the archive template you want to use.
- Select a process type of Selection to copy data from the Global Payroll result tables to their corresponding history tables.
- To archive data for a single calendar group, select the GP_CAL_RUN_SNGL selective query.
- To archive data for multiple calendar groups, select the GP_CAL_RUN_MULT selective query.
- Click the Define Binds link to access the Define Archive Query Binds page where you select a calendar group and country as bind variables for the archive process.
- Click Run to initiate the selection process.
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 |