Notifications

13 views

Description

List report shared across several users display different columns for each and does not match the selected slush bucket from "Choose Columns"

ISSUE DESCRIPTION:

Issue1:

1. On instance, Navigate to Reports -> View / Run

2. Open list report causing the issue

3. Impersonate as User1, refresh the report from Step2. Observe the set of columns displayed in the report

4. Impersonate as User2, refresh the report from Step2. Observe the set of columns displayed in the report

5. It is observed that the displayed columns from Step 3 and Step 4 are different for the same report

Issue2:

1. Also, on report -> Click "Choose columns" under Configure tab

2. Changing columns in the "Selected" slush bucket do not reflect in the report

 

Release or Environment

All release versions

Cause

When a report is created, two entries are made in the sys_ui_view table - one view with the name temp. Both the views has a list section , which contains the table name on which the report is run.

TROUBLESHOOTING:

1. On instance, navigate to sys_ui_view.LIST

2. Under Name field, lookup with the SysID of the report (Ex: RPT25f32c0647a0300042bd757f2ede276c)

3. Observe "user" field for several views created/updated by different users 

4. Access the record created by the affected user. Under "Lists" tab - open the record to see the list of columns for that user's view

5. Any changes made to these columns would reflect the report view for the affected user (mentioned under "user" field)

Resolution

WORKAROUND:

As affected user,

1. Navigate to Report --> View/Run

2. Open the list report where the issue is observed

3. Drill down to the list view by clicking one of the grouped records in the list report

4. Click the Settings (gear icon) --> Move the required columns from Available to Selected slush bucket

5. Refresh the pages Report and List view

 

TO RESOLVE:

1. On instance, navigate to sys_ui_view.LIST

2. Under Name field, lookup with the SysID of the report (Example: RPT25f32c0647a0300042bd757f2ede276c)

3. Observe several views created/updated by different users

4. Access the record created by the affected user.

5. Move the user field to empty

6. Refresh the report and list view

Article Information

Last Updated:2020-05-08 09:20:43
Published:2020-05-08