Fusion Global Payroll: Payroll Batch Loader (PBL) FAQ and Troubleshooting Guide
(Doc ID 2016702.1)
Last updated on APRIL 21, 2020
Applies to:
Oracle Fusion Global Payroll - Version 11.1.8.0.0 and laterOracle Fusion Global Payroll Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.
Purpose
<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
| Purpose |
| Questions and Answers |
| NEW: PBL End of Life |
| 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? |
| NEW: Can PBL date format YYYY-MM-DD be changed to MM/DD/YYYY (American format)? |
| 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 |
| Guides |
| 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 (oracle.wsm.security.WSFunctionPermission) |
| 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? |
| References |