My Oracle Support Banner

Error on Termination Workflow Inquiry: "FetchSQL: Failed to Find a Matching SQL Statement for HR_TERM_STEP_APV_EML_BIND, GBL...(2,289)" (Doc ID 1905532.1)

Last updated on SEPTEMBER 26, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Steps to Replicate

Step 1: In 9.2 Demo, Login as a Manager (example Betty Locherty) and Navigate to Manager Self Service > Job and Personal Information > Termination Employee. Then Select an Employee and Submit the request to Terminate him/her.
Step 2: Navigate to Main Menu > Worklist > Worklist. On the Worklist Filters, filter by Termination CI Status Msgs and pick the termination line item that you had requested in the earlier step.
Step 3: In the Workflow Inquiry page that opens up, select “Update Status” for the line item that requires Administrator Action.
Step 4: On the Terminate Employee page, select the 2nd radio button that says, “Select this option to approve the transaction. You will be required to manually update the database.“ Then, click Save. The below error occurs.

Approval Processing (6605,610)

Selecting "Yes" will change the status to "Success". You must go to the employee's record to manually update the employee's record. Selecting "No" will cancel your approval and the status will remain "Administrator Action Required."
And after clicking “Yes” to the above error, here’s another error:

FetchSQL: Failed to find a matching SQL statement for HR_TERM_STEP_APV_EML_BIND, GBL, 2, 2014-02-12. (2,289) EOAW_CORE.NotificationManager.OnExecute Name:LoadTemplateData PCPC:2415 Statement:58
Called from:EOAW_CORE.NotificationManager.OnExecute Name:Notify Statement:116
Called from:HMAF_AWE.WRAPPERS.NotificationManager.OnExecute Name:Notify Statement:6
Called from:HR_TRANSACTIONS.NotifyOriginator.OnExecute Name:NotifyOrigSuccess Statement:52
Called from:WF_EE_TERMINATE.GBL.SavePostChange Stat

The requested SQL statement could not be found.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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