I am using a SIT in SSHR which is routing for approval. Suppose, if the initiator clicked "Save for Later" button with the required information, a record is inserted into HR_API_TRANSACTIONS and other two HR_API_ tables.
Based on the record insertion in HR_API_TRANSACTION table, I am sending an alert to some employees. The alert is fired even the initiator clicked "Save for Later" button instead of "Submit" button.
How can I trigger an alert only after the initiator clicked "Submit" button?
Please check the table HR_API_TRANSACTIONS there is a column called Status. As per my knowledge the entry W is for working/Saved for letter.
You can cross check this again by placing any transaction in saved for letter status.
If you want this only for Submit then the correct status should be S (Pending for approval)
I tried a transaction now. Initiator clicked "Submit" button and the next approver has received a notification. I checked HR_API_TRANSACTION table. It still shows "W" instead of other status in this transaction.
Here is the meaning of different values in the column:-
D - Deleted
C - Cancelled
E - Error
RI - Return for Correction
RIS - Return for Correction + Save For Later
S - Save for Later
W - Review page
Y - Pending Approval
YS - Pending Approval + Save for Later
Source :- Metalink note, What is the Meaning of Statuses in HR_API_TRANSACTIONS Table? [ID 438346.1]