Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
2798
Views
15
Comments
2»

Answers

  • MandeepGupta
    MandeepGupta Rank 6 - Analytics Lead

    Hi Pam,

    SectionId is a mandatory attribute which you will need to pass. Also, please try adding DateFrom and DateTo fields as well.

    SourceSystemId is fine. Please check if the source system owner exist in the HRC%SOURCE%SYSTEM% lookup.

    Check the below link to find section id:

    Thanks.

  • PamS
    PamS Rank 3 - Community Apprentice

    Thanks again Mandeep

    I now am able to get the loader to work BUT it isn't updating an existing record - it is adding a new one

    METADATA|ProfileItem|ContentItemId|ContentTypeId|ItemText2402|SourceSystemOwner|SourceSystemId|ContentType|ContentItem|ProfileCode|SectionId|DateFrom

    MERGE|ProfileItem|300000002696418|103|123456|HRC_SQLLOADER|PP_929347_PERSON_LC1|PERSON_CERTIFICATION|APEGS|929347_PERSON|1901|2021/08/19

    MERGE|ProfileItem|300000002696312|103|789012|HRC_SQLLOADER|PP_929347_PERSON_LC2|PERSON_CERTIFICATION|EGBC|929347_PERSON|1901|2021/08/19

    Am I missing something else that will allow it to update the record instead of adding a new one

    Also - do you know of a SQL query that could pull all of the pieces together (I am going to have to do a mass load and would like to run a report that gives me all the keys

    Thanks

    Pam

  • MandeepGupta
    MandeepGupta Rank 6 - Analytics Lead

    Hi Pam,

    To update existing records,you will need to use the existing source system keys. For that you will need to query hrc_integration_key_map table.

    Use below joins:

    HRT_PROFILE_ITEMS HPI, HRC_INTEGRATION_KEY_MAP HIKM, HRT_PROFILES_B HPB

    WHERE HIKM.SURROGATE_ID = HPI.PROFILE_ITEM_ID 

    AND HPI.PROFILE_ID = HPB.PROFILE_ID

    You can check the sample queries at below link:

    http://fusionhcmconsulting.com/2021/02/reports-bip-query-to-get-content-item-details/

    Thanks.

  • PamS
    PamS Rank 3 - Community Apprentice

    Hi Mandeep,

    Thank you for all of the help. I have gotten the loader to work for those records that need to be updated.

    When Inserting a new record, what Source System Id do I use or can I have the loader generate this key?

    Pam