BUG 21687281: "VIEW" Table Instances Are Displaying Old Data (Not Refreshing. Data Currency Issue)
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.
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)
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