CM:Treasury WorkCenter Edit Filter SQL Error-Return: 0 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'OPRCLASS'.

(Doc ID 2315068.1)

Last updated on OCTOBER 09, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


ISSUE:


When we launch the Treasury WorkCenter and try to specify a BU from the Edit Filter link, a SQL error occurs. Through our own troubleshooting we have determined this issue does not occur whenever "No Security" is selected on Setup Financials/Supply Chain > Security > Security Options page. However we require ours to be set as "Permission List Level Security" which results in error.

 
ERROR:
 
  Error Position: 0

  Return: 0 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'OPRCLASS'.

  Statement:

  Original Statement: SELECT DISTINCT BUSINESS_UNIT FROM %Table(SP_BU_FS_NONVW) where BUSINESS_UNIT = 'C3061' AND OPRCLASS = 'Z_PP_PHC_BU_ALL'
PSAPPSRV.8652 (497) 1-1025 10.31.08 0.001000 ErrorReturn-> 277 - SQL Error in Compile. (2,277) FS_FILTER_BUILDER.Configuration.Values.OnExecute Name:DoSaveEdit PCPC:26255 Statement:400

Called from:FSFB_FILTER_VALUES.GBL.FSFB_FLTRVALS.SaveEdit Statement:2

STEPS:
 
1.Turn on security options in: Set Up Financials > Security > Security Options (Make sure you check permission list).
2. Apply Security in Set Up Financials/Supply Chain -> Security -> Apply Security Setups -> Apply Security
3. Main Menu > Cash Management> Treasury WorkCenter > Edit Filter link - receive the above error.

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