Report Manager FSG Drilldown All Account Balances Screen Shows Accounts With No Activity (Doc ID 1398213.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Report Manager - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Create view with "Display Accounts With No Activity = No", 'Apply' and Re-render account balances still shows accounts with No Activity.

Customer has applied the <Patch 10059869> for the following issue
-----------------------------------------------------------------------------------------------
1. Description
Drill from report manager is presenting the user with accounts with zero and non-zero activity by default.

2. Resolution
By default, drill will present the user with accounts with zero and non-zero activity.Later, user can select
Yes/No from LOV and click on Go button to retrieve the records
--------------------------------------------------------------------------------------------------------

After the above patch is applied, Drilldown from Report Manager excel output takes you to "Drill All Account Balances" screen. Click 'Personalize' and create view with "Display Accounts With No Activity = No". 'Apply' and Re-render account balances still shows accounts with No Activity.

Steps to Reproduce
Generate Report Manager output using seeded Drilldown template. Open report using excel and drilldown thus initiating the "Drill All Account Balances" screen. Click 'Personalize' and create a personalized View that indicates "Display Accounts With No Activity = No". Apply and use that View to render results - find that results include Account with No Activity even though the view is defined Not to.


- Business Impact -
Inefficiency in users having the pour through a high volume of Inactive accounts to find the results that are looking for.

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