My Oracle Support Banner

Fusion Global HR: Get Error ORA-01008: Not All Variables Bound ORA-06512: At "FUSION.PAY_REPORT_PROCESS" When Running HCM Extract (Doc ID 2011344.1)

Last updated on SEPTEMBER 02, 2020

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.1.8.0.0. The note has been reviewed and is current for release 11.13.20.04.0.

Symptoms

When attempting to submit an HCM Extract, the following error occurs in the log file:

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

HR_6882_HRPROC_ASSERT
Name HR_6881_HRPROC_ORA_ERR
Token1 SystemExtract.PreProcess
Token2 ORA-01008: not all variables bound
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1068
ORA-06512: at line 1

The issue can be reproduced with the following steps:

  1. Navigate to My Client Groups >Payroll > Submit a payroll process > Defined extract.
  2. Click Submit.

    The extract is defined to use the user entity PER_POSITIONS_EIT_EFF_DYN_ATR_1_UE as the primary block, with PER_EXT_SEC_POSITION_UE as the secondary block.

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.