6 Replies Latest reply on Dec 22, 2017 9:43 AM by user111989

FDMEE custom script

2741871 Dec 14, 2017 2:25 PM

Is it possible to use script to validate an account balance from FDMEE load file against a HFM account which is calculated in HFM at FDMEE validation stage? For example, HFM calculated the beginning retained earnings (calculated account). We map the beginning retained earning accounts from load file to a HFM statistical account. We'd like to verify if the loaded statistical account equal to the calculated account. If not, prevent the export.

Your input is appreciated!

1. Re: FDMEE custom script

2741871 Dec 19, 2017 8:13 PM (in response to 2741871)

Anyone has experience on this? Is this possible?

Thanks!
Like Show 0 Likes(0)

Actions
2. Re: FDMEE custom script

user111989 Dec 20, 2017 9:36 AM (in response to 2741871)

A rough idea. You may export the HFM data into the tables using extended analytics and then during validate step or bef-export step you can query the table to fetch the value of the calculated accounts and compare it with statistical account and perform the necessary actions.
Like Show 0 Likes(0)

Actions
3. Re: FDMEE custom script

2741871 Dec 20, 2017 8:32 PM (in response to user111989)

Thank you Abhijeet! Can you help me understand why during validation step or bef-export step it is not possible to query the HFM table to fetch that data directly?

Thanks again!
Like Show 0 Likes(0)

Actions
4. Re: FDMEE custom script

user111989 Dec 21, 2017 8:49 AM (in response to 2741871)

I believe its not easy or possible to directly query the HFM tables to fetch the data so the best option is to export the HFM data which is required to the external tables and query these tables
Like Show 0 Likes(0)

Actions
5. Re: FDMEE custom script

2741871 Dec 21, 2017 2:57 PM (in response to 2741871)

Ok. Thanks for the explanation. Can you please explain an example of such the validation script?
Like Show 0 Likes(0)

Actions
6. Re: FDMEE custom script

user111989 Dec 22, 2017 9:43 AM (in response to 2741871)

You need to execute select queries against the fdmee table and hfm table.

You can refer the scripts over here fishing with FDMEE
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.