My Oracle Support Banner

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 and later
Oracle Fusion Global Payroll - Version and later
Information in this document applies to any platform.


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


To view full details, 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 a vibrant support community of peers and Oracle experts.