SQL Error While Clicking on Approval Tile From Homepage on MS SQL Server Environment

(Doc ID 2372869.1)

Last updated on MARCH 13, 2018

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

SQL error while clicking on Approval tile from homepage.

Steps to reproduce the issue:

1. Login as VP1
2. Click Fluid Home
3. Click Employee Self Service fluid homepage
4. Click Approvals tile
5. Page loads but throwing SQL error.

Error:

A SQL error occurred. Please consult your system log for details
Click OK
Get below error:
A fatal PeopleCode SQL error occurred. Please consult your system log for details.

Error from log file:

Error Position: 0

  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type varchar to numeric. (SQLSTATE 37000) 8114

  Statement: SELECT FILL.BUSINESS_UNIT,FILL.AUC_PLAN_ID,FILL.AUC_VERSION,FILL.AUC_PLAN_STATUS,FILL.AUC_PLAN_NAME,FILL.FINAL_SPEND,FILL.BASELINE_SPEND,FILL.BASE_CURR_CD,FILL.FINAL_CURR_CD,FILL.FIELD2,FILL.FIELD3,FILL.DESCR100A,FILL.DESCR100 FROM PS_AUC_PLN_SUMMARY FILL , PS_AUC_PLAN_APPR XREF, PS_EOAW_SUMMARY SUMM WHERE XREF.AUC_PLAN_ID = FILL.AUC_PLAN_ID AND XREF.AUC_VERSION = FILL.AUC_VERSION AND XREF.BUSINESS_UNIT = FILL.BUSINESS_UNIT AND XREF.EOAWPRCS_ID = SUMM.EOAWPRCS_ID AND XREF.EOAWTHREAD_ID = SUMM.EOAWTHREAD_ID AND SUMM.EOAWTHREAD_ID = SUMM.EOAWPARENT_THREAD AND EXISTS (SELECT 'X' FROM PS_EOAW_SUMM_DTL DTL WHERE DTL.EOAWPARENT_THREAD = SUMM.EOAWTHREAD_ID AND DTL.EOAWPRCS_ID = SUMM.EOAWPRCS_ID AND DTL.EOAWAPPROVER_OPRID = 'VP1' AND DTL.EOAWUSTEP_STATUS IN ('P', 'H'))

  Original Statement: %SelectAll(:1 FILL) , PS_AUC_PLAN_APPR XREF, PS_EOAW_SUMMARY SUMM WHERE XREF.AUC_PLAN_ID = fill.AUC_PLAN_ID AND XREF.AUC_VERSION = fill.AUC_VERSION AND XREF.BUSINESS_UNIT = fill.BUSINESS_UNIT AND XREF.EOAWPRCS_ID = SUMM.EOAWPRCS_ID AND XREF.EOAWTHREAD_ID = SUMM.EOAWTHREAD_ID AND SUMM.EOAWTHREAD_ID = SUMM.EOAWPARENT_THREAD AND EXISTS (SELECT 'X' FROM PS_EOAW_SUMM_DTL DTL WHERE DTL.EOAWPARENT_THREAD = SUMM.EOAWTHREAD_ID AND DTL.EOAWPRCS_ID = SUMM.EOAWPRCS_ID AND DTL.EOAWAPPROVER_OPRID = 'VP1' AND DTL.EOAWUSTEP_STATUS IN ('P', 'H'))
PSAPPSRV.4376 (9) 1-2 13.38.44 0.000000 Exception happend in CScrollObjRef::Fill method(), pszWhere=, PS_AUC_PLAN_APPR XREF, PS_EOAW_SUMMARY SUMM WHERE XREF.AUC_PLAN_ID = fill.AUC_PLAN_ID AND XREF.AUC_VERSION = fill.AUC_VERSION AND XREF.BUSINESS_UNIT = fill.BUSINESS_UNIT AND XREF.EOAWPRCS_ID = SUMM.EOAWPRCS_ID AND XREF.EOAWTHREAD_ID = SUMM.EOAWTHREAD_ID AND SUMM.EOAWTHREAD_ID = SUMM.EOAWPARENT_THREAD AND EXISTS (SELECT 'X' FROM PS_EOAW_SUMM_DTL DTL WHERE DTL.EOAWPARENT_THREAD = SUMM.EOAWTHREAD_ID AND DTL.EOAWPRCS_ID = SUMM.EOAWPRCS_ID AND DTL.EOAWAPPROVER_OPRID = 'VP1' AND DTL.EOAWUSTEP_STATUS IN ('P', 'H'))
PSAPPSRV.4376 (19) 1-3 13.39.07 23.812000 SQL error. Function: Rowset.Fill

Cause

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