ORA-01747 Error Has Occured In Detail Client Data Loader With Replace Mode
Last updated on OCTOBER 04, 2016
Applies to:Oracle Enterprise Performance Foundation - Version: 126.96.36.199
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.
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