Unable To Open ITEM Tree For Any Edits for ITEMS Trees That Are Converted To Release 9.1 (Doc ID 1532121.1)

Last updated on AUGUST 08, 2014

Applies to:

PeopleSoft Enterprise SCM Catalog Management - Version 9.1 and later
Information in this document applies to any platform.

Goal

Users are unable to edit Item Trees for trees that were upgraded from prior release to release 9.1. There seems to be an issue with a change on the ITM_CAT_TBL. In release 9.1 the ITM_CAT_TBL has DESCR60, but in previous release the table used DESCR field. This is causing a database rollback when trying to open the tree for editing.
 

Solution

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