My Oracle Support Banner

CX Cloud Mobile: BI Session Variables and Reports Based On Other Report's Data (Doc ID 2341502.1)

Last updated on MAY 11, 2022

Applies to:

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

Goal

In CX Mobile, under Account Analysis, we have added reports. For these reports, the party id should be populated dynamically. We are passing the parameters as mention in the Oracle documentation, but the PartyId is not passed as a parameter.
We have created one report and this report data will be displayed based on another analysis report (consider 2nd analysis). We are passing session variable in 2nd analysis report. But it is giving an error.

Note: The report is working if I hard code the values.

Summary:
1) Customer has a Report 1
2) Report 1 uses Report 2 as sub query
3) The parameter being passed is also set in Report 2
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.