9 Replies Latest reply: Oct 16, 2012 1:33 PM by Andy Coates RSS

    TASK_GROUP_CodeDimension Failed General Ledger

    968528
      Hi good morning gurus,

      I successfully installed OBIEE 11g, OBI Apps 7.9.6.3, DAC for Financial Analytics in Oracle EBS 12.1.3.

      I also generate parameters and build the execution in execution plan.

      But when I run the full load i got all TASK_GROUP_CodeDimension failed.

      Please help me on this matter.

      Regards,

      Eli
        • 1. Re: TASK_GROUP_CodeDimension Failed General Ledger
          Ahsan Shah
          go to DAC and find out which task in the task group failed. Also, if needed try to get the error log from the Informatica session log. we need more info to assist. This is usually because of issues w the flatfiles for code dimensions.
          • 2. Re: TASK_GROUP_CodeDimension Failed General Ledger
            968528
            Hi,

            This are the Tasks that are failed during Full Load.

            SDE_ORA_CodeDimension_Mrp_Type
            SDE_ORA_CodeDimension_Uom_Code
            SDE_ORA_CodeDimension_Sales_Product_Status
            SDE_ORA_CodeDimension_Fin_Stmt_Item_Names
            SDE_ORA_CodeDimension_Mar_Status
            SDE_ORA_CodeDimension_Cust_Class
            SDE_ORA_CodeDimension_Acct_Doc_Status
            SDE_ORA_CodeDimension_Hazard_Mtl
            SDE_ORA_CodeDimension_Supplier_Payment_Method
            SDE_ORA_CodeDimension_Position_Type
            SDE_ORA_CodeDimension_Disability
            SDE_ORA_CodeDimension_Group_Acct_Names
            SDE_ORA_CodeDimension_Sex
            SDE_ORA_CodeDimension_Cust_Type
            SDE_ORA_CodeDimension_Company
            SDE_ORA_CodeDimension_Bank_Type
            SDE_ORA_CodeDimension_Nationality
            SDE_ORA_CodeDimension_Payterm
            SDE_ORA_CodeDimension_Splr_Acct_Grp
            SDE_ORA_CodeDimension_Bank_Cat
            SDE_ORA_CodeDimension_Language
            SDE_ORA_CodeDimension_Cust_Cat
            SDE_ORA_CodeDimension_Fin_Sub_Names
            SDE_ORA_CodeDimension_Product_Type
            SDE_ORA_CodeDimension_Hr_Lookups
            SIL_HourOfDayDimension


            When I checked the session logs of Informatica it shows that the $$CATEGORY parameter have a null value.

            Thanks for your immediate action regarding my problem.

            Regards,

            Eli
            • 3. Re: TASK_GROUP_CodeDimension Failed General Ledger
              Andy Coates
              So, immediate place to look is whether $$CATEGORY has been set in the DAC. The majority of parameters are set at system level, but some are set at task level too; I recall this dimension has the values set at task level. That being said, I believe that these should be set out-of-the-box.

              Also, do you get anything from the DAC status description? I always look there before going into Informatica logs.

              On the Current Run, go to the Task Group, right-click and choose Details to display the list of tasks within the group. Scroll to the column "Status Description", place your cursor in the cell and click the green check box.

              Finally, is the parameter being referenced within the mapping or within a mapplet inside the mapping? If the latter, make sure you have set the overrideMpltVarWithMapVar property to Yes in the Custom Properties of the PowerCenter Integration Service. This will pass mapping level parameters to any referenced mapplets.

              Please mark if helpful / correct,
              Andy.
              • 4. Re: TASK_GROUP_CodeDimension Failed General Ledger
                884544
                Thanks, It helped me too... 'overrideMpltVarWithMap Var' changed to 'overrideMpltVarWithMapVar' solved the problem(space between Map & Var).
                • 5. Re: TASK_GROUP_CodeDimension Failed General Ledger
                  Andy Coates
                  Glad I could help, please mark my comment as correct and flag the thread as answered.

                  Kind regards,
                  Andy.
                  • 6. Re: TASK_GROUP_CodeDimension Failed General Ledger
                    968528
                    Hi,

                    I solved it by adding MPLT_ADI_CODES. Goto Design -->> Subject Areas (select subject areas (mine is Financial - General Ledger)) -->> Tasks (select tasks name that are failed during execution) and click NEW under parameters tab and and input MPLT_ADI_CODES.$$CATEGORY and copy the existing value of $$CATEGORY. Removed the old $$CATEGORY parameter..

                    Thanks for your help..

                    Regards,

                    Eli
                    • 7. Re: TASK_GROUP_CodeDimension Failed General Ledger
                      Andy Coates
                      Well done Eli, although I would recommend setting the Informatica variable described above otherwise you will encounter this issue for other mappings where parameters are used within mapplets.

                      Please mark if helpful/correct,
                      Andy.
                      • 8. Re: TASK_GROUP_CodeDimension Failed General Ledger
                        968528
                        How can it be that $$CATEGORY pass a value to parameter file and when it execute the workflow in Informatica the the $$CATEGORY now become null. But when you add the mapplet name it will return a value. Is it bug or something.?

                        Thanks,

                        Eli
                        • 9. Re: TASK_GROUP_CodeDimension Failed General Ledger
                          Andy Coates
                          Hi Eli,

                          I am not aware of any such bug. Did you check the aforementioned Informatica property which passes the mapping-level parameter values into the mapplet? If this is not set to Yes, then the mapplet will not be able to "see" the parameter value, which is passed by the DAC to the Informatica mapping.

                          Andy.