The 'Item Status Change' SQR Report (INS4000) Is Not Inactivating Items Associated to Historical Version Contracts. Exceptions against the PS_CNTRCT_LINE Table Are Issued. (Doc ID 2145517.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

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

Symptoms

The 'Item Status Change' SQR Report (INS4000) is not inactivating Items associated to historical Version Contracts. An Item Status Change Exception is issued against the PS_CNTRCT_LINE table. The issue occurs when a Contract for the Item has several Versions and the last Version has been cancelled.

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