My Oracle Support Banner

Fusion Global Payroll: Payroll Batch Loader (PBL) FAQ and Troubleshooting Guide (Doc ID 2016702.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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


<p >*Purpose
<span >Explain to the reader the purpose of the FAQ. Enter a clear description of what the questions and answers are trying to achieve. Be precise. It is this section that will guide the reader to decide whether the document is applicable.

This document is designed to provide answers to some of the most frequently asked questions and troubleshooting tips regarding Payroll Batch Loader within Oracle Fusion Applications.  

Questions and Answers

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
Questions and Answers
 What is Payroll Batch Loader (PBL)?
 Where can one find documentation on PBL and Initial Balance Upload?
 What needs to be installed prior to using PBL?
 What objects can be loaded via PBL?
 What templates to use for which element classification?
 How to Load Batch from File / Automation?
 Can size limit be increased for Upload Batch from File?
 How can a line in a file be skipped?
 How do I create and transfer a batch?
 How messages from custom fast formulas can be shown in PBL load log file?
 PBL workbooks for Payroll Definitions, Payroll Relationships, Bank data, Globals, UDTs and Balance Groups
 What tables hold PBL batches data?
 SQL to validate payroll batch information including errors
 SQL to validate bank load
 SQL to validate bank branch load
 SQL to validate external account load
 SQL to validate personal payment method (PPM) load
 How to migrate objects from one pod to another?
 What documentation is available for Kronos and Ceridian time card integration?
 Why Transformation formulas can be slow?
 Can GET_TABLE_VALUE function be used in a Batch Loader type formulas?
 Initial Balance Upload
 How to undo Initial Balance Upload?
 How to run several batches in parallel?
 What type of encoding does PBL expect: UTF-8 or Windows-1252?
 Does PBL support multithreading?
 Troubleshooting Tips
 Error: ADFDI-07528: An unexpected exception has occured. The UI Controller cannot initialize. The runtime session will now abort.
 Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
 Error: Formula ELEMENTENTRIES_BATCHLOADER_FF, line 46, either function GET_TABLE_VALUE does not exist or the combination of parameter types does not match the statement
 Error: PLS-00306: wrong number or types of arguments in call to 'CREATE_BANK_BRANCH' ORA-06550: line 1, column 98
 Errors when attempting to initiate the PBL spreadsheet by clicking Download button
 Error: RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.4.4 403 Forbidden
 Error: ADFDI-05587: The client and server versions do not match
 Slow Performance issue
 Slow performance while trying to load  Federal Tax withholding for employees
 How to troubleshoot Initial Balance Upload performance issues
 Initial Balance Upload errors
 Error: The combination of balances is invalid for the load date
 Error: The legislative data group specified for the batch does not exist
 Errors loading Element Eligibility
 Error: Failed to lock the record in table PAY_ELEMENT_TYPES_F with key oracle.job.Key[300000096957475 1900-01-01 4712-12-31 ], another user holds the lock
 Errors loading Element Entries
 Error: Access denied (
 Error:  JBO-27019 or JBO-29000 The get method for attribute InputValue1
 Errors loading Personal Payment Method
 Error: JBO-Provide PayrollRelationshipNumber or PayrollRelationshipName
 Error: JBO-Provided OrgPaymentMethodName is invalid for the Payroll Relationship
 Error: JBO-27014: Attribute DataType in GlobalDEO is required
 How to delete incorrectly loaded data?
 How to get ADFDI diagnostics if none of the above works?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.