Error "Invalid column name 'REQUEST_TYPE'." when Creating a MSR and ChartField Security Has Been Enabled for Inventory (Doc ID 1679962.1)

Last updated on AUGUST 04, 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 below error occurs when attempting to create/update a Material Stock Request (MSR) (navigation: Inventory, Fulfill Stock Orders, Stock Requests, Create/Update Stock Request) and ChartField Security has been enabled for Inventory (navigation: Set Up Financials/Supply Chain, Security, ChartField Security, Register Components):

SQL error. Function: SQLExec
Error Position: 0
Return: Invalid column name 'REQUEST_TYPE'.

 

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