ORA-01747 Error Has Occured In Detail Client Data Loader With Replace Mode (Doc ID 416345.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2
This problem can occur on any platform.

Symptoms

When attempting to load data into an Account table using the Detail Client Data Loader function the following error occurs when using the Replacement mode. The error does not occur when using the Snapshot mode for the same data. The problem does not occur for Transaction or Statistic table.

ERROR
An unexpected error has occurred: ORA-01747: invalid user.table.column, table.column, or column specification. Please contact your System Administrator.

STEPS
The issue can be reproduced at will with the following steps:
1. Load data into Account table using Detail Client Data Loader in Snapshot mode successfully.
Navigation:
From Process Management -> Requests -> Submit Requests > Choose the Detail Client Data Loader concurrent program to launch the load.

2. Load data into Account table using Detail Client Data Loader in Replacement mode and it fails.

.

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