4 Replies Latest reply on Aug 20, 2015 11:12 AM by Jonathan A Cohen

    FDMEE Cloud Log file unable to understand

    Venkat Chowdary

      Hi,

       

      I am working on cloud environment, for integration from Fusion GL to PBCS(Planning).

       

      For data load option I have created source and target configuration in FDMEE,

       

      Source system I have given as Fusion GL.

       

      And created import format, and data load rule, mappings, but when I run the rule I am getting an error as below,

       

      I am not able to understand what the error is, can anyone help me in this regard.

       

      2015-08-18 09:45:58,976 INFO  [AIF]: FDMEE Process Start, Process ID: 362

      2015-08-18 09:45:58,977 INFO  [AIF]: FDMEE Logging Level: 5

      2015-08-18 09:45:58,977 INFO  [AIF]: User:msiraj@exsab.com.sa

      2015-08-18 09:45:58,977 INFO  [AIF]: Location:GL2PBCS (Partitionkey:67)

      2015-08-18 09:45:58,977 INFO  [AIF]: Period Name:Jul-15 (Period Key:7/31/15 12:00 AM)

      2015-08-18 09:45:58,977 INFO  [AIF]: Category Name:Actual (Category key:4)

      2015-08-18 09:45:58,977 INFO  [AIF]: Rule Name:GL2PBCS (Rule ID:34)

      2015-08-18 09:46:00,592 INFO  [AIF]: FDM Version: 11.1.2.4.000

      2015-08-18 09:46:00,592 INFO  [AIF]: Log File Encoding: UTF-8

      2015-08-18 09:46:01,809 INFO  [AIF]: -------START IMPORT STEP-------

      2015-08-18 09:46:01,875 DEBUG [AIF]: CommData.preImportData - START

      2015-08-18 09:46:01,875 DEBUG [AIF]: CommData.getRuleInfo - START

      2015-08-18 09:46:01,875 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 WHEN 'PLAN6' THEN 6 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 = 362

             

      2015-08-18 09:46:01,878 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 = 13

            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 = 67

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2015-08-18 09:46:01,881 DEBUG [AIF]: {'APPLICATION_ID': 13L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'GL2PBCS', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'/u02/user_projects/instance0', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PBCS', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 27L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'GL2PBCS', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'Y', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'msiraj@exsab.com.sa', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Period', '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'UD6', 'DIMENSION_ID': 32L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', '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': 37L}, 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': 71L}, 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': 70L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Year', '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'UD5', 'DIMENSION_ID': 36L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Scenario', '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': 33L}, 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': 35L}, 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': 34L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 67L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 34L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://em2pbcs006.nldc1.oraclecloud.com:9000/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 13L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2015-08-18 09:46:01,881 DEBUG [AIF]: CommData.getRuleInfo - END

      2015-08-18 09:46:01,882 DEBUG [AIF]: Comm.doScriptInit - START

      2015-08-18 09:46:01,958 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, INBOXDIR=/u03/inbox/inbox, LOCNAME=GL2PBCS, SOURCENAME=GL2PBCS, APPID=13, SOURCEID=27, APPROOTDIR=/u03/inbox, IMPORTFORMAT=GL2PBCS, SCRIPTSDIR=/u03/inbox/data/scripts, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=34, CATNAME=Actual, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, LOADID=362, PERIODNAME=Jul-15, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2015-07-31, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=PBCS, FILENAME=null, LOCKEY=67, RULENAME=GL2PBCS, OUTBOXDIR=/u03/inbox/outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, FILEDIR=Inbox, USERNAME=msiraj@exsab.com.sa, IMPORTFLAG=Y, USERLOCALE=en}

      2015-08-18 09:46:01,961 DEBUG [AIF]: The executeEventScript is set to: YES

      2015-08-18 09:46:01,961 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox

      2015-08-18 09:46:01,961 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2015-08-18 09:46:01,961 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

      2015-08-18 09:46:01,961 DEBUG [AIF]: Comm.doScriptInit - END

      2015-08-18 09:46:01,961 DEBUG [AIF]: Comm.executeJythonScript - START

      2015-08-18 09:46:01,963 INFO  [AIF]: Executing the following script: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py

      2015-08-18 09:46:01,977 DEBUG [AIF]: FusionCloudAdapter.importDataFromFusion - START

      2015-08-18 09:46:01,977 DEBUG [AIF]: processId: 362

      2015-08-18 09:46:01,977 DEBUG [AIF]: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.sh "/u02/Oracle/Middleware/EPMSystem11R1" "/u02/user_projects/instance0" "importDataFromFusion" "362"

      2015-08-18 09:46:34,800 DEBUG [AIF]: stdOutData: INFO: Starting script FusionCloudAdapter ...

      PBCS Production Deployment setup proxy

      Starting FusionAdapter main program...

      prod mode: importDataFromFusion, pid: 362

      Initializing FusionAdapter initialized ...

      fusionGlWebServiceWsdl: https://ebgw-test.fin.em2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL

      fusionGlWebServiceUser: TM_FINADMIN

      fusionProductType: GL

      FusionAdapter initialized fine.

      From getBalRuleLoadEssRequestId() - essRequestId: 51282

      Calling getESSJobStatus for essRequestId: 51282

      <Aug 18, 2015 9:46:10 AM UTC> <Info> <Security> <BEA-090905> <Disabling CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true>

      <Aug 18, 2015 9:46:10 AM UTC> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG to FIPS186PRNG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Entrust Root Certification Authority - G2,OU=(c) 2009 Entrust\, Inc. - for authorized use only,OU=See www.entrust.net/legal-terms,O=Entrust\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=thawte Primary Root CA - G3,OU=(c) 2008 thawte\, Inc. - For authorized use only,OU=Certification Services Division,O=thawte\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=thawte Primary Root CA - G2,OU=(c) 2007 thawte\, Inc. - For authorized use only,O=thawte\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Buypass Class 3 Root CA,O=Buypass AS-983163327,C=NO". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Buypass Class 2 Root CA,O=Buypass AS-983163327,C=NO". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Class 3 Public Primary Certification Authority - G4,OU=(c) 2007 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GlobalSign,O=GlobalSign,OU=GlobalSign Root CA - R3". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "OU=Security Communication RootCA2,O=SECOM Trust Systems CO.\,LTD.,C=JP". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Commercial,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Universal Root Certification Authority,OU=(c) 2008 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Premium ECC,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G3,OU=(c) 2008 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G2,OU=(c) 2007 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:10 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Premium,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.12.>

      Status for job 51282 is: SUCCEEDED

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Entrust Root Certification Authority - G2,OU=(c) 2009 Entrust\, Inc. - for authorized use only,OU=See www.entrust.net/legal-terms,O=Entrust\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=thawte Primary Root CA - G3,OU=(c) 2008 thawte\, Inc. - For authorized use only,OU=Certification Services Division,O=thawte\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=thawte Primary Root CA - G2,OU=(c) 2007 thawte\, Inc. - For authorized use only,O=thawte\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Buypass Class 3 Root CA,O=Buypass AS-983163327,C=NO". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Buypass Class 2 Root CA,O=Buypass AS-983163327,C=NO". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Class 3 Public Primary Certification Authority - G4,OU=(c) 2007 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GlobalSign,O=GlobalSign,OU=GlobalSign Root CA - R3". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "OU=Security Communication RootCA2,O=SECOM Trust Systems CO.\,LTD.,C=JP". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Commercial,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Universal Root Certification Authority,OU=(c) 2008 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Premium ECC,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G3,OU=(c) 2008 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:20 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G2,OU=(c) 2007 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:21 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Premium,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.12.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Entrust Root Certification Authority - G2,OU=(c) 2009 Entrust\, Inc. - for authorized use only,OU=See www.entrust.net/legal-terms,O=Entrust\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=thawte Primary Root CA - G3,OU=(c) 2008 thawte\, Inc. - For authorized use only,OU=Certification Services Division,O=thawte\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=thawte Primary Root CA - G2,OU=(c) 2007 thawte\, Inc. - For authorized use only,O=thawte\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Buypass Class 3 Root CA,O=Buypass AS-983163327,C=NO". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=Buypass Class 2 Root CA,O=Buypass AS-983163327,C=NO". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 3,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=T-TeleSec GlobalRoot Class 2,OU=T-Systems Trust Center,O=T-Systems Enterprise Services GmbH,C=DE". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Class 3 Public Primary Certification Authority - G4,OU=(c) 2007 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GlobalSign,O=GlobalSign,OU=GlobalSign Root CA - R3". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "OU=Security Communication RootCA2,O=SECOM Trust Systems CO.\,LTD.,C=JP". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Commercial,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Universal Root Certification Authority,OU=(c) 2008 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Premium ECC,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G3,OU=(c) 2008 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G2,OU=(c) 2007 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.10045.4.3.3.>

      <Aug 18, 2015 9:46:32 AM UTC> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=AffirmTrust Premium,O=AffirmTrust,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.12.>

      Document Details Returned : 1

      ***********************************************

      Document Author : TM_FINADMIN

      Document Name : 51282.zip

      Document Security Group : Attachments

      Document Title : ESS_O_51282_BIP1

      ************************************************

      currentDownloadFileName: /tmp/ESS_O_51282_BIP1.csv

      currentDownloadFileName: /tmp/ESS_O_51282_BIP0.xml

      currentDownloadFileName: /tmp/51282.log

      downloadedDataFileName: /tmp/ESS_O_51282_BIP1.csv

      Updated downloaded file name in bal rule loads table: /tmp/ESS_O_51282_BIP1.csv

      The FusionAdapter main program has completed.

      INFO: The script FusionCloudAdapter has completed.

       

       

      2015-08-18 09:46:34,800 DEBUG [AIF]: stdErrData:

      2015-08-18 09:46:34,812 DEBUG [AIF]: Updated data file name in bal rule loads table: 362.dat

      2015-08-18 09:46:34,812 DEBUG [AIF]: FusionCloudAdapter.importDataFromFusion - END

      2015-08-18 09:46:34,812 DEBUG [AIF]: Comm.executeJythonScript - END

      2015-08-18 09:46:34,812 DEBUG [AIF]: CommData.insertFilePeriods - START

      2015-08-18 09:46:34,813 DEBUG [AIF]: doAppPeriodMappingsExist - PBCS: N

      2015-08-18 09:46:34,814 DEBUG [AIF]:

        select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM

        from (

              SELECT pp.PERIODKEY

                ,pp.PERIODDESC

                ,pp.YEARTARGET YEARTARGET

                ,pp.PERIODTARGET PERIODTARGET         

                ,brl.FILE_NAME_STATIC

                ,brl.FILE_NAME_SUFFIX_TYPE

                ,brl.FILE_NAME_DATE_FORMAT

                ,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

               

                INNER JOIN TPOVPERIOD_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ

                 

                INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

                  ON brp.loadid = brl.loadid

                  AND to_date(brp.parameter_value,'yyyy/MM/dd') = pp.periodkey

                WHERE brl.LOADID = 362   

                  AND br.rule_id = brl.rule_id

                  AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')

                  AND brp.parameter_name like 'AMOUNT%'

                 

                  UNION

                 

                SELECT pp.PERIODKEY

                ,pp.PERIODDESC

                ,pp.YEARTARGET YEARTARGET

                ,pp.PERIODTARGET PERIODTARGET         

                ,brl.FILE_NAME_STATIC

                ,brl.FILE_NAME_SUFFIX_TYPE

                ,brl.FILE_NAME_DATE_FORMAT

                ,0 GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

               

                INNER JOIN TPOVPERIOD_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ

                 

                  AND pp.PERIODKEY >= brl.START_PERIODKEY

                  AND pp.PERIODKEY <= brl.END_PERIODKEY        

                WHERE brl.LOADID = 362   

                  AND br.rule_id = brl.rule_id

                  AND br.MULTI_PERIOD_FILE_FLAG in( 'Y', 'X','E')

                 ) qrslt

                

                UNION

       

       

                 SELECT pp.PERIODKEY

                 ,pp.PERIODDESC

                ,pp.YEARTARGET YEARTARGET

                ,pp.PERIODTARGET PERIODTARGET

                ,brl.FILE_NAME_STATIC

                ,brl.FILE_NAME_SUFFIX_TYPE

                ,brl.FILE_NAME_DATE_FORMAT

                , 0 GL_EFFECTIVE_PERIOD_NUM

                FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

               

                INNER JOIN TPOVPERIOD_FLAT_V pp

                  ON pp.PERIODFREQ = pc.CATFREQ

                 

                  AND pp.PERIODKEY >= brl.START_PERIODKEY

                  AND pp.PERIODKEY <= brl.END_PERIODKEY

                WHERE brl.LOADID = 362             

                  AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )

                  AND br.rule_id = brl.rule_id

                 

                ORDER BY PERIODKEY

               

      2015-08-18 09:46:34,815 INFO  [AIF]: File Name: 362.dat

      2015-08-18 09:46:34,816 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

                PROCESS_ID

                ,PERIODKEY

                ,ADJUSTMENT_PERIOD_FLAG

                ,GL_PERIOD_YEAR

                ,GL_PERIOD_CODE

               

                ,GL_PERIOD_NAME

                ,GL_PERIOD_NUM

                ,GL_EFFECTIVE_PERIOD_NUM

                ,YEARTARGET

                ,PERIODTARGET

               

                ,IMP_ENTITY_TYPE

                ,IMP_ENTITY_NAME

                ,TRANS_ENTITY_TYPE

                ,TRANS_ENTITY_NAME

                ,PRIOR_PERIOD_FLAG

              ) VALUES (362,'2015-07-31','N',0,'0' ,'0',0,1,'FY15','Jul', 'PROCESS_BAL_IMP_FILE','362.dat','PROCESS_BAL_TRANS','Jul-15','N' )

             

      2015-08-18 09:46:34,818 DEBUG [AIF]: CommData.insertFilePeriods - END

      2015-08-18 09:46:34,818 DEBUG [AIF]: CommData.getPovList - START

      2015-08-18 09:46:34,819 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 TPOVPERIOD pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

              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 = 362

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

           

      2015-08-18 09:46:34,820 DEBUG [AIF]: CommData.getPovList - END

      2015-08-18 09:46:34,820 DEBUG [AIF]: CommData.insertImportProcessDetails - START

      2015-08-18 09:46:34,820 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

                ,'msiraj@exsab.com.sa' 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 = 362

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2015-08-18 09:46:34,822 DEBUG [AIF]: CommData.insertImportProcessDetails - END

      2015-08-18 09:46:34,822 DEBUG [AIF]: Comm.executeScript - START

      2015-08-18 09:46:34,824 DEBUG [AIF]: The following script does not exist: /u03/inbox/data/scripts/event/BefImport.py

      2015-08-18 09:46:34,824 DEBUG [AIF]: Comm.executeVBScript - START

      2015-08-18 09:46:34,824 DEBUG [AIF]: The WindowsTempFolder is set to: /u02/user_projects/instance0/tmp

      2015-08-18 09:46:34,824 DEBUG [AIF]: The following script does not exist: \u03\inbox\data\scripts\event\BefImport.vbs

      2015-08-18 09:46:34,825 DEBUG [AIF]: Comm.executeVBScript - END

      2015-08-18 09:46:34,825 DEBUG [AIF]: Comm.executeScript - END

      2015-08-18 09:46:34,825 DEBUG [AIF]: CommData.preImportData - END

      2015-08-18 09:46:37,924 DEBUG [AIF]: FileData.importData - START

      2015-08-18 09:46:37,924 DEBUG [AIF]: Importing data for load id: 362

      2015-08-18 09:46:37,925 DEBUG [AIF]:  SELECT a.partitionkey,

                                        a.catkey,

                                        a.start_periodkey,

                                        b.perioddesc,

                                        coalesce(a.journal_flag,'N') JOURNAL_FLAG,

                                        c.last_updated_by,

                                        coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,

                                        a.FILE_PATH,

                                        a.RULE_ID,

                                        a.application_id,

                                        coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG

                                      FROM aif_bal_rule_loads a,

                                      aif_balance_rules br,

                                        tpovperiod b,

                                        aif_processes c

                                      WHERE a.loadid       = 362

                                      AND a.start_periodkey=b.periodkey

                                      AND a.loadid         =c.process_id

                                      AND br.rule_id = a.rule_id

                                     

      2015-08-18 09:46:37,927 DEBUG [AIF]: FileData.py: Importing Text data for load id: 362

      2015-08-18 09:46:37,993 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :/u03/inbox/outbox/logs/PBCS_362.log

      2015-08-18 09:46:37,993 DEBUG [AIF]: EPMFDM-140274:Message - SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,

        COALESCE(brl.catkey,0) CATKEY,

        COALESCE(p.rule_id,0) RULE_ID,

        part.PARTCURRENCYKEY PARTCURRENCYKEY,

        dir.FILE_PATH,

        p.CLUSTER_NAME,

        p.APPLICATION_ID

      FROM aif_processes p,

        aif_bal_rule_loads brl,

        tpovpartition part,

        (SELECT COALESCE(

          (SELECT PROFILE_OPTION_VALUE

            || '/'

          FROM AIF_PROFILE_OPTION_VALUES

          WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

          AND LEVEL_ID              = 1005

          AND LEVEL_VALUE           = brl.APPLICATION_ID

          ) ,COALESCE(

          (SELECT PROFILE_OPTION_VALUE

            || '/'

          FROM AIF_PROFILE_OPTION_VALUES

          WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

          AND LEVEL_ID              = 1000

          ) ,'' ) ,'' )

          || COALESCE(brl.FILE_PATH, '') FILE_PATH,

          brl.LOADID

        FROM AIF_BAL_RULE_LOADS brl

        ) dir

      WHERE p.process_id    = ?

      AND p.process_id      = dir.loadid

      AND brl.loadid        = p.process_id

      AND part.partitionkey = p.partitionkey

      2015-08-18 09:46:37,994 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::362;67:4:34:[NONE]:/u03/inbox/Inbox

      2015-08-18 09:46:37,998 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

      2015-08-18 09:46:37,998 DEBUG [AIF]: EPMFDM-140274:Message -  SELECT pp.PERIODKEY,

        pp.PERIODTARGET,

        pp.GL_PERIOD_NAME,

        en.FILE_ENTITY_NAME,

        en.ENTITY_NAME_ORDER,

        br.MULTI_PERIOD_FILE_FLAG,

        pp.TRANS_ENTITY_NAME,

         pp.GL_PERIOD_YEAR_CHAR

      FROM AIF_PROCESS_PERIODS pp,

        AIF_BALANCE_RULES br,

        AIF_PROCESSES p,

        (SELECT DISTINCT entity_name FILE_ENTITY_NAME,

          pd.process_id,

          pd.entity_name_order

        FROM aif_process_details pd

        WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE'

        AND pd.target_table_name = 'TDATASEG'

        AND pd.status            = 'PENDING'

        ) en

      WHERE pp.PROCESS_ID             = ?

      AND p.process_id                = pp.process_id

      AND en.process_id               = pp.process_id

      AND pp.IMP_ENTITY_NAME          = en.file_entity_name

      AND br.rule_id                  = p.rule_id

      AND en.entity_name_order        = pp.GL_EFFECTIVE_PERIOD_NUM

      AND ((br.MULTI_PERIOD_FILE_FLAG in ( 'Y','T','X','E','H')   )

                                OR

          (br.MULTI_PERIOD_FILE_FLAG is null OR br.MULTI_PERIOD_FILE_FLAG  = 'N')

          )

      ORDER BY en.entity_name_order

      2015-08-18 09:46:37,999 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?

      2015-08-18 09:46:38,002 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?

      2015-08-18 09:46:38,003 ERROR [AIF]: EPMFDM-140274:Message - /u03/inbox/Inbox/362.dat (No such file or directory)

      2015-08-18 09:46:38,006 FATAL [AIF]: Error in FileData.importData

      Traceback (most recent call last):

        File "<string>", line 84, in importData

      RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}

       

       

      2015-08-18 09:46:38,101 DEBUG [AIF]: CommData.postImportData - START

      2015-08-18 09:46:38,102 DEBUG [AIF]: CommData.getRuleInfo - START

      2015-08-18 09:46:38,102 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 WHEN 'PLAN6' THEN 6 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 = 362

             

      2015-08-18 09:46:38,106 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 = 13

            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 = 67

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

           

            AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

           

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2015-08-18 09:46:38,109 DEBUG [AIF]: {'APPLICATION_ID': 13L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'GL2PBCS', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'/u02/user_projects/instance0', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PBCS', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 27L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'GL2PBCS', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'Y', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'msiraj@exsab.com.sa', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Period', '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'UD6', 'DIMENSION_ID': 32L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', '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': 37L}, 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': 71L}, 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': 70L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Year', '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'UD5', 'DIMENSION_ID': 36L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Scenario', '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': 33L}, 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': 35L}, 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': 34L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 67L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 34L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://em2pbcs006.nldc1.oraclecloud.com:9000/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 13L, 'IMPTARGETSOURCESYSTEMID': 0L}

      2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getRuleInfo - END

      2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.updateTDATASEG_T - START

      2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getLedgerListAndMap - START

      2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getLedgerSQL - START

      2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getLedgerSQL - END

      2015-08-18 09:46:38,109 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 = 34

               

      2015-08-18 09:46:38,110 DEBUG [AIF]: CommData.getLedgerListAndMap - END

      2015-08-18 09:46:38,110 DEBUG [AIF]: CommData.getPovList - START

      2015-08-18 09:46:38,112 DEBUG [AIF]: doAppPeriodMappingsExist - PBCS: N

      2015-08-18 09:46:38,112 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 TPOVPERIOD pp

                  ON pp.PERIODKEY = pprd.PERIODKEY

              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 = 362

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

           

      2015-08-18 09:46:38,113 DEBUG [AIF]: CommData.getPovList - END

      2015-08-18 09:46:38,113 DEBUG [AIF]:  SELECT pp.PERIODKEY

                FROM AIF_PROCESS_PERIODS pp, 

                  (SELECT entity_name FILE_ENTITY_NAME, 

                    pd.process_id,pd.entity_name_order 

                  FROM aif_process_details pd 

                  WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE' 

                  AND pd.target_table_name = 'TDATASEG' 

                  AND pd.status            = 'FAILED' 

                  ) en 

                WHERE pp.PROCESS_ID    = 362

                AND en.process_id      = pp.process_id 

                AND pp.IMP_ENTITY_NAME = en.file_entity_name  

                order by en.entity_name_order

      2015-08-18 09:46:38,114 INFO  [AIF]:

      Import Data from Source for Period 'Jul-15'

      2015-08-18 09:46:38,114 DEBUG [AIF]: CommData.updateWorkflow - START

      2015-08-18 09:46:38,115 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 = 67

          AND tlp.CATKEY = 4

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

          AND tlp.RULE_ID = 34

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

         

      2015-08-18 09:46:38,116 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 = 67 AND CATKEY = 4 AND PERIODKEY = '2015-07-31' AND RULE_ID = 34

             

      2015-08-18 09:46:38,119 DEBUG [AIF]: CommData.updateWorkflow - END

      2015-08-18 09:46:38,122 FATAL [AIF]: Error in CommData.updateTDATASEG_T

      Traceback (most recent call last):

        File "<string>", line 1010, in updateTDATASEG_T

      Import Error

       

       

      2015-08-18 09:46:38,123 DEBUG [AIF]: CommData.updateWorkflow - START

      2015-08-18 09:46:38,123 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

              ,PROCESSSTATUS = 2

                ,PROCESSIMP = 0

                ,BLNWCDIRTY = 0

                ,BLNLOGICDIRTY = 0

                ,BLNVALDIRTY = 0

                ,PROCESSIMPNOTE = 'AIF_WF_IMP_IMPORT_ERR'

              WHERE PARTITIONKEY = 67 AND CATKEY = 4 AND PERIODKEY = '2015-07-31' AND RULE_ID = 34

             

      2015-08-18 09:46:38,125 DEBUG [AIF]: CommData.updateWorkflow - END

      2015-08-18 09:46:38,128 DEBUG [AIF]: Comm.doScriptInit - START

      2015-08-18 09:46:38,248 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, INBOXDIR=/u03/inbox/inbox, LOCNAME=GL2PBCS, SOURCENAME=GL2PBCS, APPID=13, SOURCEID=27, APPROOTDIR=/u03/inbox, IMPORTFORMAT=GL2PBCS, SCRIPTSDIR=/u03/inbox/data/scripts, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=34, CATNAME=Actual, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, LOADID=362, PERIODNAME=Jul-15, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2015-07-31, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=PBCS, FILENAME=362.dat, LOCKEY=67, RULENAME=GL2PBCS, OUTBOXDIR=/u03/inbox/outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, FILEDIR=Inbox, USERNAME=msiraj@exsab.com.sa, IMPORTFLAG=Y, USERLOCALE=en}

      2015-08-18 09:46:38,248 DEBUG [AIF]: The EpmOracleHome is set to: /u02/Oracle/Middleware/EPMSystem11R1

      2015-08-18 09:46:38,248 DEBUG [AIF]: The EpmOracleInstance is set to: /u02/user_projects/instance0

      2015-08-18 09:46:38,248 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2015-08-18 09:46:38,248 DEBUG [AIF]: The executeEventScript is set to: YES

      2015-08-18 09:46:38,248 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

      2015-08-18 09:46:38,248 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox

      2015-08-18 09:46:38,248 DEBUG [AIF]: Comm.doScriptInit - END

      2015-08-18 09:46:38,249 DEBUG [AIF]: Comm.executeScript - START

      2015-08-18 09:46:38,249 DEBUG [AIF]: The following script does not exist: /u03/inbox/data/scripts/event/AftImport.py

      2015-08-18 09:46:38,249 DEBUG [AIF]: Comm.executeVBScript - START

      2015-08-18 09:46:38,249 DEBUG [AIF]: The WindowsTempFolder is set to: /u02/user_projects/instance0/tmp

      2015-08-18 09:46:38,250 DEBUG [AIF]: The following script does not exist: \u03\inbox\data\scripts\event\AftImport.vbs

      2015-08-18 09:46:38,250 DEBUG [AIF]: Comm.executeVBScript - END

      2015-08-18 09:46:38,250 DEBUG [AIF]: Comm.executeScript - END

      2015-08-18 09:46:38,297 FATAL [AIF]: Error in COMM Post Import Data

      2015-08-18 09:46:38,355 INFO  [AIF]: FDMEE Process End, Process ID: 362

       

      Regards,

      SR