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!

Loading Invalid ICPs to HFM

798182Apr 11 2011 — edited Oct 1 2012

Hi Guys,

I was wondering if one of you knows a script or way to prevent FDM to load ICP details to target HFM accounts that are flagged 'N' to carry ICPs.

The source file from SAP is having accounts carrying ICP details while its target in HFM cannot. What would be a maintenance free way to prevent this?

Overwriting the ICP details for the source accounts is not an option from maintenance perspective as they can be changed, extended etc. I would rather have some lookup script before validation that overwrites the ICP details to [ICP NONE] in case the varvalues(14) is not allowed to carry ICP.

If anyone knows this script, I would highly appreciate it!

This post has been answered by beyerch2 on Apr 11 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2012

Added on Apr 11 2011

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

19 comments

830 views