Job Function Name — 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

Job Function Name

edited Mar 14, 2018 1:11PM in Reporting and Analytics for HCM 3 comments

Summary

Need Function Name in BI Publisher report

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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