PC: SQLExec Function Fails When More than 200 Rows are Returned Using ChartField

(Doc ID 2395741.1)

Last updated on MAY 07, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, PeopleCode

When attempting to create a purchase order ( Running Main Menu > eProcurement > Requisition to create a PO),
the following error occurs.

ERROR
-----------------------
28715 10.20.11 0.000003 22: SQLExec("Select 'x' from ps_" | &EDITTABLE | " a where a.setid = :1 and a." | &CHARTFIELD | " = :2", &SETID, &VALUE, &TEMP);
PSAPPSRV.7864764 (6880) 1-28716 10.20.11 0.000044 Cur#1.7864764.FSDEV856 RC=0 Dur=0.000012 COM Stmt=SELECT 'x' from ps_PROJ_ACTV_VW a where a.setid = :1 and a.ACTIVITY_ID = :2
PSAPPSRV.7864764 (6880) 1-28717 10.20.11 0.000003 Cur#1.7864764.FSDEV856 RC=0 Dur=0.000000 Bind-1 type=2 length=5 value=SHARE
PSAPPSRV.7864764 (6880) 1-28718 10.20.11 0.000002 Cur#1.7864764.FSDEV856 RC=0 Dur=0.000000 Bind-2 type=2 length=15 value=000000000000001
PSAPPSRV.7864764 (6880) 1-28719 10.20.11 0.002462 Cur#1.7864764.FSDEV856 RC=1 Dur=0.000000 Fetch
PSAPPSRV.7864764 (6880) 1-28720 10.20.11 0.000008 23: Break;
PSAPPSRV.7864764 (6880) 1-28721 10.20.11 0.000001 30: If &TEMP = "" Then
PSAPPSRV.7864764 (6880) 1-28722 10.20.11 0.000002 31: &STATUS = "E"
PSAPPSRV.7864764 (6880) 1-28723 10.20.11 0.000002 32: End-If;
PSAPPSRV.7864764 (6880) 1-28724 10.20.11 0.000000 33: End-Function;
PSAPPSRV.7864764 (6880) 1-28725 10.20.11 0.000000 return stack:
PSAPPSRV.7864764 (6880) 1-28726 10.20.11 0.000004 Str[11]=ACTIVITY_ID
PSAPPSRV.7864764 (6880) 1-28727 10.20.11 0.000003 Str[15]=000000000000001
PSAPPSRV.7864764 (6880) 1-28728 10.20.11 0.000004 Temp=#25 Value[12]=PROJ_ACTV_VW
PSAPPSRV.7864764 (6880) 1-28729 10.20.11 0.000002 Str[5]=TMC01
PSAPPSRV.7864764 (6880) 1-28730 10.20.11 0.000003 Date=2018-04-10
PSAPPSRV.7864764 (6880) 1-28731 10.20.11 0.000003 Temp=#26 Value[1]=E
PSAPPSRV.7864764 (6880) 1-28732 10.20.11 0.000006 <<< end-ext Nest=04 edit_chartfield FUNCLIB_FS.EDIT_CHARTFIELD.FieldFormula Dur=0.002858 CPU=0.000000 Cycles=63
PSAPPSRV.7864764 (6880) 1-28733 10.20.11 0.000003 41: &CF_STATUS = &STATUS;
PSAPPSRV.7864764 (6880) 1-28734 10.20.11 0.000002 42: %This.EvokeCFStatusMessage();
PSAPPSRV.7864764 (6880) 1-28735 10.20.11 0.000005 call method SCM_PO:Common:ChartFields.EvokeCFStatusMessage #params=2
PSAPPSRV.7864764 (6880) 1-28736 10.20.11 0.000003 11: method EvokeCFStatusMessage
PSAPPSRV.7864764 (6880) 1-28737 10.20.11 0.000001 12: If &CF_STATUS = "E" Then
PSAPPSRV.7864764 (6880) 1-28738 10.20.11 0.000001 13: &EditErrorType = "Y";
PSAPPSRV.7864764 (6880) 1-28739 10.20.11 0.000002 14: MessageBox(48, MsgGetText(10207, 23, "Application Message"), 10200, 294, "%1 %2 is invalid.", &ChartField, &Value)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Main Menu > eProcurement > Requisition to create a PO
2. Enter values
3. Click on Save

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create PO.

Changes

 

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