The 'Change Item Status' SQR Report (INS4000) Does Not Update the DT_TIMESTAMP Field in the PS_BU_ITEMS_INV Table

(Doc ID 2098904.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The DT_TIMESTAMP on PS_BU_ITEMS_INV table does not get updated when the 'Change Item Status' SQR Report (INS4000) (navigation: Items, Define Items and Attributes, Change Item Status) changes the Item Status at the Business Unit Item level.

Changes

 

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