My Oracle Support Banner

Classification Files Going To Unsuccessful Intermittently (Doc ID 2555933.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On  : 11.13.18.10.0 version, Accounts, Contacts, Households

Classification files going to unsuccessful intermittently

It's been observed that while using Account - Simplified Loader, classification loading goes to unsuccessful with the below error. But upon rerunning, it works fine. You have Account,Address and Classification zipped together as single file for loading.

ERROR
-----------------------
The reference to the parent entity HZ_CODE_ASSIGNMENTS using the identifier column CODE_ASSIGNMENT_ID is invalid. (HZ-120733)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OSC
2. Navigate to File import process
3. Run an import job -> Failed with error

BUSINESS IMPACT
-----------------------
This is affecting the classifications loaders where it fails with an error and affecting the data load in production.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.