You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Format Tree-Style Hierarchy Extract in EDMCS Without Repeating Ancestors?

Hi everyone,

I'm trying to replicate a tree-style hierarchy extract in Oracle EDMCS, where each node appears only once and is aligned to its respective generation level. The goal is to generate a clean, indented report that visually represents the hierarchy like this:

Instead of this:

I’ve tried several approaches, including generational extracts with node filters, but I haven’t been able to suppress repeated ancestor names across rows. What I’m aiming for is a layout where:

  • Each node is shown once.
  • Nodes are aligned to their generation level.
  • The hierarchy is visually clear without duplicating parent nodes across rows.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!