Skip to main content

Notifications

Dynamics 365 Community / Forums / Human Resources forum / CoreHR Integration Pro...
Human Resources forum

CoreHR Integration Project to F&O Mapping Errors

Posted on by 25

Hi all,

I've configured the data integration project in power apps.

We already created our first integration project on another instance around December and it worked.

This month, we tried to create another CoreHR Integration Project(Talent CDS to F&O)

and this was the result.

TalentDataIntegration.PNG

Notice the Project has mapping errors.
Upon creation of the data integration project, the error was already prompted.


Upon checking the details of each task / table,
Only the Talent CDS Fields are accessible while in F&O side, no fields were able to be searched.
Which the error shows as mapping errors.

FieldsMissing.PNG

I tried 3 times in recreating this and still got the same error.

Condition:

- The new environment was provisioned first week of January.
- I've used the company DAT which is available in both platforms (Talent & F&O).
- Verified environments assigned for Talent and Finance & Ops to be used in connection sets.

Any help would be very much appreciated.

Best regards,
Jessie Villareal

Categories:
  • Jessie Villareal Profile Picture
    Jessie Villareal 25 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi nicu,

    Sorry for the delay. I noticed my email didn't send back to this thread.

    I also tried switching the connection,  from (org12345 to USMF) to (USMF to org12345) 

    And still resulted to the same issue.

    Checked the security roles for both environments, and yes I already assigned System Administrator to the account.

    I also tried recreating the connection in power apps and that too doesn't work.

    Connection to Operations

    Connection to Common Data Source

    Still didn't work.

    Any more suggestions?

    Best regards,

    Jessie Villareal

  • Suggested answer
    Nicu Aleman Profile Picture
    Nicu Aleman 2,587 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi Jessie,

    for this to work, it needs to be the other way around: FinOps to CDS (USMF to org12435)

    DatasetCDS.PNG

    I also assume you are sys admin in Finance and Ops and on the CDS environment. Are you familiar with the CDS security roles?

    regards,

    Nicu

    read my blog: https://talent.asgcrm.com

  • Jessie Villareal Profile Picture
    Jessie Villareal 25 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi nicu,

    Sorry for the delay.

    Yes our mapping look like that but instead (org12345 to USMF) TalentCDS/environment to F&O organization.

    Best regards,

    Jessie Villareal

  • Nicu Aleman Profile Picture
    Nicu Aleman 2,587 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi Jessie,

    does your organisations mapping you look like this: "USMF to org5454f3r"  (org from F&O to CDS Org) ? isn ot USMF to USMF, but F&O org to CDS Org

  • Jessie Villareal Profile Picture
    Jessie Villareal 25 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi nicu,

    Thank you for your quick response.

    I've tried to create another organization present on both Talent & F&O and use it for the connection set with blank F&O fields.

    Still, it resulted to mapping errors.

    Update1.PNG

    Best regards,

    Jessie Villareal

  • Jessie Villareal Profile Picture
    Jessie Villareal 25 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi nicu.

    Will try this :)

    Best regards,

    Jessie Villareal

  • Suggested answer
    Nicu Aleman Profile Picture
    Nicu Aleman 2,587 on at
    RE: CoreHR Integration Project to F&O Mapping Errors

    Hi Jessie,

    I believe (not sure) the problem with using the DAT company (that is the default company for keeping the system data). Did you try for another organization?

    regards,

    nicu

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,888 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,247 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans