Hi everyone , I put my import script in Amount column in Import Format.
My import script is to double / duplicate lines:
def sc_CompanyRight(strField, strRecord):
# '------------------------------------------------------------------
# 'Oracle Hyperion FDMEE Custom Script:
# 'Purpose: doubling amount for Transaction currency in Company
# '
# '------------------------------------------------------------------
sDelimiter = strRecord.split(";")
sACCOUNT = sDelimiter[12]
aACCOUNT = sACCOUNT[0]
sSkip = sDelimiter[0]
#skip unecessary area
if sSkip == "":
return fdmSkip
#no movement type
if (aACCOUNT == "1" or aACCOUNT == "2" or aACCOUNT == "3" or aACCOUNT == "4" or aACCOUNT == "5" or aACCOUNT == "6"):
fdmResultMap["ENTITY"] = "OBSA"
fdmResultMap["ACCOUNT"] = sDelimiter[12]
fdmResultMap["ICP"] = sDelimiter[4]
fdmResultMap["UD1"] = "[None]"
fdmResultMap["UD2"] = "[None]"
fdmResultMap["UD3"] = "NOMOVE_T"
fdmResultMap["UD4"] = sDelimiter[15]
fdmResultMap["AMOUNT"] = sDelimiter[16]
#Doubling the amount for P n L account
if (aACCOUNT == "3" or aACCOUNT == "4" or aACCOUNT == "5" or aACCOUNT == "6"):
fdmResultMap["ENTITY"] = "OBSA"
fdmResultMap["ACCOUNT"] = sDelimiter[12]
fdmResultMap["ICP"] = sDelimiter[4]
fdmResultMap["UD1"] = "[None]"
fdmResultMap["UD2"] = "[None]"
fdmResultMap["UD3"] = "NOMOVE_L"
fdmResultMap["UD4"] = sDelimiter[15]
fdmResultMap["AMOUNT"] = sDelimiter[20]
I try to upload the file with this one liner data:
110170;Trade receivables (group);;EUR; 8,130,802 ;0.891910; 9,116,169 ;1.000000; 9,116,169 ;; - ;;210170;Trade accounts payable (group);;EUR; 8,130,816 ;0.001524; 5,333,459,579 ;585.053950; 9,116,184 ;;;;-15 ;;15
Those codes give me error of:
2017-06-04 18:36:38,302 DEBUG [AIF]: EPMFDM-140274:Message - Error Evaluating scriptnullorg.python.core.PyException.fillInStackTrace(PyException.java:70)
Seems like it cannot read the record.
Any idea what is wrong with my import script????
Tx!