2 Replies Latest reply: Jul 28, 2014 2:14 AM by User538247 RSS

    OBIA 11.1.1.7.1 HR Payroll balances not getting populated

    User538247

      Hi,

       

      I did configuration for OBIA 11.1.1.7.1 HR analytics but HR PAYROLL reports are not showing any data. All 4 tables got populated data

      W_PAY_BALANCE_D_TL_map,W_PAY_BALANCE_MAP_D_map,W_PAY_BALANCE_MAP_D ,W_PAY_RUN_BAL_DTL_F but this payroll balance table is not getting populated

      W_PAY_RUN_BAL_F

       

       

      i have already performed Functional Configuration Task Reference ---

      B.2.129 Manage Domains and Member Mappings for Payroll Balance Dimension

       

      Pls guide

       

      Thanks,

        • 1. Re: OBIA 11.1.1.7.1 HR Payroll balances not getting populated
          Ahsan Shah

          Trace back to the ETLs to see if the SDE loads to the Staging tables for the PAYROLL Facts are getting populated.  If not, you need to run the SQL to see what conditions are causing the extarct to fail. 

          • 2. Re: OBIA 11.1.1.7.1 HR Payroll balances not getting populated
            User538247

            Hi Ahsan,

             

            Following SQL from ODI is failing on condition of  (FCT.BALANCE_WID =BMAP.BALANCE_WID). What is the functional meaning of this SQL?  Any idea why this condition failing?

             

             

             

            SELECT *

            FROM

              (

              /* Subselect from PLP_PayrollRunBalanceFact.W_PAY_RUN_BAL_F_SQ_W_PAY_RUN_BAL_F.EVQ

              */

              SELECT DISTINCT CHG.ASSIGNMENT_INTEGRATION_ID ASSIGNMENT_INTEGRATION_ID,

                CHG.BALANCE_DT BALANCE_DT,

                CHG.DATASOURCE_NUM_ID DATASOURCE_NUM_ID,

                CHG.PAY_REL_INTEGRATION_ID PAY_REL_INTEGRATION_ID

              FROM BIAPPS11G_DW.W_PAY_RUN_BAL_DTL_F CHG

              WHERE (1 =1)

              ) EVQ,

              BIAPPS11G_DW.W_PAY_RUN_BAL_DTL_F FCT,

              BIAPPS11G_DW.W_PAY_BALANCE_MAP_D BMAP

            WHERE (1                          =1)

            AND (EVQ.ASSIGNMENT_INTEGRATION_ID=FCT.ASSIGNMENT_INTEGRATION_ID)

               AND (EVQ.BALANCE_DT               =FCT.BALANCE_DT)

               AND  (EVQ.DATASOURCE_NUM_ID        =FCT.DATASOURCE_NUM_ID AND EVQ.PAY_REL_INTEGRATION_ID =FCT.PAY_REL_INTEGRATION_ID)

            --AND (FCT.BALANCE_WID =BMAP.BALANCE_WID)

            AND (FCT.DELETE_FLG              <>'Y')