My Oracle Support Banner

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 :




To view full details, 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 a vibrant support community of peers and Oracle experts.