E1: GRID: When Setting UDO Security In P00950, SQL Exception Occurred: Invalid Column Name: 'WSWOBNM'

(Doc ID 2369505.1)

Last updated on APRIL 30, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Goal

E1: 9.1
TR: 9.2.2.1


When reviewing the F00950W table, there were no records in it. After regenerating the table, the customer was then able to enter a UDO action security record.

Note: Regenerating the table will remove all records and should only be done when the table is empty or when the records are corrupt.  Therefore if there is data in the table, first make a backup before doing anything.

JAS_MSG346:L JAS database failure: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid column name 'WSWOBNM'.

 

Error Shown below:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

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