5 Replies Latest reply on Sep 30, 2015 10:52 AM by Chuggans-Oracle

    Error while importing Metadata using FDMEE

    2922374

      Hi experts,

       

      I have been trying to import metadata from EBS to HFM using FDMEE. My EPM version(11.1.2.4)

      I have followed the steps as mentioned in the admin guide,but the import fails while creating EPMA import profile for dimension ERPI system Profile 3(Shared) when checked in the process details tab.

       

      I know I'm missing something, someone please help me resolve this.

       

      Thanks In advance

        • 1. Re: Error while importing Metadata using FDMEE
          San_

          You would need to provide more details.. question is not clear

          • 2. Re: Error while importing Metadata using FDMEE
            2922374

            Hi San,

             

            Thankyou for your response.

             

            steps followed,

            I created an application in HFM with required dimensions and deployed the application.

            I have made the following setups

            source system --> EBS then selected the required ledger from Source Accounting Entity

            Import Format --> created an import format with source as ERP and made the dimensional mapping, also created a location for the same

            Metadata Rule --> created a metadata rule with

               *dimension - Account-Account

               *EPMA Option - Merge as primary

               Further NO other setups were made in the metadate rule section.

             

            Then on execution of metadata rule the process fails on the 4th steps stating

            "Creating EPMA import profile for dimension ERPI System Profile 3 (Shared)"

             

            Let me know whether the steps followed are correct, or if am missing anything please suggest a solution.

            Regards

            • 3. Re: Error while importing Metadata using FDMEE
              User359476 -Oracle

              Have you created configure Interface datasource?

              Settings-> EPMA Data Source-> Mention the created data source name

              • 4. Re: Error while importing Metadata using FDMEE
                2922374

                Hi,

                 

                Interface data source was created with the EPM server connection URL. And then on executing the METADATA RULE following error was thrown, Please suggest.

                 

                2015-09-30 12:49:12,056 INFO  [AIF]: FDMEE Process Start, Process ID: 293

                2015-09-30 12:49:12,057 INFO  [AIF]: FDMEE Logging Level: 5

                2015-09-30 12:49:12,057 INFO  [AIF]: FDMEE Log File: FDMEE\outbox\logs\APP1_293.log

                2015-09-30 12:49:12,057 INFO  [AIF]: User:admin

                2015-09-30 12:49:12,057 INFO  [AIF]: Location:APP1_loc (Partitionkey:25)

                2015-09-30 12:49:12,058 INFO  [AIF]: Period Name:NA (Period Key:null)

                2015-09-30 12:49:12,058 INFO  [AIF]: Category Name:NA (Category key:null)

                2015-09-30 12:49:12,058 INFO  [AIF]: Rule Name:105 (Rule ID:105)

                2015-09-30 12:49:16,212 INFO  [AIF]: FDM Version: 11.1.2.4.000

                2015-09-30 12:49:16,212 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

                [Oracle JRockit(R) (Oracle Corporation)]

                2015-09-30 12:49:16,212 INFO  [AIF]: Java Platform: java1.6.0_37

                2015-09-30 12:49:16,212 INFO  [AIF]: Log File Encoding: UTF-8

                2015-09-30 12:49:30,204 INFO  [AIF]: COMM Dimension Pre-Processing - Multi Process Validation - START

                2015-09-30 12:49:30,206 DEBUG [AIF]:

                        SELECT tpp.PARTNAME

                        FROM AIF_MAPPING_RULES mr_dup

                        ,TPOVPARTITION tpp

                        ,AIF_PROCESSES p

                        WHERE mr_dup.SOURCE_SYSTEM_ID = 2

                        AND mr_dup.RULE_ID <> 105

                        AND p.RULE_ID = mr_dup.RULE_ID

                        AND p.STATUS IN ('PENDING','RUNNING')

                        AND tpp.PARTITIONKEY = mr_dup.PARTITIONKEY

                        AND EXISTS (

                          SELECT 1

                          FROM AIF_MAPPING_RULES mr

                          ,AIF_COA_SEGMENTS cs

                          ,AIF_COA_SEGMENTS cs_dup

                          WHERE mr.RULE_ID = 105

                          AND cs.SOURCE_SYSTEM_ID = mr.SOURCE_SYSTEM_ID

                          AND cs.SOURCE_COA_ID = mr.SOURCE_COA_ID

                          AND cs_dup.SOURCE_SYSTEM_ID = mr_dup.SOURCE_SYSTEM_ID

                          AND cs_dup.SOURCE_COA_ID = mr_dup.SOURCE_COA_ID

                          AND cs_dup.VALUE_SET_ID = cs.VALUE_SET_ID

                        )

                       

                2015-09-30 12:49:30,208 INFO  [AIF]: COMM Dimension Pre-Processing - Multi Process Validation - END

                2015-09-30 12:49:30,309 INFO  [AIF]: LKM EBS/FS Extract Members Table VS - Process Value Sets - START

                2015-09-30 12:49:30,309 DEBUG [AIF]:

                            SELECT igd.IMPSOURCECOALINEID1 COA_LINE_ID1,

                              dim.TARGET_DIMENSION_NAME

                            FROM AIF_MAP_DIM_DETAILS_V mdd ,

                              AIF_MAPPING_RULES map ,

                              AIF_DIMENSIONS dim ,

                              TPOVPARTITION part ,

                              TBHVIMPITEMERPI igd ,

                              aif_target_appl_dimensions ad

                            WHERE mdd.rule_id                         = 105

                            AND mdd.RULE_ID                           =map.RULE_ID

                            AND mdd.MAPPING_TYPE_CODE                IN ('SINGLE_SEGMENT', 'CONCATE_SEGMENT')

                            AND ( (map.DEFAULT_ALIAS_DIMENSION_ID    IS NOT NULL

                            AND mdd.dimension_id                     <> map.DEFAULT_ALIAS_DIMENSION_ID)

                            OR (map.DEFAULT_ALIAS_DIMENSION_ID       IS NULL) )

                            AND ( (map.DEFAULT_CURRENCY_DIMENSION_ID IS NOT NULL

                            AND mdd.dimension_id                     <> map.DEFAULT_CURRENCY_DIMENSION_ID)

                            OR (map.DEFAULT_CURRENCY_DIMENSION_ID    IS NULL) )

                            AND dim.DIMENSION_ID                      = mdd.DIMENSION_ID

                            AND part.partimpgroup                     = igd.impgroupkey

                            AND part.partitionkey                     = map.partitionkey

                            AND ad.dimension_id                       = mdd.dimension_id

                            AND ad.BALANCE_COLUMN_NAME                = igd.IMPFLDFIELDNAME     

                           

                2015-09-30 12:49:30,310 DEBUG [AIF]:

                        DELETE FROM AIF_DIM_MEMBERS_STG

                        WHERE SOURCE_SYSTEM_ID = \?

                        AND VALUE_SET_ID = \?

                       

                2015-09-30 12:49:30,310 DEBUG [AIF]:

                        INSERT INTO AIF_DIM_MEMBERS_STG (

                          SOURCE_SYSTEM_ID

                          ,VALUE_SET_ID

                          ,VALUE_ID

                          ,VALUE_NAME

                          ,VALUE_DESCRIPTION

                          ,SUMMARY_FLAG

                          ,NODE_FLAG

                          ,COMPILED_VALUE_ATTRIBUTES

                          ,STAT_ACCOUNT_FLAG

                          ,UNIT_OF_MEASURE

                          ,LANGUAGE

                          ,LAST_UPDATED_BY

                          ,LAST_UPDATE_DATE

                        ) VALUES (\?,\?,\?,\?,\?,\?,\?,\?,\?,null,\?,\?,current_timestamp)

                       

                2015-09-30 12:49:30,311 DEBUG [AIF]:

                        SELECT DISTINCT S.VALUE_SET_ID

                        ,COALESCE(cstl.DISPLAY_NAME,S.COA_SEGMENT_NAME) COA_SEGMENT_NAME

                        ,VALIDATION_TYPE

                        ,VALUE_COLUMN_NAME

                        ,MEANING_COLUMN_NAME

                        ,APPLICATION_TABLE_NAME

                        ,ADDITIONAL_WHERE_CLAUSE

                        ,COMPILED_ATTRIBUTE_COLUMN_NAME

                        ,ID_COLUMN_NAME

                        FROM AIF_EBS_COA_SEGMENTS ES

                        ,AIF_COA_SEGMENTS S

                          LEFT OUTER JOIN AIF_COA_SEGMENTS_TL cstl

                          ON cstl.COA_LINE_ID = S.COA_LINE_ID

                          AND cstl.LANGUAGE = \?

                        WHERE s.source_system_id  = \?

                        AND s.coa_line_id = es.coa_line_id

                        AND es.VALIDATION_TYPE IN ('I','F')

                        AND s.coa_line_id = \?

                       

                2015-09-30 12:49:30,314 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

                    ) VALUES (

                      293

                      ,'PROCESS_MEM_IMP'

                      ,1002470

                      ,'Entity (Company)'

                      ,1002470

                      ,'AIF_DIM_MEMBERS_STG'

                      ,CURRENT_TIMESTAMP

                      ,NULL

                      ,NULL

                      ,'PENDING'

                      ,'admin'

                      ,CURRENT_TIMESTAMP

                    )

                   

                2015-09-30 12:49:30,318 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

                    ) VALUES (

                      293

                      ,'PROCESS_MEM_IMP'

                      ,1002472

                      ,'Account (Account)'

                      ,1002472

                      ,'AIF_DIM_MEMBERS_STG'

                      ,CURRENT_TIMESTAMP

                      ,NULL

                      ,NULL

                      ,'PENDING'

                      ,'admin'

                      ,CURRENT_TIMESTAMP

                    )

                   

                2015-09-30 12:49:30,375 INFO  [AIF]: LKM EBS/FS Extract Members Table VS - Process Value Sets - END

                2015-09-30 12:49:30,870 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - START

                2015-09-30 12:49:30,871 DEBUG [AIF]:  select min(entity_name) ENTITY_NAME

                                              from aif_process_details pd

                                              where process_id = 293

                                              and entity_type = 'PROCESS_MEM_IMP'

                                              and entity_id = 1002470

                                              and target_table_name = 'AIF_DIM_MEMBERS_STG'

                                              and status = 'PENDING'

                                              and entity_name_order = (

                                                select min(entity_name_order)

                                                from aif_process_details pdmin

                                                where pdmin.process_id = pd.process_id

                                                and pdmin.entity_type = pd.entity_type

                                                and pdmin.entity_id = pd.entity_id

                                                and pdmin.target_table_name = pd.target_table_name

                                                and pdmin.status = pd.status

                                              )

                                             

                2015-09-30 12:49:30,874 DEBUG [AIF]:

                    UPDATE AIF_PROCESS_DETAILS

                    SET STATUS = 'RUNNING'

                    ,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 ('admin' IS NULL) THEN LAST_UPDATED_BY

                      ELSE 'admin'

                    END

                    ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                    WHERE PROCESS_ID = 293

                    AND ENTITY_TYPE = 'PROCESS_MEM_IMP'

                    AND ENTITY_NAME = 'Entity (Company)'

                   

                2015-09-30 12:49:30,875 DEBUG [AIF]:

                            DELETE FROM AIF_DIM_MEMBERS_STG

                            WHERE SOURCE_SYSTEM_ID = 2

                            AND VALUE_SET_ID = 1002470

                           

                2015-09-30 12:49:30,877 DEBUG [AIF]:

                            SELECT (2 * ecs.ACCOUNT_ATTR_POSITION - 1) ACCOUNT_ATTR_POSITION

                            FROM AIF_COA_SEGMENTS cs

                            ,AIF_EBS_COA_SEGMENTS ecs

                            WHERE cs.SOURCE_SYSTEM_ID = 2

                            AND cs.SOURCE_COA_ID = 101

                            AND cs.VALUE_SET_ID = 1002470

                            AND cs.ACCOUNT_TYPE_FLAG = 'Y'

                            AND ecs.COA_LINE_ID = cs.COA_LINE_ID

                           

                2015-09-30 12:49:30,877 DEBUG [AIF]:

                            INSERT INTO AIF_DIM_MEMBERS_STG (

                              SOURCE_SYSTEM_ID,

                              VALUE_SET_ID,

                              VALUE_ID,

                              VALUE_NAME,

                              VALUE_DESCRIPTION,

                              SUMMARY_FLAG,

                              NODE_FLAG,

                              COMPILED_VALUE_ATTRIBUTES,

                              ACCOUNT_TYPE,

                              STAT_ACCOUNT_FLAG,

                              UNIT_OF_MEASURE,

                              LANGUAGE,

                              LAST_UPDATED_BY,

                              LAST_UPDATE_DATE

                            )

                            SELECT SOURCE_SYSTEM_ID

                            ,VALUE_SET_ID

                            ,VALUE_ID

                            ,VALUE_NAME

                            ,VALUE_DESCRIPTION

                            ,SUMMARY_FLAG

                            ,NODE_FLAG

                            ,COMPILED_VALUE_ATTRIBUTES

                            ,NULL

                            ,STAT_ACCOUNT_FLAG

                            ,UNIT_OF_MEASURE

                            ,LANGUAGE

                            ,LAST_UPDATED_BY

                            ,LAST_UPDATE_DATE

                            FROM AIF_DIM_MEMBERS_STG_T t

                            WHERE LOADID = 293

                            AND SOURCE_SYSTEM_ID = 2

                            AND VALUE_SET_ID = 1002470

                           

                2015-09-30 12:49:30,879 DEBUG [AIF]:

                    UPDATE AIF_PROCESS_DETAILS

                    SET STATUS = 'SUCCESS'

                    ,RECORDS_PROCESSED = CASE

                      WHEN RECORDS_PROCESSED IS NULL THEN 0

                      ELSE RECORDS_PROCESSED

                    END + 24

                    ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

                    ,LAST_UPDATED_BY = CASE

                      WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY

                      ELSE 'admin'

                    END

                    ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                    WHERE PROCESS_ID = 293

                    AND ENTITY_TYPE = 'PROCESS_MEM_IMP'

                    AND ENTITY_NAME = 'Entity (Company)'

                   

                2015-09-30 12:49:30,881 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - END

                2015-09-30 12:49:32,785 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - START

                2015-09-30 12:49:32,786 DEBUG [AIF]:  select min(entity_name) ENTITY_NAME

                                              from aif_process_details pd

                                              where process_id = 293

                                              and entity_type = 'PROCESS_MEM_IMP'

                                              and entity_id = 1002472

                                              and target_table_name = 'AIF_DIM_MEMBERS_STG'

                                              and status = 'PENDING'

                                              and entity_name_order = (

                                                select min(entity_name_order)

                                                from aif_process_details pdmin

                                                where pdmin.process_id = pd.process_id

                                                and pdmin.entity_type = pd.entity_type

                                                and pdmin.entity_id = pd.entity_id

                                                and pdmin.target_table_name = pd.target_table_name

                                                and pdmin.status = pd.status

                                              )

                                             

                2015-09-30 12:49:32,787 DEBUG [AIF]:

                    UPDATE AIF_PROCESS_DETAILS

                    SET STATUS = 'RUNNING'

                    ,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 ('admin' IS NULL) THEN LAST_UPDATED_BY

                      ELSE 'admin'

                    END

                    ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                    WHERE PROCESS_ID = 293

                    AND ENTITY_TYPE = 'PROCESS_MEM_IMP'

                    AND ENTITY_NAME = 'Account (Account)'

                   

                2015-09-30 12:49:32,788 DEBUG [AIF]:

                            DELETE FROM AIF_DIM_MEMBERS_STG

                            WHERE SOURCE_SYSTEM_ID = 2

                            AND VALUE_SET_ID = 1002472

                           

                2015-09-30 12:49:32,801 DEBUG [AIF]:

                            SELECT (2 * ecs.ACCOUNT_ATTR_POSITION - 1) ACCOUNT_ATTR_POSITION

                            FROM AIF_COA_SEGMENTS cs

                            ,AIF_EBS_COA_SEGMENTS ecs

                            WHERE cs.SOURCE_SYSTEM_ID = 2

                            AND cs.SOURCE_COA_ID = 101

                            AND cs.VALUE_SET_ID = 1002472

                            AND cs.ACCOUNT_TYPE_FLAG = 'Y'

                            AND ecs.COA_LINE_ID = cs.COA_LINE_ID

                           

                2015-09-30 12:49:32,803 DEBUG [AIF]:

                            INSERT INTO AIF_DIM_MEMBERS_STG (

                              SOURCE_SYSTEM_ID,

                              VALUE_SET_ID,

                              VALUE_ID,

                              VALUE_NAME,

                              VALUE_DESCRIPTION,

                              SUMMARY_FLAG,

                              NODE_FLAG,

                              COMPILED_VALUE_ATTRIBUTES,

                              ACCOUNT_TYPE,

                              STAT_ACCOUNT_FLAG,

                              UNIT_OF_MEASURE,

                              LANGUAGE,

                              LAST_UPDATED_BY,

                              LAST_UPDATE_DATE

                            )

                            SELECT SOURCE_SYSTEM_ID

                            ,VALUE_SET_ID

                            ,VALUE_ID

                            ,VALUE_NAME

                            ,VALUE_DESCRIPTION

                            ,SUMMARY_FLAG

                            ,NODE_FLAG

                            ,COMPILED_VALUE_ATTRIBUTES

                            ,SUBSTR(COMPILED_VALUE_ATTRIBUTES,5,1)

                            ,STAT_ACCOUNT_FLAG

                            ,UNIT_OF_MEASURE

                            ,LANGUAGE

                            ,LAST_UPDATED_BY

                            ,LAST_UPDATE_DATE

                            FROM AIF_DIM_MEMBERS_STG_T t

                            WHERE LOADID = 293

                            AND SOURCE_SYSTEM_ID = 2

                            AND VALUE_SET_ID = 1002472

                           

                2015-09-30 12:49:32,813 DEBUG [AIF]:

                    UPDATE AIF_PROCESS_DETAILS

                    SET STATUS = 'SUCCESS'

                    ,RECORDS_PROCESSED = CASE

                      WHEN RECORDS_PROCESSED IS NULL THEN 0

                      ELSE RECORDS_PROCESSED

                    END + 506

                    ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

                    ,LAST_UPDATED_BY = CASE

                      WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY

                      ELSE 'admin'

                    END

                    ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                    WHERE PROCESS_ID = 293

                    AND ENTITY_TYPE = 'PROCESS_MEM_IMP'

                    AND ENTITY_NAME = 'Account (Account)'

                   

                2015-09-30 12:49:32,817 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - END

                2015-09-30 12:49:34,016 INFO  [AIF]: EBS/FS Load Concat Dim Members - Load Concat Dim Members - START

                2015-09-30 12:49:34,016 DEBUG [AIF]: 

                        SELECT process_id

                        ,step_name

                        ,step_seq

                        ,status

                        FROM aif_process_steps

                        WHERE process_id = 293

                        AND step_name = 'Load Concatenated Dimensions'

                        ORDER BY step_seq

                       

                2015-09-30 12:49:34,017 DEBUG [AIF]:

                       SELECT DISTINCT mdd.DIMENSION_ID

                        ,mdd.IMPFLDFIELDNAME

                        ,mdd.VIEW_FILTER_VALUE

                        ,mdd.MEMBER_AFFIX_TYPE

                        ,mdd.MEMBER_AFFIX_VALUE

                        ,mdd.MEMBER_TABLE_NAME

                        ,mdd.PROPERTY_ARRAY_TABLE_NAME

                        ,dim.TARGET_DIMENSION_CLASS_NAME

                        ,dim.TARGET_DIMENSION_NAME

                        ,CASE

                          WHEN (

                            SELECT min(cs.COA_LINE_ID)

                            FROM AIF_COA_SEGMENTS cs

                            WHERE cs.SOURCE_SYSTEM_ID = mr.SOURCE_SYSTEM_ID

                            AND cs.SOURCE_COA_ID = mr.SOURCE_COA_ID

                            AND cs.ACCOUNT_TYPE_FLAG = 'Y'

                          ) IN (SELECT IMPSOURCECOALINEID1

                                                FROM tbhvimpitemerpi igd,

                                                  tpovpartition tpp

                                                WHERE mr.partitionkey       = tpp.partitionkey

                                                AND tpp.partimpgroup      =igd.impgroupkey

                                                AND igd.impfldfieldname   = mdd.impfldfieldname           

                                                ) THEN 'Y'

                          ELSE 'N'

                        END ACCOUNT_SEGMENT_FLAG

                        FROM AIF_MAP_DIM_DETAILS_V mdd

                        ,AIF_DIMENSIONS dim

                        ,AIF_MAPPING_RULES mr

                        ,AIF_TARGET_APPLICATIONS tap

                        WHERE mdd.MAPPING_TYPE_CODE = 'CONCATE_SEGMENT'

                        AND mdd.DIMENSION_ID = dim.DIMENSION_ID

                        AND mr.rule_id = 105

                        AND mr.RULE_ID = mdd.rule_id

                        AND tap.APPLICATION_ID = mr.APPLICATION_ID

                        AND (

                          tap.TARGET_APPLICATION_TYPE = 'EPMA_SHARED'

                          or (

                            tap.TARGET_APPLICATION_TYPE <> 'EPMA_SHARED'

                            and dim.DIMENSION_ID in (

                              SELECT dimension_id

                              FROM aif_map_dim_details maps

                              ,aif_map_rule_lines lines 

                              WHERE lines.rule_map_id = maps.rule_map_id 

                              and lines.rule_id = mr.rule_id

                              and maps.shared_mapping_flag <> 'Y'

                            )

                          )

                        )

                       

                2015-09-30 12:49:34,018 INFO  [AIF]: EBS/FS Load Concat Dim Members - Load Concat Dim Members - END

                2015-09-30 12:49:38,366 INFO  [AIF]: EBS Hierarchy Processing Ind VS - Insert into Process Details Ind VS - START

                2015-09-30 12:49:38,368 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 293

                        ,'PROCESS_HIER_IMP'

                        ,VALUE_SET_ID

                        ,TARGET_DIMENSION_NAME||' ('||SEGMENT_NAME||')'

                        ,VALUE_SET_ID

                        ,'AIF_DIM_HIERARCHIES_STG'

                        ,CURRENT_TIMESTAMP

                        ,NULL

                        ,0

                        ,'PENDING'

                        ,'admin'

                        ,CURRENT_TIMESTAMP

                        FROM (

                          SELECT DISTINCT ecs.VALUE_SET_ID

                          ,dim.TARGET_DIMENSION_NAME

                          ,dim.DIMENSION_ID

                          ,COALESCE(cstl.DISPLAY_NAME, cs.COA_SEGMENT_NAME) SEGMENT_NAME

                          FROM AIF_MAP_HIERARCHIES mh

                          ,AIF_MAP_HIER_DETAILS mhd

                          ,AIF_DIMENSIONS dim

                          ,AIF_EBS_COA_SEGMENTS ecs

                          ,AIF_COA_SEGMENTS cs

                          LEFT OUTER JOIN AIF_COA_SEGMENTS_TL cstl

                            ON cstl.COA_LINE_ID = cs.COA_LINE_ID

                            AND cstl.LANGUAGE = 'US'

                          WHERE mh.RULE_ID = 105

                          AND mhd.HIERARCHY_ID = mh.HIERARCHY_ID

                          AND ecs.COA_LINE_ID = mhd.COA_LINE_ID

                          AND cs.COA_LINE_ID = ecs.COA_LINE_ID

                          AND ecs.VALIDATION_TYPE = 'I'

                          AND dim.DIMENSION_ID = mh.DIMENSION_ID

                        ) q

                       

                2015-09-30 12:49:38,370 INFO  [AIF]: EBS Hierarchy Processing Ind VS - Insert into Process Details Ind VS - END

                2015-09-30 12:49:39,172 INFO  [AIF]: EBS Extract Hierarchies Table VS - Populate Dim Hierarchy Stage - START

                2015-09-30 12:49:39,172 DEBUG [AIF]:

                        SELECT DISTINCT ecs.VALUE_SET_ID

                        ,dim.TARGET_DIMENSION_NAME

                        ,COALESCE(cstl.DISPLAY_NAME, cs.COA_SEGMENT_NAME) SEGMENT_NAME

                        FROM AIF_MAP_HIERARCHIES mh

                        ,AIF_MAP_HIER_DETAILS mhd

                        ,AIF_DIMENSIONS dim

                        ,AIF_EBS_COA_SEGMENTS ecs

                        ,AIF_COA_SEGMENTS cs

                        LEFT OUTER JOIN AIF_COA_SEGMENTS_TL cstl

                          ON cstl.COA_LINE_ID = cs.COA_LINE_ID

                          AND cstl.LANGUAGE = 'US'

                        WHERE mh.RULE_ID = 105

                        AND mhd.HIERARCHY_ID = mh.HIERARCHY_ID

                        AND ecs.COA_LINE_ID = mhd.COA_LINE_ID

                        AND cs.COA_LINE_ID = ecs.COA_LINE_ID

                        AND ecs.VALIDATION_TYPE = 'F'

                        AND dim.DIMENSION_ID = mh.DIMENSION_ID

                       

                2015-09-30 12:49:39,174 INFO  [AIF]: EBS Extract Hierarchies Table VS - Populate Dim Hierarchy Stage - END

                2015-09-30 12:49:39,292 INFO  [AIF]: COMM Load Single Dim Hierarchies - Load Single Dim Hierarchies - START

                2015-09-30 12:49:39,292 DEBUG [AIF]:

                        SELECT STEP_NAME

                        ,STATUS

                        FROM AIF_PROCESS_STEPS

                        WHERE PROCESS_ID = 293

                       

                2015-09-30 12:49:39,293 DEBUG [AIF]:

                        SELECT mdd.DIMENSION_ID

                        ,cs.VALUE_SET_ID

                        ,mdd.MEMBER_PREFIX

                        ,mdd.VIEW_FILTER_VALUE

                        ,d.TARGET_DIMENSION_CLASS_NAME

                        ,mdd.ORPHAN_OPTION_CODE

                        ,mdd.ORPHAN_PARENT_MEMBER

                        ,mdd.STAT_OPTION_CODE

                        ,mdd.STAT_PARENT_MEMBER

                        ,d.TARGET_DIMENSION_NAME

                        ,mdd.HIERARCHY_TABLE_NAME

                        ,ad.VALID_FOR_PLAN1 DIM_VALID_FOR_PLAN1

                        ,ad.VALID_FOR_PLAN2 DIM_VALID_FOR_PLAN2

                        ,ad.VALID_FOR_PLAN3 DIM_VALID_FOR_PLAN3

                        ,ad.VALID_FOR_PLAN4 DIM_VALID_FOR_PLAN4

                        ,ad.VALID_FOR_PLAN5 DIM_VALID_FOR_PLAN5

                        ,ad.VALID_FOR_PLAN6 DIM_VALID_FOR_PLAN6

                        ,app.PLAN1_NAME

                        ,app.PLAN2_NAME

                        ,app.PLAN3_NAME

                        ,app.PLAN4_NAME

                        ,app.PLAN5_NAME

                        ,app.PLAN6_NAME

                        ,mdd.MEMBER_AFFIX_TYPE

                        ,mdd.MEMBER_AFFIX_VALUE

                        ,mdd.DATASTORAGE_PARENT_R

                        ,CASE mdd.DATASTORAGE_PARENT_R WHEN 'Y' THEN COALESCE(mdd.DATASTORAGE_PARENT, 'NeverShare') ELSE mdd.DATASTORAGE_PARENT END DATASTORAGE_PARENT

                        ,mdd.DATASTORAGE_R

                        ,CASE mdd.DATASTORAGE_R WHEN 'Y' THEN COALESCE(mdd.DATASTORAGE, 'StoreData') ELSE mdd.DATASTORAGE END DATASTORAGE

                        ,app.METADATA_LOAD_METHOD

                        FROM AIF_MAPPING_RULES mr

                        ,AIF_MAP_DIM_DETAILS_V mdd

                        ,AIF_COA_SEGMENTS cs

                        ,AIF_DIMENSIONS d

                        ,AIF_TARGET_APPLICATIONS app

                        ,AIF_TARGET_APPL_DIMENSIONS ad

                        WHERE mr.RULE_ID = 105

                        AND mdd.RULE_ID = mr.RULE_ID

                        AND mdd.MAPPING_TYPE_CODE = 'SINGLE_SEGMENT'

                        AND mdd.PSEUDO_MAPPING_FLAG = 'N'

                        AND cs.COA_LINE_ID = mdd.COA_LINE_ID1

                        AND d.DIMENSION_ID = mdd.DIMENSION_ID

                        AND app.APPLICATION_ID = mr.APPLICATION_ID

                        AND ad.APPLICATION_ID = app.APPLICATION_ID

                        AND ad.DIMENSION_ID = mdd.DIMENSION_ID

                        AND (

                          app.TARGET_APPLICATION_TYPE = 'EPMA_SHARED'

                          OR d.DIMENSION_ID IN (

                            SELECT maps.DIMENSION_ID

                            FROM AIF_MAP_DIM_DETAILS maps

                            ,AIF_MAP_RULE_LINES lines

                            WHERE lines.RULE_MAP_ID = maps.RULE_MAP_ID

                            AND lines.RULE_ID = mr.RULE_ID

                            AND maps.SHARED_MAPPING_FLAG <> 'Y'

                          )

                        )

                        ORDER BY mdd.DIMENSION_ID

                       

                2015-09-30 12:49:39,296 DEBUG [AIF]:

                          SELECT DISTINCT mh.HIERARCHY_ID

                          ,'' || mh.HIERARCHY_DESC HIERARCHY_DESC

                          ,mhd.STARTING_NODE

                          ,CASE

                            WHEN mhd.STARTING_NODE IS NULL THEN 'Y'

                            ELSE 'N'

                          END TREE_FLAG

                          ,CASE

                            WHEN mhd.TREE_ID IS NULL THEN 0

                            ELSE mhd.TREE_ID

                          END TREE_ID

                          ,CASE

                            WHEN mhd.TREE_VERSION_ID IS NULL THEN 0

                            ELSE mhd.TREE_VERSION_ID

                          END TREE_VERSION_ID

                          ,t.TREE_CODE

                          ,tv.EFFECTIVE_START_DATE TREE_VERSION_DATE

                          ,tvtl.TREE_VERSION_NAME

                          ,mh.BASE_HIERARCHY_FLAG

                          ,mh.MEMBER_AFFIX_TYPE

                          ,mh.MEMBER_AFFIX_VALUE

                          ,mh.VALID_FOR_PLAN1

                          ,mh.VALID_FOR_PLAN2

                          ,mh.VALID_FOR_PLAN3

                          ,mh.VALID_FOR_PLAN4

                          ,mh.VALID_FOR_PLAN5

                          ,mh.VALID_FOR_PLAN6

                          ,mh.SOURCEPLANTYPE

                          ,mh.SOURCEPLANTYPE_R

                          FROM AIF_MAP_HIERARCHIES mh

                          ,AIF_MAP_HIER_DETAILS mhd

                            LEFT OUTER JOIN AIF_TREES_STG t

                              ON t.TREE_ID = mhd.TREE_ID

                            LEFT OUTER JOIN AIF_TREE_VERSIONS_STG tv

                              ON tv.TREE_VERSION_ID = mhd.TREE_VERSION_ID

                            LEFT OUTER JOIN AIF_TREE_VERSIONS_TL_STG tvtl

                              ON tvtl.TREE_VERSION_ID = tv.TREE_VERSION_ID

                              AND tvtl.LANGUAGE = 'US'

                          WHERE mh.RULE_ID = 105

                          AND mh.DIMENSION_ID = 33

                          AND mhd.HIERARCHY_ID = mh.HIERARCHY_ID

                          ORDER BY mh.BASE_HIERARCHY_FLAG DESC

                          ,mh.HIERARCHY_ID

                         

                2015-09-30 12:49:39,298 DEBUG [AIF]:

                          SELECT DISTINCT mh.HIERARCHY_ID

                          ,'' || mh.HIERARCHY_DESC HIERARCHY_DESC

                          ,mhd.STARTING_NODE

                          ,CASE

                            WHEN mhd.STARTING_NODE IS NULL THEN 'Y'

                            ELSE 'N'

                          END TREE_FLAG

                          ,CASE

                            WHEN mhd.TREE_ID IS NULL THEN 0

                            ELSE mhd.TREE_ID

                          END TREE_ID

                          ,CASE

                            WHEN mhd.TREE_VERSION_ID IS NULL THEN 0

                            ELSE mhd.TREE_VERSION_ID

                          END TREE_VERSION_ID

                          ,t.TREE_CODE

                          ,tv.EFFECTIVE_START_DATE TREE_VERSION_DATE

                          ,tvtl.TREE_VERSION_NAME

                          ,mh.BASE_HIERARCHY_FLAG

                          ,mh.MEMBER_AFFIX_TYPE

                          ,mh.MEMBER_AFFIX_VALUE

                          ,mh.VALID_FOR_PLAN1

                          ,mh.VALID_FOR_PLAN2

                          ,mh.VALID_FOR_PLAN3

                          ,mh.VALID_FOR_PLAN4

                          ,mh.VALID_FOR_PLAN5

                          ,mh.VALID_FOR_PLAN6

                          ,mh.SOURCEPLANTYPE

                          ,mh.SOURCEPLANTYPE_R

                          FROM AIF_MAP_HIERARCHIES mh

                          ,AIF_MAP_HIER_DETAILS mhd

                            LEFT OUTER JOIN AIF_TREES_STG t

                              ON t.TREE_ID = mhd.TREE_ID

                            LEFT OUTER JOIN AIF_TREE_VERSIONS_STG tv

                              ON tv.TREE_VERSION_ID = mhd.TREE_VERSION_ID

                            LEFT OUTER JOIN AIF_TREE_VERSIONS_TL_STG tvtl

                              ON tvtl.TREE_VERSION_ID = tv.TREE_VERSION_ID

                              AND tvtl.LANGUAGE = 'US'

                          WHERE mh.RULE_ID = 105

                          AND mh.DIMENSION_ID = 35

                          AND mhd.HIERARCHY_ID = mh.HIERARCHY_ID

                          ORDER BY mh.BASE_HIERARCHY_FLAG DESC

                          ,mh.HIERARCHY_ID

                         

                2015-09-30 12:49:39,300 INFO  [AIF]: COMM Load Single Dim Hierarchies - Load Single Dim Hierarchies - END

                2015-09-30 12:49:39,432 INFO  [AIF]: COMM Load Concat Dim Hierarchies - Load Concat Dim Hierarchies - START

                2015-09-30 12:49:39,432 DEBUG [AIF]:

                          SELECT STEP_NAME

                          ,STATUS

                          FROM AIF_PROCESS_STEPS

                          WHERE PROCESS_ID = 293

                         

                2015-09-30 12:49:39,433 DEBUG [AIF]:

                          SELECT mdd.DIMENSION_ID

                          ,mdd.IMPFLDFIELDNAME

                          ,mdd.MEMBER_AFFIX_TYPE

                          ,mdd.MEMBER_AFFIX_VALUE

                          ,mdd.DATASTORAGE_PARENT_R

                          ,CASE mdd.DATASTORAGE_PARENT_R WHEN 'Y' THEN COALESCE(mdd.DATASTORAGE_PARENT, 'NeverShare') ELSE mdd.DATASTORAGE_PARENT END DATASTORAGE_PARENT

                          ,mdd.DATASTORAGE_R

                          ,CASE mdd.DATASTORAGE_R WHEN 'Y' THEN COALESCE(mdd.DATASTORAGE, 'StoreData') ELSE mdd.DATASTORAGE END DATASTORAGE

                          ,mdd.VIEW_FILTER_VALUE

                          ,d.TARGET_DIMENSION_CLASS_NAME

                          ,mdd.ORPHAN_OPTION_CODE

                          ,mdd.ORPHAN_PARENT_MEMBER

                          ,mdd.STAT_OPTION_CODE

                          ,mdd.STAT_PARENT_MEMBER

                          ,d.TARGET_DIMENSION_NAME

                          ,mdd.HIERARCHY_TABLE_NAME

                          ,ad.VALID_FOR_PLAN1 DIM_VALID_FOR_PLAN1

                          ,ad.VALID_FOR_PLAN2 DIM_VALID_FOR_PLAN2

                          ,ad.VALID_FOR_PLAN3 DIM_VALID_FOR_PLAN3

                          ,ad.VALID_FOR_PLAN4 DIM_VALID_FOR_PLAN4

                          ,ad.VALID_FOR_PLAN5 DIM_VALID_FOR_PLAN5

                          ,ad.VALID_FOR_PLAN5 DIM_VALID_FOR_PLAN6

                          ,app.PLAN1_NAME

                          ,app.PLAN2_NAME

                          ,app.PLAN3_NAME

                          ,app.PLAN4_NAME

                          ,app.PLAN5_NAME

                          ,app.PLAN6_NAME

                          ,app.METADATA_LOAD_METHOD

                          FROM AIF_MAPPING_RULES mr

                          ,AIF_MAP_DIM_DETAILS_V mdd

                          ,AIF_DIMENSIONS d

                          ,AIF_TARGET_APPLICATIONS app

                          ,AIF_TARGET_APPL_DIMENSIONS ad

                          WHERE mr.RULE_ID = 105

                          AND mdd.RULE_ID = mr.RULE_ID

                          AND mdd.MAPPING_TYPE_CODE = 'CONCATE_SEGMENT'

                          AND mdd.PSEUDO_MAPPING_FLAG = 'N'

                          AND d.DIMENSION_ID = mdd.DIMENSION_ID

                          AND app.APPLICATION_ID = mr.APPLICATION_ID

                          AND ad.APPLICATION_ID = app.APPLICATION_ID

                          AND ad.DIMENSION_ID = mdd.DIMENSION_ID

                          AND (

                            app.TARGET_APPLICATION_TYPE = 'EPMA_SHARED'

                            OR d.DIMENSION_ID IN (

                              SELECT maps.DIMENSION_ID

                              FROM AIF_MAP_DIM_DETAILS maps

                              ,AIF_MAP_RULE_LINES lines

                              WHERE lines.RULE_MAP_ID = maps.RULE_MAP_ID

                              AND lines.RULE_ID = mr.RULE_ID

                              AND maps.SHARED_MAPPING_FLAG <> 'Y'

                            )

                          )

                          ORDER BY mdd.DIMENSION_ID

                         

                2015-09-30 12:49:39,434 INFO  [AIF]: COMM Load Concat Dim Hierarchies - Load Concat Dim Hierarchies - END

                2015-09-30 12:49:39,434 DEBUG [AIF]:

                          DELETE FROM AIF_MAP_HIER_COMPONENT_T

                          WHERE LOADID = 293

                         

                2015-09-30 12:49:39,435 DEBUG [AIF]:

                          DELETE FROM AIF_MAP_HIER_CONCAT_T

                          WHERE LOADID = 293

                         

                2015-09-30 12:49:41,968 INFO  [AIF]: COMM Dimension Member Attributes - ICP Attribute Processing - START

                2015-09-30 12:49:41,968 DEBUG [AIF]:

                        SELECT cs.VALUE_SET_ID

                        ,COALESCE(cs.BALANCE_TYPE_FLAG,'N') BALANCE_TYPE_FLAG

                        ,mdd.MEMBER_PREFIX

                        ,mdd.MEMBER_AFFIX_TYPE

                        ,mdd.MEMBER_AFFIX_VALUE

                        ,mdd.ISICP_R

                        ,mdd.ISICP

                        ,mdd.DEFAULT_ICP_MEMBER

                        ,mdd.VIEW_FILTER_VALUE

                        ,(SELECT MIN(icp.VALUE_SET_ID)

                          FROM AIF_COA_SEGMENTS icp

                          WHERE icp.SOURCE_SYSTEM_ID = mr.SOURCE_SYSTEM_ID

                          AND icp.SOURCE_COA_ID = mr.SOURCE_COA_ID

                          AND icp.INTERCOMPANY_TYPE_FLAG = 'Y'

                          AND COALESCE(icp.BALANCE_TYPE_FLAG, 'N') = 'N'

                        ) ICP_VALUE_SET_ID

                        FROM AIF_MAP_DIM_DETAILS_V mdd

                        ,AIF_COA_SEGMENTS cs

                        ,AIF_DIMENSIONS dim

                        ,AIF_MAPPING_RULES mr

                        ,AIF_TARGET_APPLICATIONS app

                        WHERE mdd.RULE_ID = 105

                        AND mdd.MAPPING_TYPE_CODE = 'SINGLE_SEGMENT'

                        AND mr.RULE_ID = mdd.RULE_ID

                        AND app.APPLICATION_ID = mr.APPLICATION_ID

                        AND app.TARGET_APPLICATION_TYPE IN ('HFM','EPMA_SHARED')

                        AND dim.DIMENSION_ID = mdd.DIMENSION_ID

                        AND dim.TARGET_DIMENSION_CLASS_NAME = 'Entity'

                        AND cs.COA_LINE_ID = mdd.COA_LINE_ID1

                       

                2015-09-30 12:49:41,970 DEBUG [AIF]:

                          UPDATE AIF_HS_DIM_MEMBER

                          SET ISICP = CASE 'Y' WHEN 'Y' THEN COALESCE(NULL,'N') ELSE NULL END

                          WHERE DIMENSION = 'ENTITY1'

                          AND LOADID = 293

                         

                            AND NAME IN (

                              SELECT DISTINCT ent.VALUE_NAME

                              FROM AIF_DIM_MEMBERS_STG ent

                              WHERE ent.SOURCE_SYSTEM_ID = 2

                              AND ent.VALUE_SET_ID = 1002470

                            )

                           

                2015-09-30 12:49:41,974 INFO  [AIF]: COMM Dimension Member Attributes - ICP Attribute Processing - END

                2015-09-30 12:49:42,288 INFO  [AIF]: COMM Load IM Tables - Load IM Tables - START

                2015-09-30 12:49:42,289 DEBUG [AIF]:

                      DELETE FROM IM_DIMENSION_ASSOCIATION

                      WHERE I_LOAD_ID < 293

                      AND EXISTS (

                        SELECT 1

                        FROM AIF_PROCESSES p

                        WHERE p.RULE_ID = 105

                        AND p.PROCESS_ID = IM_DIMENSION_ASSOCIATION.I_LOAD_ID

                      )

                     

                2015-09-30 12:49:42,289 DEBUG [AIF]:

                        DELETE FROM IM_DIMENSION

                        WHERE I_LOAD_ID < 293

                        AND EXISTS (

                          SELECT 1

                          FROM AIF_PROCESSES p

                          WHERE p.RULE_ID = 105

                          AND p.PROCESS_ID = IM_DIMENSION.I_LOAD_ID

                        )

                     

                2015-09-30 12:49:42,292 DEBUG [AIF]:

                        DELETE FROM IM_LOAD_INFO

                        WHERE I_LOAD_ID < 293

                        AND EXISTS (

                          SELECT 1

                          FROM AIF_PROCESSES p

                          WHERE p.RULE_ID = 105

                          AND p.PROCESS_ID = IM_LOAD_INFO.I_LOAD_ID

                        )

                     

                2015-09-30 12:49:42,293 DEBUG [AIF]:

                        INSERT INTO IM_LOAD_INFO (

                          I_LOAD_ID

                          ,C_SOURCE_SYSTEM

                          ,C_USER_LAST_UPDATED

                          ,D_DATE_LAST_UPDATED

                          ,C_LAST_UPDATE_LOGIN

                        ) values (293, 'AIF_105', 'admin', CURRENT_TIMESTAMP, 'admin')

                     

                2015-09-30 12:49:42,293 DEBUG [AIF]:

                        INSERT INTO IM_DIMENSION (

                          I_LOAD_ID

                          ,C_DIMENSION_NAME

                          ,C_DIMENSION_CLASS_NAME

                          ,C_MEMBER_TABLE_NAME

                          ,C_HIERARCHY_TABLE_NAME

                          ,C_PROPERTY_ARRAY_TABLE_NAME

                          ,C_DIM_PROPERTY_TABLE_NAME

                        )

                        SELECT 293

                        ,'293'||'_'||dim.TARGET_DIMENSION_NAME_ORG

                        ,dim.TARGET_DIMENSION_CLASS_NAME

                        ,mdd.MEMBER_TABLE_NAME

                        ,mdd.HIERARCHY_TABLE_NAME

                        ,mdd.PROPERTY_ARRAY_TABLE_NAME

                        ,NULL

                        FROM AIF_MAPPING_RULES mr

                        ,AIF_MAP_DIM_DETAILS_V mdd

                        ,AIF_DIMENSIONS dim

                        ,AIF_TARGET_APPLICATIONS app

                        WHERE mr.RULE_ID = 105

                        AND mdd.RULE_ID = mr.RULE_ID

                        AND mdd.MAPPING_TYPE_CODE IN ('SINGLE_SEGMENT','CONCATE_SEGMENT')

                        AND mdd.PSEUDO_MAPPING_FLAG = 'N'

                        AND dim.DIMENSION_ID = mdd.DIMENSION_ID

                        AND app.APPLICATION_ID = mr.APPLICATION_ID

                        AND (

                          app.TARGET_APPLICATION_TYPE = 'EPMA_SHARED'

                          OR dim.DIMENSION_ID IN (

                            SELECT maps.DIMENSION_ID

                            FROM AIF_MAP_DIM_DETAILS maps

                            ,AIF_MAP_RULE_LINES lines

                            WHERE lines.RULE_MAP_ID = maps.RULE_MAP_ID

                            AND lines.RULE_ID = mr.RULE_ID

                            AND maps.SHARED_MAPPING_FLAG <> 'Y'

                          )

                        )

                     

                2015-09-30 12:49:42,295 DEBUG [AIF]:

                        INSERT INTO IM_DIMENSION_ASSOCIATION (

                          I_LOAD_ID

                          ,C_BASE_DIMENSION

                          ,C_PROPERTY

                          ,C_TARGET_DIMENSION

                        )

                        SELECT 293

                        ,'293'||'_'||dim.TARGET_DIMENSION_NAME_ORG

                        ,'Alias'

                        ,alias_dim.TARGET_DIMENSION_NAME_ORG

                        FROM AIF_MAPPING_RULES mr

                        ,AIF_MAP_DIM_DETAILS_V mdd

                        ,AIF_DIMENSIONS dim

                        ,AIF_TARGET_APPLICATIONS app

                        ,AIF_DIMENSIONS alias_dim

                        WHERE mr.RULE_ID = 105

                        AND mdd.RULE_ID = mr.RULE_ID

                        AND mdd.MAPPING_TYPE_CODE IN ('SINGLE_SEGMENT','CONCATE_SEGMENT')

                        AND mdd.PSEUDO_MAPPING_FLAG = 'N'

                        AND dim.DIMENSION_ID = mdd.DIMENSION_ID

                        AND app.APPLICATION_ID = mr.APPLICATION_ID

                        AND (

                          app.TARGET_APPLICATION_TYPE = 'EPMA_SHARED'

                          OR dim.DIMENSION_ID IN (

                            SELECT maps.DIMENSION_ID

                            FROM AIF_MAP_DIM_DETAILS maps

                            ,AIF_MAP_RULE_LINES lines

                            WHERE lines.RULE_MAP_ID = maps.RULE_MAP_ID

                            AND lines.RULE_ID = mr.RULE_ID

                            AND maps.SHARED_MAPPING_FLAG <> 'Y'

                          )

                        )

                        AND alias_dim.DIMENSION_ID = mr.DEFAULT_ALIAS_DIMENSION_ID

                     

                2015-09-30 12:49:42,297 INFO  [AIF]: COMM Load IM Tables - Load IM Tables - END

                2015-09-30 12:49:42,723 DEBUG [AIF]: CommDim.loadMetadata - START

                2015-09-30 12:49:42,725 DEBUG [AIF]: CommDim.getRuleInfo - START

                2015-09-30 12:49:42,728 DEBUG [AIF]:

                        SELECT mr.RULE_ID

                        ,mr.PARTITIONKEY

                        ,part.PARTNAME

                        ,mr.SOURCE_SYSTEM_ID

                        ,ss.SOURCE_SYSTEM_TYPE

                        ,mr.SOURCE_COA_ID

                        ,mr.SOURCE_LEDGER_ID

                        ,l.SOURCE_LEDGER_NAME

                        ,app.APPLICATION_ID

                        ,app.TARGET_APPLICATION_NAME

                        ,app.TARGET_APPLICATION_TYPE

                        ,app.METADATA_LOAD_METHOD

                        ,p.LAST_UPDATED_BY

                        ,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL

                        ,p.EPM_ORACLE_INSTANCE

                        FROM AIF_PROCESSES p

                        INNER JOIN AIF_MAPPING_RULES mr

                          ON mr.RULE_ID = p.RULE_ID

                        INNER JOIN AIF_SOURCE_SYSTEMS ss

                          ON ss.SOURCE_SYSTEM_ID = mr.SOURCE_SYSTEM_ID

                        INNER JOIN AIF_TARGET_APPLICATIONS app

                          ON app.APPLICATION_ID = mr.APPLICATION_ID

                        LEFT OUTER JOIN TPOVPARTITION part

                          ON part.PARTITIONKEY = mr.PARTITIONKEY

                        LEFT OUTER JOIN AIF_COA_LEDGERS l

                          ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

                          AND l.SOURCE_LEDGER_ID = mr.SOURCE_LEDGER_ID

                        WHERE p.PROCESS_ID = 293

                       

                2015-09-30 12:49:42,729 DEBUG [AIF]: {'APPLICATION_ID': 4L, 'SOURCE_SYSTEM_ID': 2L, 'METADATA_LOAD_METHOD': u'EPMA', 'SOURCE_SYSTEM_TYPE': u'EBS_R12', 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\middleware\\user_projects\\epmsystem1', 'TARGET_APPLICATION_NAME': u'APP1', 'LAST_UPDATED_BY': u'admin', 'TARGET_APPLICATION_TYPE': u'HFM', 'SOURCE_COA_ID': 101L, 'PARTITIONKEY': 25L, 'PARTNAME': u'APP1_loc', 'RULE_ID': 105L, 'WEB_SERVICE_URL': u'http://CSVHYP003:6550/aif', 'SOURCE_LEDGER_ID': 1L, 'SOURCE_LEDGER_NAME': u'Vision Operations (USA)'}

                2015-09-30 12:49:42,729 DEBUG [AIF]: CommDim.getRuleInfo - END

                2015-09-30 12:49:42,731 DEBUG [AIF]: AIFUtil.callOdiServlet - START

                2015-09-30 12:49:42,746 DEBUG [AIF]: The registry has been found!!

                2015-09-30 12:49:42,827 INFO  [AIF]: EPMA Web Services URL:http://CSVHYP003:19000/hyperion-bpma-server

                2015-09-30 12:49:42,827 DEBUG [AIF]: Establising a session now ...

                2015-09-30 12:49:42,876 INFO  [AIF]: The session Id is:352b8a06-e67b-d1f4-4482-e822be0b64e2

                2015-09-30 12:49:43,007 ERROR [AIF]: Error encountered

                2015-09-30 12:49:43,008 INFO  [AIF]: [exportMetadataToEPMA: 293 ] End ( javax.xml.rpc.soap.SOAPFaultException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Hyperion.DimensionServer.Interface.Exceptions.LockManagerException: Application 3 not found.

                 

                 

                Server stack trace:

                   at Hyperion.DimensionServer.LockManager.InternalAcquireApplicationLock(LockType type, LockScope libLockScope, LockScope appLockScope, Int32 libraryID, LocateApplicationDelegate locateAppFunc, Application& application, Boolean allowStarvation)

                   at Hyperion.DimensionServer.LockManager.AcquireLock(LockType type, LockScope libLockScope, LockScope appLockScope, ApplicationLocator locator, Application& app, Boolean allowStarvation)

                   at Hyperion.DimensionServer.Proxies.DimensionsProxy.<>c__DisplayClass1.<EnumDimensions>b__0()

                   at Hyperion.DimensionServer.Global.HandleThreadContext(Guid sessionID, ThreadContextDelegate method)

                   at Hyperion.DimensionServer.BaseProxy.HandleAPICall(Guid sessionID, ThreadContextDelegate method)

                   at Hyperion.DimensionServer.Proxies.DimensionsProxy.EnumDimensions(ApplicationLocator locator, String[] dimensionClasses, DimensionType[] dimensionTypes)

                   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

                   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

                 

                 

                Exception rethrown at [0]:

                   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

                   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

                   at Hyperion.DimensionServer.Interface.IDimensions.EnumDimensions(ApplicationLocator locator, String[] dimensionClasses, DimensionType[] dimensionTypes)

                   at Hyperion.DimensionServer.WebServices.Dimensions.EnumDimensions(ApplicationLocator locator, String[] dimensionClasses, DimensionType[] dimensionTypes)

                   --- End of inner exception stack trace --- )

                2015-09-30 12:49:43,018 DEBUG [AIF]: AIFUtil.callOdiServlet - END

                2015-09-30 12:49:43,019 FATAL [AIF]: Error in CommDim.loadMetadata

                Traceback (most recent call last):

                  File "<string>", line 4185, in loadMetadata

                RuntimeError: javax.xml.rpc.soap.SOAPFaultException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Hyperion.DimensionServer.Interface.Exceptions.LockManagerException: Application 3 not found.

                 

                 

                Server stack trace:

                   at Hyperion.DimensionServer.LockManager.InternalAcquireApplicationLock(LockType type, LockScope libLockScope, LockScope appLockScope, Int32 libraryID, LocateApplicationDelegate locateAppFunc, Application& application, Boolean allowStarvation)

                   at Hyperion.DimensionServer.LockManager.AcquireLock(LockType type, LockScope libLockScope, LockScope appLockScope, ApplicationLocator locator, Application& app, Boolean allowStarvation)

                   at Hyperion.DimensionServer.Proxies.DimensionsProxy.<>c__DisplayClass1.<EnumDimensions>b__0()

                   at Hyperion.DimensionServer.Global.HandleThreadContext(Guid sessionID, ThreadContextDelegate method)

                   at Hyperion.DimensionServer.BaseProxy.HandleAPICall(Guid sessionID, ThreadContextDelegate method)

                   at Hyperion.DimensionServer.Proxies.DimensionsProxy.EnumDimensions(ApplicationLocator locator, String[] dimensionClasses, DimensionType[] dimensionTypes)

                   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

                   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

                 

                 

                Exception rethrown at [0]:

                   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

                   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

                   at Hyperion.DimensionServer.Interface.IDimensions.EnumDimensions(ApplicationLocator locator, String[] dimensionClasses, DimensionType[] dimensionTypes)

                   at Hyperion.DimensionServer.WebServices.Dimensions.EnumDimensions(ApplicationLocator locator, String[] dimensionClasses, DimensionType[] dimensionTypes)

                   --- End of inner exception stack trace ---

                 

                 

                2015-09-30 12:49:43,120 FATAL [AIF]: Error in Load Metadata

                2015-09-30 12:49:43,205 INFO  [AIF]: FDMEE Process End, Process ID: 293

                • 5. Re: Error while importing Metadata using FDMEE
                  Chuggans-Oracle

                  That looks to me like the ID for the EPMA app stored in the FDMEE schema no longer matches an existing application ID on the EPMA side. Has the EPMA application been deleted and then recreated in EPMA by any chance? That could definitely cause problems in earlier releases because it caused a mismatch between the application IDs stored by EPMA & FDMEE.

                   

                  It might be worth trying 'Refresh Metadata' on the target application registration screen in FDMEE to see if that can help but I'm not sure if that would update the application ID tbh