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 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

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.