My Oracle Support Banner

Fusion Global Payroll: Load Historical Data Into User Defined Table Via Payroll Batch Loader (Doc ID 2088031.1)

Last updated on JUNE 17, 2022

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.


When attempting to load User Defined Table (UDT) via Payroll Batch Loader (PBL).
the following error occurs.

The issue can be reproduced at will with the following steps:

The user created a UDT that we loaded by PBL (see attached file) where we performed the following actions:

1. Create User-Defined Table
2. Create User-Defined Column
3. Create User-Defined Row
4. Create User-Defined Column Instance

Steps 1, 2 and 3 worked perfectly. However, when loading step 4, only 2015 data were loaded.

Indeed, data with previous effective date ended with the following error : “Client received SOAP Fault from server : JBO-27102: Attempt to access dead view row of persistent id 1”. You can find the log attached to this SR.

The user tried to load 2012 data in a single batch but we faced the same issue. We also tried the upload date of the batch header to “2012-01-01”; still the same issue.


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

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