3 Replies Latest reply: Dec 18, 2012 8:55 AM by HakanBiroglu RSS

    Could not create a worklist entry for XXXXXX (18081, 1037)

    873973
      Hello -

      The error mentioned in the "Subject" line is appearing for a particular user only, when he is trying to submit a requisition through special request page in Procurement module of Finance. Checked the approval chain for the user in ROLEXLATOPR and it is not broken. Any idea what could be causing this?
        • 1. Re: Could not create a worklist entry for XXXXXX (18081, 1037)
          HakanBiroglu
          Check to see if Worklist User is enabled on the UserProfile for this is user.

          http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tsec/img/sm_UserProfilesWorkflowPage7f65_tsec7f9b.png

          Also make sure the account is not locked
          http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tsec/img/sm_UserProfilesGeneralPage7f68_tsec7fa1.png
          • 2. Re: Could not create a worklist entry for XXXXXX (18081, 1037)
            873973
            Thanks Hakan for getting back!

            Yes, Worklist User is checked and the user is Active. His Requestor setup as well as User preferences were also setup as it should be, similar to other users. But he alone ends up getting this error.
            • 3. Re: Could not create a worklist entry for XXXXXX (18081, 1037)
              HakanBiroglu
              I assume Worklists Active option is checked in PeopleTools> Workflow> Defaults & Messages> Set Workflow Defaults?

              I see a lot of docs on MOS stating to insert a row in PSWLINSTMAX that are missing rows.
              You might want to check if following statement returns any value
              SELECT 'EOAW_APPROVALS', 'EOAW_ROUTE', A.EVENTNAME, A.ROUTENAME, 1 FROM PSEVENTROUTE A WHERE ACTIVITYNAME = 'EOAW_ROUTE' AND EVENTNAME not in (SELECT EVENTNAME FROM PSWLINSTMAX WHERE BUSPROCNAME='EOAW_APPROVALS' AND ACTIVITYNAME = 'EOAW_ROUTE');

              If so, run following statement to default INSTMAX to 1 for that event.
              INSERT INTO PSWLINSTMAX (BUSPROCNAME, ACTIVITYNAME, EVENTNAME, WORKLISTNAME, INSTMAX) SELECT 'EOAW_APPROVALS', 'EOAW_ROUTE', A.EVENTNAME, A.ROUTENAME, 1 FROM PSEVENTROUTE A WHERE ACTIVITYNAME = 'EOAW_ROUTE' AND EVENTNAME not in (SELECT EVENTNAME FROM PSWLINSTMAX WHERE BUSPROCNAME='EOAW_APPROVALS' AND ACTIVITYNAME = 'EOAW_ROUTE').

              Strange that is does not work for one user. You might think it is user profile bound.
              You might also want to run the process in trace mode to see if you have any additional information which could help fix your issue.

              Hakan