How to keep track of old MSS Transaction Status
Hello,
I'm trying to keep track old MSS transactions which are no longer available in WF table.
I'm could not find any table that store the MSS status; whether the MSS is completed (update is applied) or the MSS was force cancelled.
There are a few kind of scenarios:
1. MSS approval completed; update applied in HR table.
2. MSS approval completed; update failed due to system error (i.e ORA-01403: no data found; Future-dated changes; etc)
- the WF is cancelled (as Reject option is not applicable) and cleared related WFs (hr_api_transactions)
3. MSS approval not complete; update not applied; WF rejected.