BUG 21687281: "VIEW" Table Instances Are Displaying Old Data (Not Refreshing. Data Currency Issue)

(Doc ID 2152306.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.2 and later
Information in this document applies to any platform.

Symptoms

LSH 2.2.2, users are having issues where "VIEW" tables instances are displaying old data (not refreshing with the current information). The areas this behavior is seen in is:

1) "Browse Data" UI
2) GVA Business Area

Users have reported this behavior before to support but under the impression this was fixed. Testing on LSH 2.2., users still see the behavior.

The underlying table instances have the correct data, but when you click "Browse Data" on the View in the TABLE INSTANCE, it is is not pulling the most recent data. Same behavior with the GVA, if you initialize and even initialize several times, it will not pull the most recent data.

* The tables are similarly built tables (same structure)
* View Program has UNION ALL statements

Oracle Tables and Views Load Set --> Staging with Audit Tables (6 tables) --> Separate BAs over each Table Instance --> Program View (which has the Union All statements) --> Program View Table Instances --> GVA BA (over union view)

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