Integer Parameter For BIP Report Is Changing To Comma Separated String (Doc ID 2236025.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Integer parameter for the fusion report is changing to comma separated string

Customer has an integer parameter that is being changed into a comma string
for eg. 300000003229726 becomes 3,0,0,0,0,0,0,0,3,2,2,9,7,2,6..

They are calling the BI Report link as below:
https://<<URL>>/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FAuditDetailReport.xdo&bipParams={"_xmode":"2","_xpf":"","_xpt":"0","_xdo":"%2FCustom%2FAuditDetailReport.xdo","_paramsXDO_ESTIMATE_XML_DATA_SIZE":"off","_paramsXDO_GEN_SQL_EXPLAIN_PLAN":"off","_paramsXDO_DM_DEBUG_FLAG":"off","_paramsP_RFA_Site_Id":"300000003229726","_xt":"AuditDetailReport","_xf":"analyze","_xana":"view"}
 

EXPECTED BEHAVIOR
-----------------------
Integer parameter should not be changed to a comma separated string.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call a BIP Report link as above.
Observe that the integer parameter is being changed to a comma separated string.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot call a BIP Report link.

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