E-WF:With >1000 Worklist Items Per User - 'Mark Worked' Marks Wrong Item as 'Worked' (Doc ID 659823.1)

Last updated on SEPTEMBER 24, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 to 8.50 [Release 8.1 to 8.4]
Information in this document applies to any platform.
SPECIFIC TO:
Enterprise PeopleTools Any Release.

This document was previously published as Customer Connection Solution 201061168




Symptoms

When a User has more than 1000 worklist items in their Worklist, the System marks the wrong item as worked, when the Mark Worked button is hit.

We have traced this back to the fact the field used in PeopleCode called UPDATE_ROW_NUM is a 3 digit field.

In the trace below, Mark Worked for row 1010 in the application.

PSAPPSRV.1650752   1-4907   08.50.18    0.010413    4:    PSWORKLIST.BUSPROCNAME = &TEMP;
PSAPPSRV.1650752   1-4908   08.50.18    0.000979    5:    WORKLIST0_WRK.MARK_WORKED_SW = "Y";
PSAPPSRV.1650752   1-4909   08.50.18    0.000021    6:    WORKLIST0_WRK.UPDATE_ROW_NUM = CurrentRowNumber();
PSAPPSRV.1650752   1-4910   08.50.18    0.000034    7:    DoSave();
PSAPPSRV.1650752   1-4911   08.50.18    0.000018    8: End-If;
PSAPPSRV.1650752   1-4912   08.50.18    0.000003    9:
PSAPPSRV.1650752   1-4913   08.50.18    0.049217 Begin Scrolls Buffers before Save
PSAPPSRV.1650752   1-4914   08.50.18    0.000008 Begin level 0[row 0] occcnt=1 activecnt=1 hiddencnt=0 scrlcnt=1 flags=20000 nrec=1
PSAPPSRV.1650752   1-4915   08.50.18    0.000005     RecordsEventSet 00000024  SubscrollsEventSet 0000007d
PSAPPSRV.1650752   1-4916   08.50.18    0.000008 Rec WORKLIST0_WRK (recdefn 3b2313b8) keyrec=-1 keyfield=-1
PSAPPSRV.1650752   1-4917   08.50.18    0.000004     EventSet 00000024
PSAPPSRV.1650752   1-4918   08.50.18    0.000038 Row 0 at 3b125fb8.
PSAPPSRV.1650752   1-4919   08.50.18    0.000009 CRecBuf WORKLIST0_WRK(3b160968) fields=32 work
PSAPPSRV.1650752   1-4920   08.50.18    0.000014   ITEMNAME(3b279500)=''; used
PSAPPSRV.1650752   1-4921   08.50.18    0.000009   WORKLISTNAME(3b279548)='P1_MSS_REGULATORY_TERM_WL'; used
PSAPPSRV.1650752   1-4922   08.50.18    0.000009   DESCR60(3b279560)='Worklist for MMMONTY: Monty, Marni M'; updated used
PSAPPSRV.1650752   1-4923   08.50.18    0.000017   COMMENTSHORT(3b2796b0)=''; used
PSAPPSRV.1650752   1-4924   08.50.18    0.000008   REASSIGN_OPRID(3b2796e0)=''; used
PSAPPSRV.1650752   1-4925   08.50.18    0.000008   UPDATE_ROW_NUM(3b2796f8)='101'; updated used

PeopleCode flagged row 101 as worked since the field can not handle 4 digits.  Line 1-4925 above.

This issue is repeatable as long as we have over 1000 rows. Now if we flag any row less than 1000 the correct row is marked as worked.

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