My Oracle Support Banner

EAR9.0: PS_WS_CONTROL is Populated But There Is No Corresponding Data in PS_WS_ITEM (Doc ID 1078154.1)

Last updated on FEBRUARY 01, 2023

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
*** Implemented Comment re ICE 1931628000 ***



Symptoms

Environment:
------------
FMS 9.0 Production

Statement of Issue:
--------------------
ARUPDATE or FS_STREAMLN process creates data where PS_WS_CONTROL table is populated but there is no corresponding data in PS_WS_ITEM table.

Expected Behavior:
------------------
ARUPDATE or FS_STREAMLN proces should not create data in PS_WS_CONTROL table without corresponding data in PS_WS_ITEM table.

Steps to Replicate:
------------------

1. Select the same item to process in two separate maintenance worksheets
2. Run ARUPDATE or FS_STREAMLN process.

Business Impact:
------------------
There is no business impact of this issue, other than appearance of worksheets that will not process.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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