Fusion Global Payroll: Payroll Batch Loader Transfer Batch Process Error When Loading Large File (127k) (Doc ID 2095360.1)

Last updated on JANUARY 12, 2016

Applies to:

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

Symptoms

When attempting to load Element Entries via Payroll Batch Loader (PBL) where file is large (127k), the following error occurs.

ERROR

Sql exception while calling PAY_BATCH_LDR_PKG.PLSQL_BATCH_LINE_TRANSFERjava.sql.SQLException: ORA-20001: Given employment record cannot be used to find a single record. Please specify additional details, such as Assignment Number.
ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 1846
ORA-06512: at line 1

and

:java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 53 with name "_SYSSMU53_119574800$" too small.

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