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 and later
Information in this document applies to any platform.


ON Fusion Applications Release in SaaS Environment:


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)

Oracle SaaS/On-premise Environment
Release :




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