Not Able To Add Classification Codes To The Classification Category

(Doc ID 2345354.1)

Last updated on FEBRUARY 13, 2018

Applies to:

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

Goal

How to add Classification Codes to the Classification Category, if previously the category was disabled / enabled through Web Service Call

Currently the customer created a Classification Category first, the classification codes where coming up after inserting the where clause : WHERE PARTY_TYPE = 'ORGANIZATION'. They have disabled the category and enabled again through WS Call.

After this process the codes are not coming up, and triggering error message : No tree found for tree structure HZ_CLASSIFICATION_HIERARCHY

Steps to reproduce :

1.Create one Classification Category for FSM Task "Manage Classification Categories" with values as below.
2.Classification Category: CustomName
3.Classification Category Meaning: Custom Field Segmentation
4Classification Category Description .unchecked Allow Parent Code Assignment ; checked Allow Multiple Class Code Assignment

Under Entity Assignment clicked on "+" button and given Values as below.
Table Name: HZ_PARTIES ; Where Clause: WHERE PARTY_TYPE = 'ORGANIZATION'

Disable the classification category through WS call and enable it again.

Go to the same task, click on the classification category that was re-enabled and then Under Classification Codes when click on Add Button "+" getting error : "No tree found for tree structure HZ_CLASSIFICATION_HIERARCHY"

 

Solution

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