BIAPPS (7.9.6) - HR Analytics ETL Issue & HR Applicant Assignments

MC CU

Hi All

Has anybody come across failures in ETL (TASK_GROUP_Extract_ApplicantEventFact unable to  create Index INDEX W_APPL_EVT_FS_U1) caused by entries in the application database in table irc_assignment_statuses?

Scenario:

HR users are terminating an "application" in the HR front end, using the People form and Other, End Application.

The application is end dated with 30/04/2017

However, the user thinks they made a mistake and so reverses the termination.

At this point they realise that they have not made a mistake (i.e. 30/04/2017 is the correct date to use) so they Terminate the application again, using the date 30/04/2017.

In the table IRC_ASSIGNMENT_STATUSES there will be two rows with a STATUS_CHANGE_DATE of 30-Apr-2017.  The various Infa workflows end up inserting two rows into the Fact Staging Table (W_APPL_EVT_FS), including the date 30-Apr-2017 in the INTEGRATION_ID and DAC can't create the Index and the ETL Fails.

The HR Application allows the end users to make these steps, there are no warnings and they are valid steps, however they cause a failure in the ETL. 

I've raised an SR about it but have had zero feed back from MOS.  I can't believe that this issue hasn't been seen by other organisations/customers - has anybody come across this issue before?

Any help gratefully received!