Overview

Oracle Hyperion Financial Data Quality Management, Enterprise Edition automatically initializes the data load workflow context information prior to invoking the Import, Mapping and Event scripts. The fdmContext object is initialized with the list of properties listed below. The properties can be accessed by referencing FDMCONTEXT.GET["<PROPERTY NAME>"]. For example, to access Location Name, use FDMCONTEXT.GET["LOCNAME"]. To execute a script for a specific data load, write something like the following:

if FDMCONTEXT.GET["LOCNAME"] == "ITALY":
     Write script logic here

FDM object properties include:

  • APPNAM

  • APPID

  • BATCHSCRIPTDIR

  • CATKEY

  • CATNAME

  • CHKSTATUS

  • EPMORACLEHOME

  • EPMORACLEINSTANCEHOME

  • EXPORTFLAG

  • EXPORTMODE

  • EXPSTATUS

  • FILEDIR

  • FILENAME

  • IMPORTFLAG

  • IMPORTFORMAT

  • IMPORTMODE

  • IMPST

  • IMPSTATUS

  • INBOXDIR

  • LOADID

  • LOCKEY

  • LOCNAME

  • MULTIPERIODLOAD

  • OUTBOXDIR

  • PERIODNAME

  • PERIODKEY

  • PROCESSSTATUS

  • RULEID

  • RULENAME

  • SCRIPTSDIR

  • SOURCENAME

  • SOURCETYPE

  • TARGETAPPDB

  • TARGETAPPNAME

  • VALSTATUS