BUG 21687281: "VIEW" Table Instances Are Displaying Old Data (Not Refreshing. Data Currency Issue)
(Doc ID 2152306.1)
Last updated on FEBRUARY 20, 2019
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document