Help with Extracting L1/L2/L3 Managers in Reports

Guy_Ora

Hi,

We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN).
In most cases, the extraction works fine — but in specific scenarios, some employees don’t appear at all, likely due to how the query is structured.

If you’ve solved something similar, I’d really appreciate it if you could share the code/logic you're using to pull the hierarchy in your reports.

Thanks in advance!

Gianni Ceresa

Hi,

Your question seems to imply some common data structures or models. Publisher as a tool doesn't contain any data.

What product are you talking about? If it's some data available by default in another product (Fusion apps etc.), you should consider asking in the forum covering those products, like https://community.oracle.com/customerconnect for Fusion and co.

If it's some custom model you built yourself, you should consider providing more details on how your hierarchy is modelled, what your publisher model looks like etc.