FDMEE - Jython script error
edited Jul 21, 2015 9:10AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 3 commentsAnswered
Hi Experts,
I am using following script as befimport to import exchange rates to the AIF interface tables. The VAriable marked in Red is giving me an issue, if in the where clause instead Where to_char(Conversion_Date,'Mon-YYYY') = 'strPer' of the (StrPer) variable i define Where to_char(Conversion_Date,'Mon-YYYY') = 'May-2015' the script works perfectly fine. and populates the AIF_Open_Interface table with the Rates from EBS.
Can someone help
import java.sql as sql
if fdmContext["LOCNAME"] == "Test":
strPOVPer=fdmContext["PERIODNAME"]
strPer= str(fdmContext["PERIODNAME"])
batchName = "Batch_" + str(fdmContext["LOCNAME"])
insertStmt = """
INSERT INTO AIF_OPEN_INTERFACE (
0