Error in Jython script in FDMEE to load data to the OPEN_INTERFACE
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