Fusion Global HR: File Based Loader (FBL) Column PVAL025 Present More Than Once In HRC_LOADER_BATCH_LINES_SRC's (Doc ID 1990422.1)

Last updated on MARCH 27, 2015

Applies to:

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

Symptoms

On : 11.1.9.2.0 version, File Based Loader

When attempting to load person DFF data using FBL
the following error occurs.

ERROR
-----------------------
SQL*Loader-404: Column PVAL025 present more than once in HRC_LOADER_BATCH_LINES_SRC's INTO TABLE block.
Traceback (most recent call last):
  File "/u01/APPLTOP/fusionapps/applications/hcm/hrc/bin/hr2hrSqlldr.py", line 684, in ?
  totalLoaded += int(successRows)
ValueError: invalid literal for int():



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. FBL import for person DFF load.

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