ADF Drill Down Is Not Working From Source To Target BI Report

(Doc ID 2312140.1)

Last updated on SEPTEMBER 28, 2017

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Drill down is not working.

Customer have one source report "Citywise hotel Performance" this is a report based on a physical SQL.

From this report , clicking on Hotel name, user wants to open target report "Monthly Hotel Performance" filtered by this particular Hotel. He has added interaction as Action link calling the other report and Hotel Name is set to prompted in target report
When this report is added to Navigator > Analytics, and user tries to click on Hotel name, nothing happens.

EXPECTED BEHAVIOR
-----------------------
Customer expects to see "Monthly Hotel Performance By City" filtered by Hotel Name

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. For source report create Interaction action link on HotelName, pointing to "Monthly Hotel Performance"
2. In target report, set Hotel Name is prompted
3. Add this report to dashboard or OSC Analytics
4. Clicking on hotel name does not do anything

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use action link on hotel name to filter by hotel

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