My Oracle Support Banner

EGL9.2: While Configure Filter On GL WorkCenter And Save, Getting "SQL error in DescribeCol. (2,279)" If Row level Security Is Enabled (Doc ID 2131263.1)

Last updated on APRIL 25, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------
While configuring WorkCenter filter & saving encountered an error. 


 
Error:
--------
A fatal PeopleCode SQL Error occurred. Please consult your system log for details.


Message:
SQL error in DescribeCol. (2,279) FS_FILTER_BUILDER.Configuration.Values.OnExecute Name:DoSaveEdit PCPC:21383 Statement:318
Called from FSFB_FILTER_VALUES.GBL.FSFB_FLTRVALS.SaveEdit Statement:2


During the execution of SQL an error occurred in the DescribeCol subroutine.  The preceding message should have described the details of the SQL being executed.


Steps to Replicate:
---------------------

1. Navigate to Enterprise Components > WorkCenter/Dashboards > Configure Filter Values
2. Select add new value
3. Enter Filter ID and User ID
4. Select save

Changes

 Turn on security options in: Set Up Financials > Security > Security Options

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.