Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
EDMCS Skip ancestor and get first occurrence of the ancestor with property equals Y — Cloud Customer Connect
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

EDMCS Skip ancestor and get first occurrence of the ancestor with property equals Y

Received Response
1
Views
1
Comments

Summary:

EDMCS Skip ancestor and get first occurrence of the ancestor with property equals Y, any pointers ?

Content (required):

I am trying to solve a DM problem in EDMCS, any guidance?


Here is the hierarchy

         

        EPBCS_Flag

A123-------Y

  B123------

    Z123 (is base node)

   C123----

     D123 (is base node)


in the DM they want B123 to be the parent of D123 because its direct parent C123 does not have Y for EPBCS_Flag.

Child | Parent

D123 | B123

Z123 | B123


I tried ancestor node property logic to find any ancestor that has a value of Y for EPBCS_Flag but it gets Y not the B123 in the parent

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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