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

MOSC Banner

Error in Jython script in FDMEE to load data to the OPEN_INTERFACE

edited Sep 22, 2014 7:06PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 7 commentsAnswered ✓

Hello,

I have created an jython script to load data from an external table to the AIF_OPEN_INTERFACE in FDMEE.

#-------------------------------------------------------------------------------------------#

# Purpose: Extract data from source table and load open interface table #

# April 3, 2014 #

# Oracle Corporation #

#-------------------------------------------------------------------------------------------#

#

#--------------------------------------------------------------------#

# Import Java sql class for data management operations  #

#--------------------------------------------------------------------#

import java.sql as sql

# import java.math.BigDecimal as BigDecimal #

#--------------------------------------------------------------------#

# Define variables and set up INSERT statement that will  #

# be used to insert into the open interface table          #     

#--------------------------------------------------------------------#

batchName = "KEY_CRP2"

myCurrency = "PEN"

insertStmt = """

INSERT INTO AIF_OPEN_INTERFACE (

BATCH_NAME

,YEAR

,PERIOD

,PERIOD_NUM

,CURRENCY

,COL01

,COL02

,COL03

,COL04

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