My Oracle Support Banner

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.

Symptoms

Refresh Analysis Data (HR_PG_WF_DIV) application engine goes to No Success with the following error:




STEPS
-----------------------
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:


- DEPT_LNG.Step01
- JBCD_LNG.Step01

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.

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.