This discussion is archived
3 Replies Latest reply: Jul 7, 2013 8:46 PM by Nagaraju Cool RSS

'SDE_ORA_WorkforceEventDimension' Status : 'Failed'

05acb3c1-c4a7-4186-964e-ee97eaba3493 Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points