My Oracle Support Banner

E1: WRKFLW: Enhancement for Workflow Process Instance Tables (F98860, F98865) to Capture the Approver User ID, Workflow Approval Program ID and Workstation ID in the USER, PID and JOBN Columns (Doc ID 2902054.1)

Last updated on OCTOBER 11, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


DISCLAIMER: In the images, examples, video and/or the attached document,  user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database.  Any similarity  to actual companies or actual persons, living or dead, is purely  coincidental and is in no way intentional on the part of Oracle.

Currently, Workflow Process Instance table (F98860) and Workflow Task Instance table (F98865) are not updated with the workflow resource User ID, Program ID and the workflow resource Workstation ID.



Process Task Monitor application (P98860)

Two records were updated by Carolina (workflow approver) on 9/30/2022 as shown in the P98860 application.


Workflow Process Instance Table (F98860)

The F98860 table shows the correct date updated (PIUPMJ) but the workflow resource User ID (PIUSER), Program ID (PIPID) and Workstation ID (PIJOBN) columns are not updated with the workflow resource User ID,  Program ID and the Workstation ID. The PIUSER column is only updated with the workflow originator resource User ID but not updated with the subsequent workflow resource user id.


Workflow Task Instance Table (F98865)

The F98865 table columns (AIUSER, AIPID and AIJOBN columns) are currently updated with the Workflow Kernel User ID, Workflow Kernel Process ID and the Enterprise Server Machine name for all of the workflow tasks. The workflow resource User ID, program ID and workflow resource workstation ID are not updated.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.