What Can I Do When a Job Offer is Approved but Shows as Pending Approval

A job offer has been approved but it shows as Pending Approval in Recruiting and as Completed in the Transaction Console.

When a job offer is submitted for approval, a transaction gets created and a SOA instance is initiated. The SOA instance takes some time (usually a few minutes) and during that time, the transaction remains in STUCK status. When the SOA instance gets created, the transaction exits the STUCK state and enters the IN PROGRESS state. The job offer approval process is then started. However, if a user terminates the transaction before the creation of the SOA instance, the job offer remains in the Pending Approval state but in the Transaction Console the job offer shows as Completed.

Best Practices:

• It's recommended to wait at least 60 minutes before going ahead and terminating the transaction in STUCK state.

To fix this situation, follow these steps.

1. Create the profile option HCM_TAC_RESUBMIT_ACTION so users have access to the Resubmit action in the Transaction Console.
   1. In the Setup and Maintenance work area, click Search.
   2. Search for the task Manage Profile Options.
   3. Click the task name.
   4. On the Manage Profile Options page, click Create.
   5. Complete the fields:
      • Profile Option Code: HCM_TAC_RESUBMIT_ACTION
      • Profile Display Name: HCM_TAC_RESUBMIT_ACTION
      • Application: Global Human Resources
      • Module: Global Human Resources
      • Start Date: Pick a date in the past.
   6. Click Save and Close.
   7. On the Manage Profile Options page, select the Enabled and Updatable options for the Site level.
   8. Click Save and Close.
2. Enable the profile option HCM_TAC_RESUBMIT_ACTION.
   1. In the Setup and Maintenance work area, click Search.
   2. Search for the task Manage Administrator Profile Values.
   3. Click the task name.
   4. On the Manage Administrator Profile Values page, search for the profile option code HCM_TAC_RESUBMIT_ACTION.
   5. In the Profile Values section, click the Add icon.
   6. In the Profile Values section, select the Site profile level and enter TRUE in the Profile Value field.
   7. Click Save and Close.
3. Resubmit the transaction in the Transaction Console:
   1. In the Navigator menu, go to Tools, then Transaction Console.
   2. In the Transaction Manager page, search for the transaction ID.
   3. Select the transaction and click the Actions menu.
   4. Select Resubmit to resubmit the transaction.
4. Once the transaction is resubmitted and the issue is resolved, disable the profile option HCM_TAC_RESUBMIT_ACTION.
   1. In the Setup and Maintenance work area, click Search.
   2. Search for the task Manage Administrator Profile Values.
   3. Click the task name.
   4. On the Manage Administrator Profile Values page, search for the profile option code HCM_TAC_RESUBMIT_ACTION.
   5. In the Profile Values section, select the Site profile level and enter FALSE in the Profile Value field.
   6. Click Save and Close.

Results:

To validate that the solution will resolve this situation, run the below query and verify the results include the impacted record.

SELECT
h.transaction_id,
h.object_id ,
d.state ,
d.status ,
o.submission_id ,
RS.SUB_PROCESS_ID
FROM irc_submissions s ,
irc_offers o ,
HRC_TXN_CONSOLE_ENTRY c,
hrc_txn_header h ,
hrc_txn_data d ,
(
SELECT transaction_id,
object_id
FROM
(
SELECT last_h.transaction_id,
last_h.object_id ,
last_h.creation_date ,
RANK() OVER(PARTITION BY last_h.object_id ORDER BY last_h.creation_date DESC
) rnk
FROM fusion.hrc_txn_header last_h
WHERE last_h.object = 'IRC_OFFERS'
)
WHERE rnk = 1
)
last_trx ,
irc_processes_b p,
irc_routing_steps_b rs
WHERE h.TRANSACTION_ID = c.TRANSACTION_ID
AND h.transaction_id = d.transaction_id
AND h.transaction_id = last_trx.transaction_id
AND s.submission_id = o.submission_id
AND o.offer_id = h.object_id
AND h.object = 'IRC_OFFERS'
AND s.current_state_id = 1021
AND s.process_id = p.process_id
AND rs.process_id = p.process_id
AND rs.phase_id = 14
AND rs.step_status = 'ACTIVE'
AND c.status_category = 'COMPLETED'