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:

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

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