Job Function Name
Summary
Need Function Name in BI Publisher reportContent
Hello,
I am building a BI Publisher report and need to pull in the Job Function Name
I found the JOB_FUNCTION_CODE on the PER_JOBS_F table, but I cannot find the Job Function Name anywhere
The field is available in OTBI and edit formula shows it to be "Job"."Job Function Name"
I have poured over every table related to Job on https://docs.oracle.com/cloud/farel12/globalcs_gs/OEDMH/toc.htm
and searched R12_HCM_OTBI_Database_Mapping_with_View_Objects_v2, but it lists the JOB_FUNCTION_CODE as the source for the name