My Oracle Support Banner

Account Hierarchy by Generate Hierarchy button (Doc ID 761942.1)

Last updated on NOVEMBER 15, 2017

Applies to:

Siebel Pharma Sales - Version: 7.8.2.3 SIA [19221] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Goal


a) 'Restore Hierarchy button on the UI populates the S_DYNHR_RPT_REL table based on entries in S_DYN_HRCHY_REL. Could you be more clear on that on how actually it gets filled. Is it something like that for every entry in S_DYN_HRCHY_REL, 2 records ('SELF' and 'DIRECT'(if it has parent)) are created in S_DYNHR_RPT_REL. or else what is the concept behind that.
b) Similar question for 'Generate Hierarchy' button. Which all tables are populated and on the basis of what ?
c) If I have to totally remove the Hierarchy present in our sys and then generate them again, what do I do ?

Solution

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
  Goal
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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