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

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Global Payroll - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms


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.


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