My Oracle Support Banner

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:
This problem can occur on any platform.


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.

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

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.
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.



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.