ISetup (AZR12LOADER) In R12.2.3: Fails To Load With Error: Only Insert Is Allowed But Update Is Not Allowed... Please Updatable_Flag In Az_Apis... (Doc ID 1951125.1)

Last updated on JUNE 22, 2015

Applies to:

Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.
AZR12LOADER

Symptoms

While extracting are reporting from DEV1, for both DEV1 and DEV2 it shows 13 subinventories whereas in reality we have only 9 in DEV2.There is no warning/ error in this stage in extraction or with reporting.
For loading, yes the load request ends up in warning, the log files which we have uploaded to SR.Only while loading to DEV2 we gets error and this is the point where system shows an issue, though in extract step itself it extracted wrongly.

Error
The log file shows:


Steps
Using iSetup R12 Loader:

1. Data gets extracted only in one instance though iSetup configured in two servers (directly linked).
2. Report on extracted data also shows incorrect on target instance.
3. While loading the extracted data on target instance, it ended in warning.
4. Some times while trying to load data it shows already exists error.

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