Approving Annual Leave via Replying To Email Notification Error: Please Use Only the Suggested Values, Making Sure They Are Enclosed Within Quotes (for Example "", "", and So On) (Doc ID 2724894.1)

Last updated on NOVEMBER 01, 2024

Applies to:

Symptoms

Approving annual leave via replying to email notifications using Outlook after the Oracle Cloud Integration (OCI) migration
fails with the following error:

ERROR
-----------------------
Warning: Your previous response to this message was invalid (see error message below). Please resubmit your response.
Error Message: ORA-04061: existing state of has been invalidated ORA-04061: existing state of has been invalidated
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package "APPS.HR_GENERAL" has been invalidated
ORA-04065: not executed, altered or dropped package "APPS.HR_GENERAL"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HR_GENERAL"
ORA-06512: at "APPS.PQH_SS_APPROVAL_HISTORY_WHO", line 5
ORA-04088: error during execution of trigger 'APPS.PQH_SS_APPROVAL_HISTORY_WH

Value Found: None
Remarks: Please use only the suggested values, making sure they are enclosed within quotes (For example "", "", and so on)


STEPS
-----------------------

1. An employee submits an annual leave request.
2. A notification is sent to the employee and their manager
3. Manager can approve the annual leave through Manager Self Service successfully.
4. Manger can approve the annual leave by clicking on the “Approve” link in the email notification. This is not working.
    The error occurs with the bounce back email following step 4.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.