Refresh Analysis Data (HR_PG_WF_DIV) Runs to No Success with error ORA-01427
(Doc ID 2596583.1)
Last updated on OCTOBER 07, 2019
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.
Refresh Analysis Data (HR_PG_WF_DIV) application engine goes to No Success with the following error:
The issue can be reproduced at will with the following steps:
1. When executing the process that is in the route Main Menu>Workforce Administration> Refresh Analysis Data. It ends incorrectly.
2. The error is found in the steps of the engine:
3. In both steps, when joining the table HR_PG_WF_DIVERS with its language table HR_PG_WF_DV_LNG, it only does so for its EMPLID and EMPL_RCD keys.
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