This content has been marked as final. Show 6 replies
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)
Edited by: Avinash on Dec 27, 2012 12:59 AM
Thanks Avinash for your reply.
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]
Hope this helps.
I did one more transaciton. The initiator clicked "Submit" button, and still status field of "HR_API_TRANSACTION" shows "W".
Is there any other way we can track the initiator submitted the transaction?
Just check once if "Workflow Background process" is running or not. Status should change.
I ran "Workflow Background Process" also. still the status of this transaction in HR_API_TRANSACTION table is "W". Do I need to link any WF_ tables to get accurate status?
I created a new workflow process "XX_HR_SIT_JSP_PRC" by copying from the standard "HR_SIT_JSP_PRC" and using it in SSHR for approval. Is it because of that?