This discussion is archived
6 Replies Latest reply: Dec 31, 2012 5:50 AM by user1175432 RSS

SSHR - Alert notification

user1175432 Newbie
Currently Being Moderated
Hi,

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?

Thanks in advance.
  • 1. Re: SSHR - Alert notification
    Avinash Journeyer
    Currently Being Moderated
    Hi,

    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)

    Thanks,
    Avinash

    Edited by: Avinash on Dec 27, 2012 12:59 AM
  • 2. Re: SSHR - Alert notification
    user1175432 Newbie
    Currently Being Moderated
    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.
  • 3. Re: SSHR - Alert notification
    Avinash Journeyer
    Currently Being Moderated
    Hi,

    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.


    Thanks,
    Avinash
  • 4. Re: SSHR - Alert notification
    user1175432 Newbie
    Currently Being Moderated
    Thanks again.

    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?
  • 5. Re: SSHR - Alert notification
    Avinash Journeyer
    Currently Being Moderated
    Just check once if "Workflow Background process" is running or not. Status should change.

    Thanks,
    Avinash
  • 6. Re: SSHR - Alert notification
    user1175432 Newbie
    Currently Being Moderated
    Hi Avinash,

    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?

    Thanks.

Legend

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