Error on Termination Workflow Inquiry: "FetchSQL: Failed to Find a Matching SQL Statement for HR_TERM_STEP_APV_EML_BIND, GBL...(2,289)"
Last updated on FEBRUARY 14, 2018
Applies to:PeopleSoft Enterprise HRMS 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms