My Oracle Support Banner

Fusion Global Payroll: Custom HCM Extract Scheduled to Run on a Daily Basis Is Not Returning Data and Throws Error: Token1 Chunk.getChunk (Doc ID 2471064.1)

Last updated on MARCH 11, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.13.18.05.0. The note has been reviewed and is current for release 11.13.20.04.0.

Symptoms

While running a custom extract (scheduled to run daily in 'Changes Only' mode) no data is returned. XML file doesn't have any data.

ERROR
-----------------------

Token1 Chunk.getChunk
Token2 ORA-20001: An error was detected by another process. Details will be provided by the failing process.
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 392
ORA-06512: at "FUSION.PAY_ACTION_CREATION", line 1496
ORA-06512: at "FUSION.PAY_ACTION_CREATION", line 1605
ORA-06512: at line 1

Token3 28
A system error ORA-20001: An error was detected by another process. Details will be provided by the failing process.
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 392
ORA-06512: at "FUSION.PAY_ACTION_CREATION", line 1496
ORA-06512: at "FUSI
Name null
Token1 null
Token2 null
Token3 null
ORA-20001: An error was detected by another process. Details will be provided by the failing process.
ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 392
ORA-06512: at "FUSION.PAY_ACTION_CREATION", line 1496
ORA-06512: at "FUSION.PAY_ACTION_CREATION", line 1605
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run scheduled extract
2. No data is returned

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.