Skip to Main Content
Forums

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 EventScript not working with Batch Load

user96869Nov 17 2009 — edited Nov 18 2009
Hi,

We built an EventScript in ImportAction in FDM that is working fine when we import file individually using the FDM Webclient.

The script is validating Total # of records, total DT and Total Credit that we have in the file and compare with a control line that is included in the file Extract from SAP. That control line is always the last line in each eatract and it contains # of records, Total DT and Total Credit. If it doesn't reconcile it won't Import. In our script, it's looking for the files that are in the OpenBatch folder but when FDM laucnh the process it renames the folder and then load the extract.

Our problem is we are using Batch Process to load our data in to HFM and that new script is not working with that process. We are implementing SAP on part of the business and SAP extract has that control line and managers want's FDM not to import the file it the control is not working.

Anyone has a idea how to make that script working?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 16 2009
Added on Nov 17 2009
#business-intelligence-applications, #fdm, #financial-data-management, #not, #performance-management-applications, #process, #with
3 comments
2,275 views