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

Need columns 'Custom Filter's Context' and 'Add Custom Filter' in BIP report from Career site - IRC

Summary:

I am building a BI query to take out all the basic details of career site, here, I have requirement of two more columns 'Custom Filter's Context' and 'Add Custom Filter', This is descriptive flexfield associated with table 'IRC_REQUISITION_B' column - 'ATTRIBUTE_CHAR2', now as per the requirement I want to map each site id with these two columns. I found out one possible match with 'SITE_ID' including tables - IRC_REQUISITION_B(contains requistion_id) → IRC_PUBLISHED_JOBS(contain Site_id and Requisition id) → IRC_CX_SITES_VL(a view containing site_id and name). But the problem is IRC_PUBLISHED_JOBS only have site_id as '1' for all the entries. Is there

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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