13 Replies Latest reply on Jun 6, 2017 2:58 PM by user17

    Duplicating row with Jython

    3355552

      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!