Field Location Help (License/Cert - Item Code )

Andrew Mc

Summary:

I am trying to add the 'Item Code' for license/certifications. I have gone through all the fields under Workforce Profiles - Person Profile Real Time related to Licenses/Certifications, but unable to find this field. The Item Code can be found under: Talent>Item Catalogs>Licenses And Certifications. Am I looking in the wrong subject area or are you able to tell me which field I would need to pull onto my report?

Thank you,

Andrew

Version (include the version you are using, if applicable):

Oracle Cloud Application

21D (11.13.21.10.0)

Code Snippet (add any code snippets that support your topic, if applicable):

n/a

Sowmiya Velusamy

Hi Andrew,

Item Code is in below Navigation:

Profile Types> Person>content Section click "Licenses and Certification" we has Code as shown below

These DFF Context Code is used as SectionName in HDL File,Are you looking for these?

METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|DateFrom|DateTo|ProfileCode|ContentType|ContentItem|CountryCountryCode|ProfileId(SourceSystemId)|SectionName

Thanks,

Sowmiya Velusamy

Dave Whitson

I believe Andrew is looking for employee License detail for an OTBI report. I am looking for the same. Any help pointing us to the subject area that contains this data would be appreciated.

Nathan CCC

Hi,

If you want to find an attribute, or confirm an attribute is not mapped since some are not, in a subject area to use in an analysis or report in OTBI then you can view the data lineage to see what attributes in the application database view object columns are mapped to presentation tables and columns in the subject areas in the metadata repository database in OTBI.

Go to docs https://docs.oracle.com/en/cloud/saas/human-resources/24a/analyze-and-report.html

then select Review data lineage mapping

then download the latest release available for example 24 A

https://us.v-cdn.net/6034893/uploads/OKMPARKHC0K0/rel13-24a-hcm-otbi-database-mapping-with-viewobjects.xlsx

Nathan CCC

Looking at your session log then this may be the view used to get licences and certifications for a person

HRT_BI_CERTIF_ITEMS_V

https://docs.oracle.com/en/cloud/saas/human-resources/24a/oedmh/hrtbicertifitemsv-6677.html#hrtbicertifitemsv-6677

...FROM HRT_PROFILE_ITEMS PI, hz_geographies HG, hz_geographies HZ , fnd_territories_b TB
WHERE PI.CONTENT_TYPE_ID = 103
AND PI.COUNTRY_ID = HG.GEOGRAPHY_ID(+)
AND PI.STATE_PROVINCE_ID = HZ.GEOGRAPHY_ID(+)
AND HG.COUNTRY_CODE = TB.TERRITORY_CODE(+)
AND PI.BUSINESS_GROUP_ID <> NVL(FND_PROFILE.VALUE('ORA_HRT_PROFILE_DATA_MIGRATED'),0)

so assume the code column you are looking for is maybe from this application table?

HRT_PROFILE_ITEMS.CONTENT_ITEM_CODE

https://docs.oracle.com/en/cloud/saas/human-resources/24a/oedmh/hrtprofileitems-26147.html#hrtprofileitems-26147

Dave Whitson

Thank You Nathan CCC!

Was able to download Rel13_24A_HCM_OTBI_Database_Mapping_with_ViewObjects.xlsx

From this I filtered on column "SUBJECT AREA" and located "Workforce Profiles - Person Profile Real Time".

Then Filtered column "PRESENTATION_TABLE" for value "-Licenses and Certifications".

This Subject Area appears to be what I need. However, in OTBI this subject area is not available for me to select.

My thought is that this is due to a permission issue. If this is the case, would you happen to know what role I would need to be able to see and select the "Workforce Profiles - Person Profile Real Time" subject area?

And is there documentation that lists the roles needed for specific subject areas?

Thanks In Advance!

Dave

Nathan CCC

Hi,

Yes here is the documentation regards roles you need.

The duty roles are required so that you can query the subject area without the system throwing a database connection error. The duty role is inherit by the job role.

Inside the job roles are also the data security policies that may be used by the subject area for data security. In general to view more than your own record or your persons as a line manager you will need to use page "Manage Data Roles and Security Profiles" to create a custom data role, that inherit this job role or a custom copy of this job role, with security profiles configured in that custom data role for example a person security profile to view more persons like the out of the box one "View All People".

Analytics and Reports for application X for example HCM then select Review X Subject Areas

https://docs.oracle.com/en/cloud/saas/human-resources/24a/analyze-and-report.html

Workforce Profiles - Person Profile Real Time

https://docs.oracle.com/en/cloud/saas/human-resources/24a/faohb/Workforce-Profiles--Person-Profile-Real-Time-SA-52.html#Workforce_Profiles__Person_Profile_Real_Time_SA_52_d1e19300

Job Roles

The following job roles secure access to this subject area:

Human Resource Analyst

Duty Roles

The following duty roles secure access to this subject area:

Workforce Profile Transaction Analysis Duty