Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM Mappings (One source account to Many Target account)

916534May 2 2012 — edited May 8 2012

Hi All,

We have requirement from one source account 32100 (ICP Receivables and Payables Account) to be mapped to Two HFM target accounts the Debit amount (ICP Payables) should be mapped to one account & Credit amont (ICP Receivables) should be mapped to another acccount.

1. IF debit balance will map to HFM account 1000 (Receivable)

2. IF credit balance will map to HFM account 2000 (Payable)

I know it is not possible in one to one mappings (Explicit Maps).

Is it possible through like maps, if yes please suggest me how it is.

My Import file format is as follows.

Account(Local) - Description - Beginning Bal - Period Activity - Ending Bal
321000 Icp rec/pay 1100 100 1200

Please suggest me what needs to be done in this case.

Thanks,

Edited by: 913531 on May 2, 2012 7:30 AM

Edited by: 913531 on May 2, 2012 7:33 AM

Edited by: 913531 on May 2, 2012 8:27 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2012

Added on May 2 2012

#business-intelligence-applications, #financial-data-management, #performance-management-applications

6 comments

598 views