While Running Transfer Batch (PBL) For Payroll Elements Error- ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 2026 (Doc ID 2207544.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Global Payroll

When attempting to load payroll elements using Payroll Batch Loader (PBL), the following error occurs.

ERROR
-----------------------
"Sql exception while calling PAY_BATCH_LDR_PKG.PLSQL_BATCH_LINE_TRANSFERjava.sql.SQLException: ORA-20105: Error when populating user access table
ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 2026
ORA-06512: at line 1

BatchLine Status - E"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create batch
2. Transfer batch
3. Batch in error status

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load elements

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms