Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

HCM Cloud Additional Earnings Integration with EPM Enterprise WFP module

edited Dec 17, 2019 1:16PM in Planning 2 comments

Summary

In DM, using mapping keeps appending to new Earnings[N] members. Data uniqueness on Property dimension via LOOKUP in target is unclear.

Content

I'm trying to map the following multi-column file to the EPM Enterprise WFP module.

Here's the exported results in DM Workflow

Here's the data load configuration in Planning

Here's my import format

Here's my LINEITEM Account Data Mapping.

Here's my Data Load Rule for this location

For the first run, the LINEITEM mapping work's fine.   Smart View results are:

However, when I re-load the same file with no changes,  I expect LINEITEM mapping to overwrite, not Append to new Account members (Earning3 and Earning4).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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