Fusion Global Payroll: Payroll Batch Loader (PBL) Slow (Doc ID 2091240.1)

Last updated on DECEMBER 21, 2015

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

Populating one User Defined Table (UDT) through two Fast Formulas, one for loading row values one for loading column values.
237 records is taking 8 minutes for completion of row loading load batch and transfer batch. But for column loading it is taking 2 minutes for load batch and 41 minutes for transfer batch.
Need to load more that 15k records.So it will be a performance issue for such a bulk load.

The issue can be reproduced at will with the following steps:
1. Create a batch to load UDT rows and a batch to load UDT columns
2. Create a fast formula transformation formula to load the data via Payroll Batch Loader>Load Batch from File
3. Load the Batch then Transfer the batch
Note the time to load and transfer


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