Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Loading Open Interface table using BefImport script fails

edited Aug 23, 2016 5:00AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered ✓

Hi there, I'm using FDMEE on version 11.1.2.3.700.09 and struggling to get this script to work and load the open interface table with data from the GL.

Here is the script:

import java.sql as sql

batchName = "Batch_" + str(fdmContext["LOCATION"])

insertStmt = """INSERT INTO AIF_OPEN_INTERFACE

( BATCH_NAME

,YEAR

,PERIOD

,SCENARIO

,ENTITY

,AMOUNT

,ICP PARTNER

,CUSTOM1

,CUSTOM3

,VALUE

)

SELECT ?, year, period, scenario, entity, amount ,icp partner, custom1, custom3, value) FROM [VSGLWSQL1].[CUSTOMERDBNAME].[DBO].[rHFMFinancialData]

params = [batchName, "2016","Jan"]

fdmAPI.executeDML(insertStmt, params, False)

fdmAPI.commitTransaction()

and here is the error:

2016-08-15 12:45:11,673 INFO  [AIF]: Executing the following script: \\srv-glas507\FDMData/data/scripts/event/BefImport.py

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center