Load Historical Data Into User Defined Table Via Payroll Batch Loader
Last updated on FEBRUARY 02, 2018
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 188.8.131.52.0 and later
Oracle Fusion Global Payroll - Version 184.108.40.206.0 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.
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