My Oracle Support Banner

Fusion Applications - Global Payroll - Payroll HCM Extract Is Not Running Archival Process And Getting Failed After 3-4 Hours Of Execution (Doc ID 2594256.1)

Last updated on APRIL 01, 2024

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.07.0 version,
Payroll HCM Extract is not running archival process and getting failed after 3-4 hours of execution

Custom HCM Extract is built to pull balance information on the file. Extract was working perfectly fine in other instances.
When we run the extract in DEV1 instance, Extract went into halt status at archival step and after 3-4 hours of execution, failed with error mentioned below.

ERROR
-----------------------
Unknown Failure
JBO-27123: SQL error during call statement preparation. Statement: begin pay_core_utils.pop_message(:1,:2, :3, :4, :5, :6); end;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. HCM Extract
2. fails at archival step


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.