12 Replies Latest reply on Jun 23, 2015 1:06 PM by 2698643

    TypeError: cannot concatenate 'unicode' and 'NoneType' objects

    2698643

      Anybody have any insight to the recent error we are getting in FDMEE 11.1.2.3.520.

        • 1. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
          Francisco Amores

          is that happening during mappings?

           

          if you use multi-dim mappings this happens when you leave blank any of the criteria

          if you use mapping scripts this happens when you leave blank the script

          1 person found this helpful
          • 2. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
            2698643

            HI Francisco

             

            I think it is happening during mapping.  In process detail it fails at transfer and stage balance data.  I will review the mapping for blanks once more.  I think we imported the maps from a working environment and still encountered the error, so I think the maps are working in the other environment.

            • 3. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
              Francisco Amores

              Do you have any mapping script?

               

              if so, how did you import mappings from the other env?

               

              Bear in mind that mapping scripts are not imported thru text files, just LCM.

               

              To check mappings I would suggest you query TDATAMAP table. It will be quicker.

               

              Cheers

              1 person found this helpful
              • 4. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                2698643

                No mapping scripts.  Just mapping via data load mapping.

                • 5. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                  Francisco Amores

                  Can you set lo level to 5 and attach your fdmee process log?

                  • 6. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                    2698643

                    2015-06-12 11:41:48,495 INFO [AIF]: FDMEE Process Start, Process ID: 2,626

                    2015-06-12 11:41:48,495 INFO [AIF]: FDMEE Logging Level: 5

                    2015-06-12 11:41:48,495 INFO [AIF]: FDMEE Log File: \\Vmhodamhcp1\fdmee\outbox\logs\CONSOL_2626.log

                    2015-06-12 11:41:48,496 INFO [AIF]: User:custadmin

                    2015-06-12 11:41:48,496 INFO [AIF]: Location:PSHFM (Partitionkey:16)

                    2015-06-12 11:41:48,496 INFO [AIF]: Period Name:Jan-2015 (Period Key:1/31/15 12:00 AM)

                    2015-06-12 11:41:48,496 INFO [AIF]: Category Name:Actual (Category key:1)

                    2015-06-12 11:41:48,497 INFO [AIF]: Rule Name:PeopleSoft_Actuals_All1 (Rule ID:38)

                    2015-06-12 11:41:50,606 INFO [AIF]: FDM Version: 11.1.2.3.520

                    2015-06-12 11:41:50,606 INFO [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

                    [Oracle JRockit(R) (Oracle Corporation)]

                    2015-06-12 11:41:50,607 INFO [AIF]: Java Platform: java1.6.0_37

                    2015-06-12 11:41:50,607 INFO [AIF]: Log File Encoding: UTF-8

                    2015-06-12 11:41:52,493 INFO [AIF]: -------START IMPORT STEP-------

                    2015-06-12 11:41:52,640 DEBUG [AIF]: CommData.preImportData - START

                    2015-06-12 11:41:52,646 DEBUG [AIF]: CommData.getRuleInfo - START

                    2015-06-12 11:41:52,649 DEBUG [AIF]:

                      SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

                      ,CASE

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N' 

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N' 

                      WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'

                      ELSE 'Y'

                      END SOURCE_ADAPTER_FLAG

                      ,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE

                      ,CASE brl.PLAN_TYPE

                      WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 ELSE 0

                      END PLAN_NUMBER

                      ,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG

                      ,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE

                      ,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

                      ,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE

                      ,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

                      ,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

                      ,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

                      ,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

                      ,CASE

                      WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'

                      WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

                      WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

                      ELSE 'NONE'

                      END LEDGER_GROUP_CODE

                      ,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

                      ,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

                      ,br.LEDGER_GROUP

                      ,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER

                      ,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG

                      ,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE

                      ,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID

                      ,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID

                      FROM AIF_PROCESSES p

                      INNER JOIN AIF_BAL_RULE_LOADS brl

                      ON brl.LOADID = p.PROCESS_ID

                      INNER JOIN AIF_BALANCE_RULES br

                      ON br.RULE_ID = brl.RULE_ID

                      INNER JOIN AIF_SOURCE_SYSTEMS ss

                      ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                      INNER JOIN AIF_TARGET_APPLICATIONS app

                      ON app.APPLICATION_ID = brl.APPLICATION_ID

                      INNER JOIN TPOVPARTITION part

                      ON part.PARTITIONKEY = br.PARTITIONKEY

                      INNER JOIN TBHVIMPGROUP imp

                      ON imp.IMPGROUPKEY = part.PARTIMPGROUP

                      LEFT OUTER JOIN AIF_COA_LEDGERS l

                      ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

                      AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

                      LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

                      ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

                      AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

                      AND scr.RECNAME = 'LED_GRP_TBL'

                      LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

                      ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

                      AND lg.SETID = scr.SETID

                      AND lg.LEDGER_GROUP = br.LEDGER_GROUP

                      WHERE p.PROCESS_ID = 2626

                      

                    2015-06-12 11:41:52,655 DEBUG [AIF]:

                      SELECT adim.BALANCE_COLUMN_NAME DIMNAME

                      ,adim.DIMENSION_ID

                      ,dim.TARGET_DIMENSION_CLASS_NAME

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

                      ,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE

                      WHEN 'CHILD' THEN 'N'

                      WHEN 'ROOT' THEN 'N'

                      ELSE 'Y'

                      END DIMENSION_FILTER_FLAG

                      FROM AIF_MAP_DIM_DETAILS_V mdd

                      ,AIF_MAPPING_RULES mr

                      WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

                      AND mdd.RULE_ID = mr.RULE_ID

                      AND mdd.DIMENSION_ID = adim.DIMENSION_ID

                      ) DIMENSION_FILTER_FLAG

                      ,tiie.IMPCONCATCHAR

                      FROM TPOVPARTITION tpp

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                      ON adim.APPLICATION_ID = 2

                      INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                      LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                      ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

                      AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

                      AND tiie.IMPMAPTYPE = 'ERP'

                      WHERE tpp.PARTITIONKEY = 16

                      AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                      AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                      

                      ORDER BY adim.BALANCE_COLUMN_NAME

                      

                    2015-06-12 11:41:52,659 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'PeopleSoft_Actuals_All1', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\damhc7\\hyperion\\user_projects\\epmsystem_vmhodamhcp1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'CONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 4L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'custadmin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 6L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 8L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 3L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 1L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 4L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 16L, 'PARTVALGROUP': u'CheckRulePS', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 38L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://vmhodamhcp1.oracleoutsourcing.com:5064/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

                    2015-06-12 11:41:52,659 DEBUG [AIF]: CommData.getRuleInfo - END

                    2015-06-12 11:41:52,679 DEBUG [AIF]: CommData.insertPeriods - START

                    2015-06-12 11:41:52,684 DEBUG [AIF]: CommData.getLedgerListAndMap - START

                    2015-06-12 11:41:52,685 DEBUG [AIF]: CommData.getLedgerSQL - START

                    2015-06-12 11:41:52,685 DEBUG [AIF]: CommData.getLedgerSQL - END

                    2015-06-12 11:41:52,686 DEBUG [AIF]:

                      SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID

                      ,NULL SOURCE_LEDGER_NAME

                      ,NULL SOURCE_COA_ID

                      ,br.CALENDAR_ID

                      ,NULL SETID

                      ,NULL PERIOD_TYPE

                      ,NULL LEDGER_TABLE_NAME

                      FROM AIF_BALANCE_RULES br

                      WHERE br.RULE_ID = 38

                      

                    2015-06-12 11:41:52,687 DEBUG [AIF]: CommData.getLedgerListAndMap - END

                    2015-06-12 11:41:52,690 DEBUG [AIF]: doAppPeriodMappingsExist - CONSOL: Y

                    2015-06-12 11:41:52,691 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY

                    2015-06-12 11:41:52,691 DEBUG [AIF]:

                      INSERT INTO AIF_PROCESS_PERIODS (

                      PROCESS_ID

                      ,PERIODKEY

                      ,PERIOD_ID

                      ,ADJUSTMENT_PERIOD_FLAG

                      ,GL_PERIOD_YEAR

                      ,GL_PERIOD_NUM

                      ,GL_PERIOD_NAME

                      ,GL_PERIOD_CODE

                      ,GL_EFFECTIVE_PERIOD_NUM

                      ,YEARTARGET

                      ,PERIODTARGET

                      ,IMP_ENTITY_TYPE

                      ,IMP_ENTITY_ID

                      ,IMP_ENTITY_NAME

                      ,TRANS_ENTITY_TYPE

                      ,TRANS_ENTITY_ID

                      ,TRANS_ENTITY_NAME

                      ,PRIOR_PERIOD_FLAG

                      ,SOURCE_LEDGER_ID

                      )

                      

                      SELECT DISTINCT brl.LOADID PROCESS_ID

                      ,pp.PERIODKEY PERIODKEY

                      ,prd.PERIOD_ID

                      ,COALESCE(prd.ADJUSTMENT_PERIOD_FLAG, 'N') ADJUSTMENT_PERIOD_FLAG

                      ,COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) GL_PERIOD_YEAR

                      ,COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) GL_PERIOD_NUM

                      ,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') GL_PERIOD_NAME

                      ,COALESCE(prd.PERIOD_CODE, CAST(COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) AS VARCHAR(38)),'0') GL_PERIOD_CODE

                      ,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) GL_EFFECTIVE_PERIOD_NUM

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET

                      ,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE

                      ,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) IMP_ENTITY_ID

                      ,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0')||' ('||pp.PERIODDESC||')' IMP_ENTITY_NAME

                      ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

                      ,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) TRANS_ENTITY_ID

                      ,pp.PERIODDESC TRANS_ENTITY_NAME

                      ,'N' PRIOR_PERIOD_FLAG

                      ,0 SOURCE_LEDGER_ID

                      FROM (

                      AIF_BAL_RULE_LOADS brl

                      INNER JOIN TPOVCATEGORY pc

                      ON pc.CATKEY = brl.CATKEY

                      

                      INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                      ON pp.PERIODFREQ = pc.CATFREQ

                      AND pp.PERIODKEY >= brl.START_PERIODKEY

                      AND pp.PERIODKEY <= brl.END_PERIODKEY

                      AND pp.INTSYSTEMKEY = 'CONSOL'

                      )

                      INNER JOIN TPOVPERIODSOURCE ppsrc

                      ON ppsrc.PERIODKEY = pp.PERIODKEY

                      AND ppsrc.MAPPING_TYPE = 'EXPLICIT'

                      AND ppsrc.SOURCE_SYSTEM_ID = 4

                      AND ppsrc.CALENDAR_ID IN ('GL')

                      LEFT OUTER JOIN AIF_GL_PERIODS_STG prd

                      ON prd.PERIOD_ID = ppsrc.PERIOD_ID

                      AND prd.SOURCE_SYSTEM_ID = ppsrc.SOURCE_SYSTEM_ID

                      AND prd.CALENDAR_ID = ppsrc.CALENDAR_ID

                      

                      AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'

                      WHERE brl.LOADID = 2626

                      ORDER BY pp.PERIODKEY

                      ,GL_EFFECTIVE_PERIOD_NUM

                      

                    2015-06-12 11:41:52,692 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 0L, u'CONSOL', u'EXPLICIT', 4L, u'GL', 'N', 2626]

                    2015-06-12 11:41:52,700 DEBUG [AIF]: CommData.insertPeriods - END

                    2015-06-12 11:41:52,703 DEBUG [AIF]: CommData.getPovList - START

                    2015-06-12 11:41:52,703 DEBUG [AIF]:

                      SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

                      ,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

                      ,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

                      FROM AIF_BAL_RULE_LOADS brl

                      INNER JOIN AIF_BALANCE_RULES br

                      ON br.RULE_ID = brl.RULE_ID

                      INNER JOIN TPOVPARTITION part

                      ON part.PARTITIONKEY = brl.PARTITIONKEY

                      INNER JOIN TPOVCATEGORY cat

                      ON cat.CATKEY = brl.CATKEY

                      INNER JOIN AIF_PROCESS_PERIODS pprd

                      ON pprd.PROCESS_ID = brl.LOADID

                      

                      LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                      ON pp.PERIODKEY = pprd.PERIODKEY

                      AND pp.INTSYSTEMKEY = 'CONSOL'

                      LEFT OUTER JOIN TLOGPROCESS tlp

                      ON tlp.PARTITIONKEY = brl.PARTITIONKEY

                      AND tlp.CATKEY = brl.CATKEY

                      AND tlp.PERIODKEY = pprd.PERIODKEY

                      AND tlp.RULE_ID = brl.RULE_ID

                      WHERE brl.LOADID = 2626

                      ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

                      

                    2015-06-12 11:41:52,708 DEBUG [AIF]: CommData.getPovList - END

                    2015-06-12 11:41:52,710 DEBUG [AIF]: CommData.insertImportProcessDetails - START

                    2015-06-12 11:41:52,711 DEBUG [AIF]:

                      INSERT INTO AIF_PROCESS_DETAILS (

                      PROCESS_ID

                      ,ENTITY_TYPE

                      ,ENTITY_ID

                      ,ENTITY_NAME

                      ,ENTITY_NAME_ORDER

                      ,TARGET_TABLE_NAME

                      ,EXECUTION_START_TIME

                      ,EXECUTION_END_TIME

                      ,RECORDS_PROCESSED

                      ,STATUS

                      ,LAST_UPDATED_BY

                      ,LAST_UPDATE_DATE

                      )

                      SELECT PROCESS_ID

                      ,ENTITY_TYPE

                      ,ENTITY_ID

                      ,ENTITY_NAME

                      ,ENTITY_NAME_ORDER

                      ,'TDATASEG' TARGET_TABLE_NAME

                      ,CURRENT_TIMESTAMP EXECUTION_START_TIME

                      ,NULL EXECUTION_END_TIME

                      ,0 RECORDS_PROCESSED

                      ,'PENDING' STATUS

                      ,'custadmin' LAST_UPDATED_BY

                      ,CURRENT_TIMESTAMP LAST_UPDATE_DATE

                      FROM (

                      SELECT DISTINCT PROCESS_ID

                      ,IMP_ENTITY_TYPE ENTITY_TYPE

                      ,IMP_ENTITY_ID ENTITY_ID

                      ,IMP_ENTITY_NAME ENTITY_NAME

                      ,(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

                      FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID = 2626

                      ) q

                      ORDER BY ENTITY_NAME_ORDER

                      

                    2015-06-12 11:41:52,715 DEBUG [AIF]: CommData.insertImportProcessDetails - END

                    2015-06-12 11:41:52,723 DEBUG [AIF]: Comm.doScriptInit - START

                    2015-06-12 11:41:52,883 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\damhc7\hyperion\user_projects\epmsystem_vmhodamhcp1\FinancialDataQuality, INBOXDIR=\\Vmhodamhcp1\fdmee\inbox, LOCNAME=PSHFM, SOURCENAME=PeopleSoft_OIA, APPID=2, SOURCEID=4, APPROOTDIR=\\Vmhodamhcp1\fdmee, IMPORTFORMAT=PSHFM, SCRIPTSDIR=\\Vmhodamhcp1\fdmee\data\scripts, EPMORACLEHOME=D:\damhc7\Hyperion\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=38, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\damhc7\hyperion\user_projects\epmsystem_vmhodamhcp1, LOADID=2626, PERIODNAME=Jan-2015, IMPORTMODE=null, SOURCETYPE=OTHERS, PERIODKEY=2015-01-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=CONSOL, LOCKEY=16, RULENAME=PeopleSoft_Actuals_All1, OUTBOXDIR=\\Vmhodamhcp1\fdmee\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=1, USERNAME=custadmin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=null}

                    2015-06-12 11:41:52,883 DEBUG [AIF]: The EpmOracleHome is set to: D:\damhc7\Hyperion\EPMSystem11R1

                    2015-06-12 11:41:52,884 DEBUG [AIF]: The EpmOracleInstance is set to: D:\damhc7\hyperion\user_projects\epmsystem_vmhodamhcp1

                    2015-06-12 11:41:52,884 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

                    2015-06-12 11:41:52,884 DEBUG [AIF]: The executeEventScript is set to: YES

                    2015-06-12 11:41:52,884 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

                    2015-06-12 11:41:52,885 DEBUG [AIF]: The AppRootFolder is set to: \\Vmhodamhcp1\fdmee

                    2015-06-12 11:41:52,885 DEBUG [AIF]: Comm.doScriptInit - END

                    2015-06-12 11:41:52,885 DEBUG [AIF]: Comm.executeScript - START

                    2015-06-12 11:41:52,886 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee/data/scripts/event/BefImport.py

                    2015-06-12 11:41:52,889 DEBUG [AIF]: Comm.executeVBScript - START

                    2015-06-12 11:41:52,889 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

                    2015-06-12 11:41:52,890 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee\data\scripts\event\BefImport.vbs

                    2015-06-12 11:41:52,890 DEBUG [AIF]: Comm.executeVBScript - END

                    2015-06-12 11:41:52,890 DEBUG [AIF]: Comm.executeScript - END

                    2015-06-12 11:41:52,891 DEBUG [AIF]: CommData.preImportData - END

                    2015-06-12 11:41:57,950 DEBUG [AIF]:

                    ERP GL Balances Print Variables

                    ===============================

                    p_sql_db_type: ORACLE

                    p_adp_project_code: PSCUST_OIA

                    p_adp_scenario_name: PSHFM

                    p_prd_entity_name: 1 (Jan-2015)

                    p_prd_periodkey: 2015-01-31 00:00:00

                     

                    2015-06-12 11:47:02,925 DEBUG [AIF]: Comm.updateProcessDetail - START

                    2015-06-12 11:47:02,929 DEBUG [AIF]:

                      UPDATE AIF_PROCESS_DETAILS

                      SET STATUS = 'SUCCESS'

                      ,RECORDS_PROCESSED = CASE

                      WHEN RECORDS_PROCESSED IS NULL THEN 0

                      ELSE RECORDS_PROCESSED

                      END + 0

                      ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

                      ,LAST_UPDATED_BY = CASE

                      WHEN ('custadmin' IS NULL) THEN LAST_UPDATED_BY

                      ELSE 'custadmin'

                      END

                      ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                      WHERE PROCESS_ID = 2626

                      AND ENTITY_TYPE = 'PROCESS_BAL_IMP'

                      AND ENTITY_NAME = '1 (Jan-2015)'

                      

                    2015-06-12 11:47:02,962 DEBUG [AIF]: Comm.updateProcessDetail - END

                    2015-06-12 11:47:03,125 DEBUG [AIF]: CommData.postImportData - START

                    2015-06-12 11:47:03,130 DEBUG [AIF]: CommData.getRuleInfo - START

                    2015-06-12 11:47:03,130 DEBUG [AIF]:

                      SELECT brl.RULE_ID

                      ,br.RULE_NAME

                      ,brl.PARTITIONKEY

                      ,brl.CATKEY

                      ,part.PARTVALGROUP

                      ,br.SOURCE_SYSTEM_ID

                      ,ss.SOURCE_SYSTEM_TYPE

                      ,CASE

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FILE%' THEN 'N'

                      ELSE 'Y'

                      END SOURCE_ADAPTER_FLAG

                      ,app.APPLICATION_ID

                      ,app.TARGET_APPLICATION_NAME

                      ,app.TARGET_APPLICATION_TYPE

                      ,app.DATA_LOAD_METHOD

                      ,brl.PLAN_TYPE

                      ,CASE brl.PLAN_TYPE

                      WHEN 'PLAN1' THEN 1

                      WHEN 'PLAN2' THEN 2

                      WHEN 'PLAN3' THEN 3

                      WHEN 'PLAN4' THEN 4

                      WHEN 'PLAN5' THEN 5

                      ELSE 0

                      END PLAN_NUMBER

                      ,br.INCL_ZERO_BALANCE_FLAG

                      ,br.PERIOD_MAPPING_TYPE

                      ,br.INCLUDE_ADJ_PERIODS_FLAG

                      ,br.BALANCE_TYPE ACTUAL_FLAG

                      ,br.AMOUNT_TYPE

                      ,br.BALANCE_SELECTION

                      ,br.BALANCE_METHOD_CODE

                      ,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

                      ,br.CURRENCY_CODE

                      ,br.BAL_SEG_VALUE_OPTION_CODE

                      ,brl.EXECUTION_MODE

                      ,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

                      ,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

                      ,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

                      ,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

                      ,CASE

                      WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

                      WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

                      ELSE 'NONE'

                      END LEDGER_GROUP_CODE

                      ,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

                      ,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

                      ,br.LEDGER_GROUP

                      ,(SELECT brd.DETAIL_CODE

                      FROM AIF_BAL_RULE_DETAILS brd

                      WHERE brd.RULE_ID = br.RULE_ID

                      AND brd.DETAIL_TYPE = 'LEDGER' 

                      ) PS_LEDGER

                      ,CASE lg.LEDGER_TEMPLATE

                      WHEN 'COMMITMENT' THEN 'Y'

                      ELSE 'N'

                      END KK_FLAG

                      ,p.LAST_UPDATED_BY

                      ,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL

                      ,p.EPM_ORACLE_INSTANCE

                      ,brl.JOURNAL_FLAG

                      ,br.MULTI_PERIOD_FILE_FLAG

                      ,br.IMPGROUPKEY

                      FROM AIF_PROCESSES p

                      INNER JOIN AIF_BAL_RULE_LOADS brl

                      ON brl.LOADID = p.PROCESS_ID

                      INNER JOIN AIF_BALANCE_RULES br

                      ON br.RULE_ID = brl.RULE_ID

                      INNER JOIN AIF_SOURCE_SYSTEMS ss

                      ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                      INNER JOIN AIF_TARGET_APPLICATIONS app

                      ON app.APPLICATION_ID = brl.APPLICATION_ID

                      INNER JOIN TPOVPARTITION part

                      ON part.PARTITIONKEY = br.PARTITIONKEY

                      INNER JOIN TBHVIMPGROUP imp

                      ON imp.IMPGROUPKEY = part.PARTIMPGROUP

                      LEFT OUTER JOIN AIF_COA_LEDGERS l

                      ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

                      AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

                      LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

                      ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

                      AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

                      AND scr.RECNAME = 'LED_GRP_TBL'

                      LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

                      ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

                      AND lg.SETID = scr.SETID

                      AND lg.LEDGER_GROUP = br.LEDGER_GROUP

                      WHERE p.PROCESS_ID = 2626

                      

                    2015-06-12 11:47:03,136 DEBUG [AIF]:

                      SELECT adim.BALANCE_COLUMN_NAME DIMNAME

                      ,adim.DIMENSION_ID

                      ,dim.TARGET_DIMENSION_CLASS_NAME

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

                      ,(SELECT CASE mdd.ORPHAN_OPTION_CODE

                      WHEN 'CHILD' THEN 'N'

                      WHEN 'ROOT' THEN 'N'

                      ELSE 'Y'

                      END DIMENSION_FILTER_FLAG

                      FROM AIF_MAP_DIM_DETAILS_V mdd

                      ,AIF_MAPPING_RULES mr

                      WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

                      AND mdd.RULE_ID = mr.RULE_ID

                      AND mdd.DIMENSION_ID = adim.DIMENSION_ID

                      ) DIMENSION_FILTER_FLAG

                      ,tiie.IMPCONCATCHAR

                      FROM TPOVPARTITION tpp

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                      ON adim.APPLICATION_ID = 2

                      INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                      LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                      ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

                      AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

                      AND tiie.IMPMAPTYPE = 'ERP'

                      WHERE tpp.PARTITIONKEY = 16

                      AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                      AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                      

                      ORDER BY adim.BALANCE_COLUMN_NAME

                      

                    2015-06-12 11:47:03,141 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'PeopleSoft_Actuals_All1', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\damhc7\\hyperion\\user_projects\\epmsystem_vmhodamhcp1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'CONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 4L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'custadmin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 6L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 8L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 3L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 1L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 4L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 16L, 'PARTVALGROUP': u'CheckRulePS', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 38L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://vmhodamhcp1.oracleoutsourcing.com:5064/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

                    2015-06-12 11:47:03,141 DEBUG [AIF]: CommData.getRuleInfo - END

                    2015-06-12 11:47:03,147 DEBUG [AIF]: CommData.updateTDATASEG_T - START

                    2015-06-12 11:47:03,149 DEBUG [AIF]: CommData.getLedgerListAndMap - START

                    2015-06-12 11:47:03,150 DEBUG [AIF]: CommData.getLedgerSQL - START

                    2015-06-12 11:47:03,151 DEBUG [AIF]: CommData.getLedgerSQL - END

                    2015-06-12 11:47:03,151 DEBUG [AIF]:

                      SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID

                      ,NULL SOURCE_LEDGER_NAME

                      ,NULL SOURCE_COA_ID

                      ,br.CALENDAR_ID

                      ,NULL SETID

                      ,NULL PERIOD_TYPE

                      ,NULL LEDGER_TABLE_NAME

                      FROM AIF_BALANCE_RULES br

                      WHERE br.RULE_ID = 38

                      

                    2015-06-12 11:47:03,152 DEBUG [AIF]: CommData.getLedgerListAndMap - END

                    2015-06-12 11:47:03,155 DEBUG [AIF]: CommData.getPovList - START

                    2015-06-12 11:47:03,158 DEBUG [AIF]: commAppPeriodMappingExists: Y

                    2015-06-12 11:47:03,158 DEBUG [AIF]:

                      SELECT DISTINCT brl.PARTITIONKEY

                      ,part.PARTNAME

                      ,brl.CATKEY

                      ,cat.CATNAME

                      ,pprd.PERIODKEY

                      ,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

                      ,brl.RULE_ID

                      ,br.RULE_NAME

                      ,CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

                      FROM AIF_BAL_RULE_LOADS brl

                      INNER JOIN AIF_BALANCE_RULES br

                      ON br.RULE_ID = brl.RULE_ID

                      INNER JOIN TPOVPARTITION part

                      ON part.PARTITIONKEY = brl.PARTITIONKEY

                      INNER JOIN TPOVCATEGORY cat

                      ON cat.CATKEY = brl.CATKEY

                      INNER JOIN AIF_PROCESS_PERIODS pprd

                      ON pprd.PROCESS_ID = brl.LOADID

                      

                      LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                      ON pp.PERIODKEY = pprd.PERIODKEY

                      AND pp.INTSYSTEMKEY = 'CONSOL'

                      LEFT OUTER JOIN TLOGPROCESS tlp

                      ON tlp.PARTITIONKEY = brl.PARTITIONKEY

                      AND tlp.CATKEY = brl.CATKEY

                      AND tlp.PERIODKEY = pprd.PERIODKEY

                      AND tlp.RULE_ID = brl.RULE_ID

                      WHERE brl.LOADID = 2626

                      ORDER BY brl.PARTITIONKEY

                      ,brl.CATKEY

                      ,pprd.PERIODKEY

                      ,brl.RULE_ID

                      

                    2015-06-12 11:47:03,160 DEBUG [AIF]: CommData.getPovList - END

                    2015-06-12 11:47:03,161 INFO [AIF]:

                    Import Data from Source for Period 'Jan-2015'

                    2015-06-12 11:47:03,167 DEBUG [AIF]: CommData.updateWorkflow - START

                    2015-06-12 11:47:03,167 DEBUG [AIF]:

                      SELECT tlp.PROCESSSTATUS

                      ,tlps.PROCESSSTATUSDESC

                      ,CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

                      FROM TLOGPROCESS tlp

                      ,TLOGPROCESSSTATES tlps

                      WHERE tlp.PARTITIONKEY = 16

                      AND tlp.CATKEY = 1

                      AND tlp.PERIODKEY = '2015-01-31'

                      AND tlp.RULE_ID = 38

                      AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

                      

                    2015-06-12 11:47:03,169 DEBUG [AIF]:

                      UPDATE TLOGPROCESS

                      SET PROCESSENDTIME = CURRENT_TIMESTAMP

                      

                      ,PROCESSSTATUS = 0

                      ,PROCESSIMP = 0

                      ,PROCESSVAL = 0

                      ,PROCESSEXP = 0

                      ,PROCESSENTLOAD = 0

                      ,PROCESSENTVAL = 0

                      ,BLNWCDIRTY = 0

                      ,BLNLOGICDIRTY = 0

                      ,BLNVALDIRTY = 0

                      ,PROCESSIMPNOTE = NULL

                      ,PROCESSVALNOTE = NULL

                      ,PROCESSEXPNOTE = NULL

                      ,PROCESSENTLOADNOTE = NULL

                      ,PROCESSENTVALNOTE = NULL

                      WHERE PARTITIONKEY = 16

                      AND CATKEY = 1

                      AND PERIODKEY = '2015-01-31'

                      AND RULE_ID = 38

                      

                    2015-06-12 11:47:03,173 DEBUG [AIF]: CommData.updateWorkflow - END

                    2015-06-12 11:47:03,173 DEBUG [AIF]:

                      SELECT adim.BALANCE_COLUMN_NAME DIMNAME

                      ,dim.TARGET_DIMENSION_CLASS_NAME

                      FROM TPOVPARTITION tpp

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                      ON adim.APPLICATION_ID = tpp.PARTTARGETAPPLICATIONID

                      AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                      

                      INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                      WHERE tpp.PARTITIONKEY = 16

                      AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                      ORDER BY adim.BALANCE_COLUMN_NAME

                      

                    2015-06-12 11:47:03,175 DEBUG [AIF]: 

                      UPDATE TDATASEG_T

                      

                      SET AMOUNTX = AMOUNT

                      

                      ,ACCOUNTX = NULL

                      ,ENTITYX = NULL

                      ,ICPX = NULL

                      ,UD1X = NULL

                      ,UD2X = NULL

                      ,UD3X = NULL

                      ,UD4X = NULL

                      WHERE TDATASEG_T.LOADID = 2626

                      AND TDATASEG_T.PARTITIONKEY = 16

                      AND TDATASEG_T.CATKEY = 1

                      AND TDATASEG_T.PERIODKEY = '2015-01-31'

                      

                    2015-06-12 11:47:03,956 INFO [AIF]: Generic Data Rows Imported from Source: 20536

                    2015-06-12 11:47:03,956 DEBUG [AIF]: 

                      INSERT INTO AIF_APPL_LOAD_AUDIT (

                      LOADID

                      ,TARGET_APPLICATION_TYPE

                      ,TARGET_APPLICATION_NAME

                      ,PLAN_TYPE

                      ,SOURCE_LEDGER_ID

                      ,EPM_YEAR

                      ,EPM_PERIOD

                      ,SNAPSHOT_FLAG

                      ,PARTITIONKEY

                      ,CATKEY

                      ,RULE_ID

                      ,PERIODKEY

                      ,EXPORT_TO_TARGET_FLAG

                      )

                      SELECT DISTINCT PROCESS_ID LOADID

                      ,'HFM' TARGET_APPLICATION_TYPE

                      ,'CONSOL' TARGET_APPLICATION_NAME

                      ,NULL PLAN_TYPE

                      ,0 SOURCE_LEDGER_ID

                      ,YEARTARGET EPM_YEAR

                      ,PERIODTARGET EPM_PERIOD

                      ,'Y' SNAPSHOT_FLAG

                      ,16 PARTITIONKEY

                      ,1 CATKEY

                      ,38 RULE_ID

                      ,PERIODKEY

                      ,'N' EXPORT_TO_TARGET_FLAG

                      FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID = 2626

                      AND PERIODKEY = '2015-01-31'

                      

                    2015-06-12 11:47:03,972 INFO [AIF]: Total Data Rows Imported from Source: 20536

                    2015-06-12 11:47:03,972 DEBUG [AIF]: CommData.updateTDATASEG_T - END

                    2015-06-12 11:47:03,980 DEBUG [AIF]: Comm.doScriptInit - START

                    2015-06-12 11:47:04,125 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\damhc7\hyperion\user_projects\epmsystem_vmhodamhcp1\FinancialDataQuality, INBOXDIR=\\Vmhodamhcp1\fdmee\inbox, LOCNAME=PSHFM, SOURCENAME=PeopleSoft_OIA, APPID=2, SOURCEID=4, APPROOTDIR=\\Vmhodamhcp1\fdmee, IMPORTFORMAT=PSHFM, SCRIPTSDIR=\\Vmhodamhcp1\fdmee\data\scripts, EPMORACLEHOME=D:\damhc7\Hyperion\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=38, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\damhc7\hyperion\user_projects\epmsystem_vmhodamhcp1, LOADID=2626, PERIODNAME=Jan-2015, IMPORTMODE=null, SOURCETYPE=OTHERS, PERIODKEY=2015-01-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=CONSOL, LOCKEY=16, RULENAME=PeopleSoft_Actuals_All1, OUTBOXDIR=\\Vmhodamhcp1\fdmee\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=1, USERNAME=custadmin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=null}

                    2015-06-12 11:47:04,125 DEBUG [AIF]: The EpmOracleHome is set to: D:\damhc7\Hyperion\EPMSystem11R1

                    2015-06-12 11:47:04,126 DEBUG [AIF]: The EpmOracleInstance is set to: D:\damhc7\hyperion\user_projects\epmsystem_vmhodamhcp1

                    2015-06-12 11:47:04,126 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

                    2015-06-12 11:47:04,126 DEBUG [AIF]: The executeEventScript is set to: YES

                    2015-06-12 11:47:04,126 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

                    2015-06-12 11:47:04,126 DEBUG [AIF]: The AppRootFolder is set to: \\Vmhodamhcp1\fdmee

                    2015-06-12 11:47:04,127 DEBUG [AIF]: Comm.doScriptInit - END

                    2015-06-12 11:47:04,127 DEBUG [AIF]: Comm.executeScript - START

                    2015-06-12 11:47:04,140 INFO [AIF]: Executing the following script: \\Vmhodamhcp1\fdmee/data/scripts/event/AftImport.py

                    2015-06-12 11:47:04,145 DEBUG [AIF]: Comm.executeVBScript - START

                    2015-06-12 11:47:04,146 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

                    2015-06-12 11:47:04,146 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee\data\scripts\event\AftImport.vbs

                    2015-06-12 11:47:04,147 DEBUG [AIF]: Comm.executeVBScript - END

                    2015-06-12 11:47:04,147 DEBUG [AIF]: Comm.executeScript - END

                    2015-06-12 11:47:04,147 DEBUG [AIF]: CommData.postImportData - END

                    2015-06-12 11:47:04,500 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

                    2015-06-12 11:47:04,501 DEBUG [AIF]: Comm.executeScript - START

                    2015-06-12 11:47:04,502 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee/data/scripts/event/BefProcLogicGrp.py

                    2015-06-12 11:47:04,502 DEBUG [AIF]: Comm.executeVBScript - START

                    2015-06-12 11:47:04,503 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee\data\scripts\event\BefProcLogicGrp.vbs

                    2015-06-12 11:47:04,503 DEBUG [AIF]: Comm.executeVBScript - END

                    2015-06-12 11:47:04,503 DEBUG [AIF]: Comm.executeScript - END

                    2015-06-12 11:47:04,505 DEBUG [AIF]: CommData.getRuleInfo - START

                    2015-06-12 11:47:04,505 DEBUG [AIF]: CommData.getRuleInfo - START

                    2015-06-12 11:47:04,506 DEBUG [AIF]:

                      SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

                      ,CASE

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N' 

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N' 

                      WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'

                      ELSE 'Y'

                      END SOURCE_ADAPTER_FLAG

                      ,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE

                      ,CASE brl.PLAN_TYPE

                      WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 ELSE 0

                      END PLAN_NUMBER

                      ,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG

                      ,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE

                      ,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

                      ,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE

                      ,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

                      ,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

                      ,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

                      ,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

                      ,CASE

                      WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'

                      WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

                      WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

                      ELSE 'NONE'

                      END LEDGER_GROUP_CODE

                      ,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

                      ,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

                      ,br.LEDGER_GROUP

                      ,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER

                      ,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG

                      ,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE

                      ,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID

                      ,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID

                      FROM AIF_PROCESSES p

                      INNER JOIN AIF_BAL_RULE_LOADS brl

                      ON brl.LOADID = p.PROCESS_ID

                      INNER JOIN AIF_BALANCE_RULES br

                      ON br.RULE_ID = brl.RULE_ID

                      INNER JOIN AIF_SOURCE_SYSTEMS ss

                      ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                      INNER JOIN AIF_TARGET_APPLICATIONS app

                      ON app.APPLICATION_ID = brl.APPLICATION_ID

                      INNER JOIN TPOVPARTITION part

                      ON part.PARTITIONKEY = br.PARTITIONKEY

                      INNER JOIN TBHVIMPGROUP imp

                      ON imp.IMPGROUPKEY = part.PARTIMPGROUP

                      LEFT OUTER JOIN AIF_COA_LEDGERS l

                      ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

                      AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

                      LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

                      ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

                      AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

                      AND scr.RECNAME = 'LED_GRP_TBL'

                      LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

                      ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

                      AND lg.SETID = scr.SETID

                      AND lg.LEDGER_GROUP = br.LEDGER_GROUP

                      WHERE p.PROCESS_ID = 2626

                      

                    2015-06-12 11:47:04,512 DEBUG [AIF]:

                      SELECT adim.BALANCE_COLUMN_NAME DIMNAME

                      ,adim.DIMENSION_ID

                      ,dim.TARGET_DIMENSION_CLASS_NAME

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

                      ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

                      ,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE

                      WHEN 'CHILD' THEN 'N'

                      WHEN 'ROOT' THEN 'N'

                      ELSE 'Y'

                      END DIMENSION_FILTER_FLAG

                      FROM AIF_MAP_DIM_DETAILS_V mdd

                      ,AIF_MAPPING_RULES mr

                      WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

                      AND mdd.RULE_ID = mr.RULE_ID

                      AND mdd.DIMENSION_ID = adim.DIMENSION_ID

                      ) DIMENSION_FILTER_FLAG

                      ,tiie.IMPCONCATCHAR

                      FROM TPOVPARTITION tpp

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                      ON adim.APPLICATION_ID = 2

                      INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                      LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                      ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

                      AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

                      AND tiie.IMPMAPTYPE = 'ERP'

                      WHERE tpp.PARTITIONKEY = 16

                      AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                      AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                      

                      ORDER BY adim.BALANCE_COLUMN_NAME

                      

                    2015-06-12 11:47:04,558 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'PeopleSoft_Actuals_All1', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\damhc7\\hyperion\\user_projects\\epmsystem_vmhodamhcp1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'CONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 4L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'custadmin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 6L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 8L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 3L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 7L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 1L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 4L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 16L, 'PARTVALGROUP': u'CheckRulePS', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 38L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://vmhodamhcp1.oracleoutsourcing.com:5064/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}

                    2015-06-12 11:47:04,558 DEBUG [AIF]: CommData.getRuleInfo - END

                    2015-06-12 11:47:04,558 DEBUG [AIF]:

                      select part.PARTLOGICGROUP

                      ,lgrp.CALCGROUPTYPE

                      from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

                      where prs.PROCESS_ID=2626 and prs.PARTITIONKEY=part.PARTITIONKEY

                      and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

                      

                    2015-06-12 11:47:04,559 DEBUG [AIF]: CommData.getRuleInfo - END

                    2015-06-12 11:47:04,560 DEBUG [AIF]: Comm.executeScript - START

                    2015-06-12 11:47:04,561 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee/data/scripts/event/AftProcLogicGrp.py

                    2015-06-12 11:47:04,561 DEBUG [AIF]: Comm.executeVBScript - START

                    2015-06-12 11:47:04,562 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee\data\scripts\event\AftProcLogicGrp.vbs

                    2015-06-12 11:47:04,562 DEBUG [AIF]: Comm.executeVBScript - END

                    2015-06-12 11:47:04,562 DEBUG [AIF]: Comm.executeScript - END

                    2015-06-12 11:47:04,562 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

                    2015-06-12 11:47:04,610 DEBUG [AIF]: CommData.mapData - START

                    2015-06-12 11:47:04,611 DEBUG [AIF]: Comm.executeScript - START

                    2015-06-12 11:47:04,611 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee/data/scripts/event/BefProcMap.py

                    2015-06-12 11:47:04,612 DEBUG [AIF]: Comm.executeVBScript - START

                    2015-06-12 11:47:04,612 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee\data\scripts\event\BefProcMap.vbs

                    2015-06-12 11:47:04,613 DEBUG [AIF]: Comm.executeVBScript - END

                    2015-06-12 11:47:04,613 DEBUG [AIF]: Comm.executeScript - END

                    2015-06-12 11:47:04,614 DEBUG [AIF]: CommData.insertTransProcessDetails - START

                    2015-06-12 11:47:04,615 DEBUG [AIF]:

                      INSERT INTO AIF_PROCESS_DETAILS (

                      PROCESS_ID

                      ,ENTITY_TYPE

                      ,ENTITY_ID

                      ,ENTITY_NAME

                      ,ENTITY_NAME_ORDER

                      ,TARGET_TABLE_NAME

                      ,EXECUTION_START_TIME

                      ,EXECUTION_END_TIME

                      ,RECORDS_PROCESSED

                      ,STATUS

                      ,LAST_UPDATED_BY

                      ,LAST_UPDATE_DATE

                      )

                      SELECT PROCESS_ID

                      ,ENTITY_TYPE

                      ,ENTITY_ID

                      ,ENTITY_NAME

                      ,ENTITY_NAME_ORDER

                      ,'TDATASEG' TARGET_TABLE_NAME

                      ,CURRENT_TIMESTAMP EXECUTION_START_TIME

                      ,NULL EXECUTION_END_TIME

                      ,0 RECORDS_PROCESSED

                      ,'PENDING' STATUS

                      ,'custadmin' LAST_UPDATED_BY

                      ,CURRENT_TIMESTAMP LAST_UPDATE_DATE

                      FROM (

                      SELECT PROCESS_ID

                      ,TRANS_ENTITY_TYPE ENTITY_TYPE

                      ,MIN(TRANS_ENTITY_ID) ENTITY_ID

                      ,TRANS_ENTITY_NAME ENTITY_NAME

                      ,MIN(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

                      FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID = 2626

                      AND PRIOR_PERIOD_FLAG = 'N'

                      GROUP BY PROCESS_ID

                      ,TRANS_ENTITY_TYPE

                      ,TRANS_ENTITY_NAME

                      ) q

                      ORDER BY ENTITY_NAME_ORDER

                      

                    2015-06-12 11:47:04,623 DEBUG [AIF]: CommData.insertTransProcessDetails - END

                    2015-06-12 11:47:04,626 DEBUG [AIF]:

                      DELETE FROM TDATAMAP_T

                      WHERE LOADID < 2626

                      AND EXISTS (

                      SELECT 1

                      FROM AIF_PROCESSES p

                      WHERE p.RULE_ID = 38

                      AND p.PROCESS_ID = TDATAMAP_T.LOADID

                      )

                      

                    2015-06-12 11:47:04,754 DEBUG [AIF]:

                      DELETE FROM TDATASEG_T

                      WHERE LOADID < 2626

                      AND EXISTS (

                      SELECT 1

                      FROM AIF_PROCESSES p

                      WHERE p.RULE_ID = 38

                      AND p.PROCESS_ID = TDATASEG_T.LOADID

                      )

                      

                    2015-06-12 11:47:05,534 DEBUG [AIF]:

                      DELETE FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID < 2626

                      AND EXISTS (

                      SELECT 1

                      FROM AIF_PROCESSES p

                      WHERE p.RULE_ID = 38

                      AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID

                      )

                      

                    2015-06-12 11:47:05,541 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

                    2015-06-12 11:47:05,543 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

                    2015-06-12 11:47:05,543 DEBUG [AIF]:

                      SELECT COALESCE(part_parent.PARTITIONKEY, part.PARTITIONKEY) PARTITIONKEY

                      ,COALESCE(part_parent.PARTNAME, part.PARTNAME) PARTNAME

                      FROM TPOVPARTITION part

                      LEFT OUTER JOIN TPOVPARTITION part_parent

                      ON part_parent.PARTITIONKEY = part.PARTPARENTKEY

                      WHERE part.PARTITIONKEY = 16

                      

                    2015-06-12 11:47:05,544 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

                    2015-06-12 11:47:05,545 DEBUG [AIF]:

                      INSERT INTO TDATAMAP_T (

                      LOADID

                      ,DATAKEY

                      ,PARTITIONKEY

                      ,DIMNAME

                      ,SRCKEY

                      ,SRCDESC

                      ,TARGKEY

                      ,WHERECLAUSETYPE

                      ,WHERECLAUSEVALUE

                      ,CHANGESIGN

                      ,SEQUENCE

                      ,VBSCRIPT

                      ,TDATAMAPTYPE

                      ,SYSTEM_GENERATED_FLAG

                      ,RULE_ID

                      )

                      SELECT 2626

                      ,DATAKEY

                      ,16 PARTITIONKEY

                      ,DIMNAME

                      ,SRCKEY

                      ,SRCDESC

                      ,CASE WHEN (TDATAMAPTYPE = 'EPM' AND TARGKEY = '<BLANK>') THEN ' ' ELSE TARGKEY END

                      ,WHERECLAUSETYPE

                      ,CASE WHEN (TDATAMAPTYPE = 'EPM' AND WHERECLAUSEVALUE = '<BLANK>') THEN ' ' ELSE WHERECLAUSEVALUE END 

                      ,CHANGESIGN

                      ,SEQUENCE

                      ,VBSCRIPT

                      ,TDATAMAPTYPE

                      ,SYSTEM_GENERATED_FLAG

                      ,RULE_ID

                      FROM TDATAMAP tdm

                      WHERE PARTITIONKEY = 16

                      AND (RULE_ID IS NULL OR RULE_ID = 38)

                      AND (

                      TDATAMAPTYPE = 'ERP'

                      OR (

                      TDATAMAPTYPE = 'MULTIDIM'

                      AND EXISTS (

                      SELECT 1

                      FROM TDATAMAP multidim

                      WHERE multidim.PARTITIONKEY = tdm.PARTITIONKEY

                      AND multidim.TDATAMAPTYPE = 'ERP'

                      AND multidim.DATAKEY = tdm.TARGKEY

                      )

                      )

                      )

                      

                    2015-06-12 11:47:05,651 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 826

                    2015-06-12 11:47:05,671 DEBUG [AIF]: CommData.targetMemberFilter - START

                    2015-06-12 11:47:05,673 DEBUG [AIF]:

                      DELETE FROM AIF_TARGET_APPL_DIM_MEMS

                      WHERE APPLICATION_ID = 2

                      AND CREATED_BY_RULE_ID = 38 

                      

                    2015-06-12 11:47:05,694 DEBUG [AIF]:

                      INSERT INTO AIF_TARGET_APPL_DIM_MEMS (

                      APPLICATION_ID, DIMENSION_ID, MEMBER_NAME, CREATED_BY_RULE_ID

                      ,VALID_FOR_PLAN1, VALID_FOR_PLAN2, VALID_FOR_PLAN3, VALID_FOR_PLAN4, VALID_FOR_PLAN5

                      )

                      SELECT DISTINCT adim.APPLICATION_ID, adim.DIMENSION_ID, tdmt.TARGKEY MEMBER_NAME, 38 CREATED_BY_RULE_ID

                      ,adim.VALID_FOR_PLAN1, adim.VALID_FOR_PLAN2, adim.VALID_FOR_PLAN3, adim.VALID_FOR_PLAN4, adim.VALID_FOR_PLAN5

                      FROM TDATAMAP_T tdmt

                      ,AIF_TARGET_APPL_DIMENSIONS adim

                      ,AIF_DIMENSIONS dim 

                      WHERE tdmt.LOADID = 2626

                      AND (

                      tdmt.WHERECLAUSETYPE IS NULL

                      OR tdmt.WHERECLAUSETYPE = 'BETWEEN'

                      OR (tdmt.WHERECLAUSETYPE = 'LIKE' AND INSTR(tdmt.TARGKEY, '*', 1) = 0)

                      )

                      AND adim.APPLICATION_ID = 2

                      AND adim.BALANCE_COLUMN_NAME = tdmt.DIMNAME

                      AND dim.DIMENSION_ID = adim.DIMENSION_ID

                      

                    2015-06-12 11:47:05,719 DEBUG [AIF]: CommData.targetMemberFilter - END

                    2015-06-12 11:47:05,756 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

                    2015-06-12 11:47:05,756 DEBUG [AIF]:

                      SELECT DIMNAME, SRCKEY, TARGKEY, WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE,

                      DATAKEY, MAPPING_TYPE, CASE WHEN (RULE_ID IS NOT NULL) THEN 'Y' ELSE 'N' END IS_RULE_MAP

                      FROM (

                      SELECT DISTINCT tdm.DIMNAME

                      ,tdm.RULE_ID

                      ,NULL SRCKEY

                      ,NULL TARGKEY

                      ,tdm.WHERECLAUSETYPE

                      ,tdm.WHERECLAUSEVALUE

                      ,NULL CHANGESIGN

                      ,1 SEQUENCE

                      ,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG 

                      ,NULL DATAKEY

                      ,CASE

                      WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1

                      ELSE 3

                      END MAPPING_TYPE

                      ,COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

                      FROM TDATAMAP_T tdm

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

                      WHERE tdm.LOADID = 2626

                      AND atad.APPLICATION_ID = 2

                      AND tdm.PARTITIONKEY = 16

                      AND tdm.TDATAMAPTYPE = 'ERP'

                      AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 38)

                      AND tdm.WHERECLAUSETYPE IS NULL

                      UNION ALL

                      SELECT tdm.DIMNAME

                      ,tdm.RULE_ID

                      ,tdm.SRCKEY

                      ,tdm.TARGKEY

                      ,tdm.WHERECLAUSETYPE

                      ,tdm.WHERECLAUSEVALUE

                      ,tdm.CHANGESIGN

                      ,CASE tpp.PARTSEQMAP

                      WHEN 0 THEN CASE

                      WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2

                      WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3

                      WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4

                      WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5

                      ELSE 0

                      END 

                      ELSE tdm.SEQUENCE

                      END SEQUENCE

                      ,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG

                      ,tdm.DATAKEY

                      ,CASE

                      WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1

                      ELSE 3

                      END MAPPING_TYPE

                      ,COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

                      FROM TDATAMAP_T tdm

                      INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

                      WHERE tdm.LOADID = 2626

                      AND atad.APPLICATION_ID = 2

                      AND tdm.PARTITIONKEY = 16

                      AND tdm.TDATAMAPTYPE = 'ERP'

                      AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 38)

                      AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')

                      ) q

                      ORDER BY CALC_SEQ

                      ,DIMNAME

                      ,SEQUENCE

                      ,RULE_ID

                      ,SYSTEM_GENERATED_FLAG

                      ,SRCKEY

                      

                    2015-06-12 11:47:05,851 DEBUG [AIF]:

                      SELECT VBSCRIPT

                      FROM TDATAMAP_T

                      WHERE LOADID = 2626

                      AND PARTITIONKEY = 16

                      AND DATAKEY = 9244

                      

                    2015-06-12 11:47:05,854 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

                    Traceback (most recent call last):

                      File "<string>", line 1822, in updateTDATASEG_T_TDATASEGW

                    TypeError: cannot concatenate 'unicode' and 'NoneType' objects

                     

                    2015-06-12 11:47:05,855 DEBUG [AIF]: Comm.executeScript - START

                    2015-06-12 11:47:05,856 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee/data/scripts/event/AftProcMap.py

                    2015-06-12 11:47:05,856 DEBUG [AIF]: Comm.executeVBScript - START

                    2015-06-12 11:47:05,857 DEBUG [AIF]: The following script does not exist: \\Vmhodamhcp1\fdmee\data\scripts\event\AftProcMap.vbs

                    2015-06-12 11:47:05,857 DEBUG [AIF]: Comm.executeVBScript - END

                    2015-06-12 11:47:05,858 DEBUG [AIF]: Comm.executeScript - END

                    2015-06-12 11:47:05,979 DEBUG [AIF]: Comm.finalizeProcess - START

                    2015-06-12 11:47:05,981 DEBUG [AIF]: CommData.updateRuleStatus - START

                    2015-06-12 11:47:05,981 DEBUG [AIF]:

                      UPDATE AIF_BALANCE_RULES

                      SET STATUS = CASE 'FAILED'

                      WHEN 'SUCCESS' THEN

                      CASE (

                      SELECT COUNT(*)

                      FROM AIF_PROCESS_DETAILS pd

                      WHERE pd.PROCESS_ID = 2626

                      AND pd.STATUS IN ('FAILED','WARNING')

                      )

                      WHEN 0 THEN 'SUCCESS'

                      ELSE (

                      SELECT MIN(pd.STATUS)

                      FROM AIF_PROCESS_DETAILS pd

                      WHERE pd.PROCESS_ID = 2626

                      AND pd.STATUS IN ('FAILED','WARNING')

                      )

                      END

                      ELSE 'FAILED'

                      END

                      WHERE RULE_ID = 38

                      

                    2015-06-12 11:47:05,986 DEBUG [AIF]: CommData.updateRuleStatus - END

                    2015-06-12 11:47:05,986 FATAL [AIF]: Error in COMM Map Data

                    2015-06-12 11:47:05,987 DEBUG [AIF]: Comm.updateProcess - START

                    2015-06-12 11:47:05,994 DEBUG [AIF]: Comm.updateProcess - END

                    2015-06-12 11:47:06,013 DEBUG [AIF]: The fdmAPI connection has been closed.

                    2015-06-12 11:47:06,014 INFO [AIF]: FDMEE Process End, Process ID: 2626

                    • 7. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                      Francisco Amores

                      so if you have a look to your log you will see where the error is:

                       

                        SELECT VBSCRIPT

                        FROM TDATAMAP_T

                        WHERE LOADID = 2626

                        AND PARTITIONKEY = 16

                        AND DATAKEY = 9244

                       

                      That's the query raising the error. Now time for you to find that mapping and check what is wrong with it.


                      Cheers

                      1 person found this helpful
                      • 8. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                        2698643

                        Thx for the advice.  One question on the DATAKEY.   When I look at all the logs for all the  past successful loads for that location/category, I notice that the DATAKEY is different.  In the successful loads the DATAKEY referenced at that point in the log is not 9244. It is something else.  Don't remember what it is, but it is the same in all the successful loads.  Is the DATAKEY something that should change.  While troubleshooting I noticed there may have been a database upgrade from 11g to 12c.  Still trying to figure out if that has am impact on the error.  Can't say for sure the error started after the database upgrade.

                        • 9. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                          Francisco Amores

                          which data key?

                           

                          in tdataseg or tadatamap?

                           

                          did you fix your issue?

                          • 10. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                            2698643

                            I think it would be in tdatamap.  I guess what I was wondering was when I look at logs of successfully loads I go to the same point in those logs where the error is in the attached log and I see a different DATAKEY.  Just seemed odd that all the successful logs reference one DATAKEY number, but the unsuccessful log references a different (9244).  Unfortunately I do not know enough about DATAKEY to know if that is an issue or not.  I am trying to review mapping to see if I can resolve, but was just curious why the DATAKEY would be different in the logs for successful and unsuccessful loads.

                            • 11. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                              Francisco Amores

                              Datakey in temporary tables will change in every process.

                              You don't need to worry about datakey as this is managed by FDMEE internally

                              • 12. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                                2698643

                                Thx Francisco.  We did resolve the error attached to this post by correcting some mapping issues.  Unfortunately we still cannot load data to FDMEE.  We are getting a different error.  Am going to mark this one as answered.  Thx again for helping.