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:

Symptoms

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.

EXAMPLE OF A STANDARD WORKFLOW PROCESS - CREDLIMIT

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.

Changes

Cause

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