3 Replies Latest reply: Jul 7, 2013 10:46 PM by Nagaraju Cool RSS

    'SDE_ORA_WorkforceEventDimension' Status : 'Failed'

    1020987

      DAC complete run for process 'ON HRA R12.1.2 Plan for near to a year but this few days process hits failed session on

       

      'SDE_ORA_WorkforceEventDimension'.

       

       

       

       

       

       

       

      ::: CAUSE :::
      MESSAGE:::Error while execution : CREATE UNIQUE INDEX
      W_WRKFC_EVENT_TYPE_DS_U1
      ON
      W_WRKFC_EVENT_TYPE_DS

       

       

      Further troubleshoot, found that source table: W_WRKFC_EVT_FS appear to have 1 or 0 in column ASG_START_EVENT_IND.

      Also,

      1. In mplt_BC_ORA_WorkforceEventDimension, SQL query get few columns from source table W_WRKFC_EVT_FS include ASG_START_EVENT_IND

      2. In mplt_SA_ORA_WorkforceEventDimension, no dependency found on ASG_START_EVENT_IND to insert into target table W_WRKFC_EVENT_TYPE_DS

      3. This column not exist in target table: W_WRKFC_EVENT_TYPE_DS

       

      Maybe, I need to know natural of column ASG_START_EVENT_IND and why having value 1 or 0 value.

      Curious, why no dependency found on ASG_START_EVENT_IND to insert into target table W_WRKFC_EVENT_TYPE_DS but during mapplet mplt_BC_ORA_WorkforceEventDimension, SQL query still get column that having no dependency to insert to target table.

       

       

      Please advise.