Error In OTBI Reports While Using VALUEOF(NQ_SESSION.ROLES) With Other Columns From Subject Area

(Doc ID 2411589.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

ON Fusion Applications Release in SaaS Environment:

ERROR MESSAGE
=================

When trying to create a new analysis and adds a session variable to fetch the role list of the current user.

Upon running this analysis , the following error is encountered.

[nQSError: 17001] Oracle Error code: 1704, message: ORA-01704: string literal too long at OCI call OCIStmtExecute. (HY000)

ENVIRONMENT
=================
Oracle SaaS/On-premise Environment
Release : 11.13.18.02.0

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