nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Need to identify requisitions where we hire candidates from a parent pool requisition

JDCal

Trying to find out what requisition an employee is hired on from a parent/pool requisition and add it as a condition in a query.

I am learning this process now and from what I have seen maybe creating a flexfield would be the only option that identifies a parent requisition.

Just wondering if anybody has had to do something similar?

We are on HCM 24A. Trying to do this with SQL in Bi Publisher.

Thanks much!

Find more posts tagged with

BIP

Reporting

BI Publisher

OTBI

Accepted answers

Gianni Ceresa

@JDCal ,

Your question is about data in a Fusion application, you should ask in the forum that look after that product. BI Publisher is only the technical platform where your query will be executed, not really the topic of your question.

Fusion is covered in a parallel forum (the question can't be moved there): https://community.oracle.com/customerconnect

Have a look at the available categories and ask in there about where you can find the data you are after.

All comments

Renuka Nuguru-Oracle

@Nupur Joshi-Oracle This looks like fusion HCM product not OAC/OAS - Please review

Gianni Ceresa

@JDCal ,

Fusion is covered in a parallel forum (the question can't be moved there): https://community.oracle.com/customerconnect

Have a look at the available categories and ask in there about where you can find the data you are after.

JDCal

Thanks for your respnses!