Need to find where the Certificate Number is in the Subject Area

PamS · September 2021

Summary: Need to retrieve the Certificate Number under Licenses and Certifications for an employee

"- All Profile Content"."Content Type" = 'Licenses and Certifications'

Content (required): Subject Area is "Workforce Profiles"-"Person Profile Real Time"

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

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

MandeepGupta · October 2021

Hi Pam,

You can use User Keys and skip the Source System Id and Source System owner attributes. In this application will auto generate these Ids. However, it is advisable to use these keys using HDL. You can put it any logic to generate the source system ID like Talent Profile_ProfileCode_ContentItem_Date From

Any code that uniquely identifies the record.

Thanks.

User_OPDFK · September 2021

Did you try the folder named "Person Profile" in that subject area? There is a "Licenses and Certifications" subfolder with "Certificate Number" to choose

.

PamS · September 2021

Thanks for the suggestion - I hadn't thought to look in the Licenses Folder - unfortunately the field appears to be blank even though my screen is showing data.

I need to show the field on a report as well as build a loader for it

Any other thoughts/suggestions?

Pam

User_OPDFK · September 2021

Above the Licenses and Certifications folder there is the "All Profile Content" folder.

I've found our license/certificate numbers also in the "ItemText2402" and "ItemText2403" has the license/certificate name

PamS · September 2021

Thanks - I just checked and unfortunately those fields are showing as blank as well :-(

I can see the value on the screen - I just can't seem to find where it is stored in the subject area or base table.

Pam

User_OPDFK · September 2021

There are a couple of tables you can use datamodel to enter a query to select * from hrt_certification_items_v then look at the sample data.

The link below is the guide for the tables. there are a couple of tables for the profile data where the certification is stored.

https://docs.oracle.com/en/cloud/saas/human-resources/20b/oedmh/profile-management.html#hrtcertificationitemsv-9078

PamS · September 2021

Thanks for the help - I was able to find the Certificate Number in the subject area - My filter was eliminating the records I was looking for.

Second part of my problem is that I need to create a loader to enter in the Certification Number. I am looking in Business Objects Talent Management -> Content Item but I unfortunately don't see the Certificate Number there

Am I looking in the right place?

MandeepGupta · September 2021

Hi Pam,

You will need to use ContentItem.dat only. So, you are at correct place.

Check the attached excel file to find the attribute to store certificate number.

Let me know if you need any more details.

Thanks.

Profile_Management_Content_Template_Definitions.xlsx

PamS · September 2021

Thanks Mandeep

Would you happen to have a sample of this loader? I took a look at the spreadsheet but I don't see any keys relating to the employee

I downloaded the .dat file but I am not sure what fields I need to map (had to change it to a .txt so that I could attach it here)

ContentItem.txt

I also don't see ITEM_TEXT240_2 (or even TEXT240) which according to the spreadsheet that you provided is where the Certificate Number would go.

Thanks

Pam

MandeepGupta · September 2021

Hi Pam,

My apologies. You would need to use Talent Profile -> Profile Item HDL for uploading this data.

Below is sample file:

MERGE|ProfileItem|||PERSON_300000001111|Analytics Professional||CERTIFICATION||IN|||2020/01/01|||||||||||2022/12/31|2023/01/01||2020/01/01||2023/06/01|2019/12/31||||||||2000|1000|2020||||||Test University|https://www.xyz.com||||Test Certificate|||||||CN09091112||XYZ|||2|||Y||||||||||N|Y||A||||||||||||||||||||||||||||||||PP_30000000111_CERT|HRC_SQLLOADER

This contains list of all the attributes available in HDL. You can remove the unwanted ones and create a similar one.

Let me know if you face any issues.

Thanks.

PamS · September 2021

Hi Mandeep

I created a TalentProfile.dat file using the following headers and information but keep getting an error

error:

An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: Index: 0, Size: 0.

I tried to find the HCM Data Loader Error Analysis Report but couldn't find it.

I created my own sourcesystemid - does this need to match something in the system? If so, how would I find that out?

Thanks

Pam

Oracle Transactional Business Intelligence

Categories

Need to find where the Certificate Number is in the Subject Area

Best Answer

Answers