Fusion Global Payroll: Payroll Batch Loader (PBL) Slow
Last updated on DECEMBER 21, 2015
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Global Payroll - Version 220.127.116.11.0 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
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