Unable To Apply Snapshot Label On Older Data Currency On LSH View (Doc ID 2226094.1)

Last updated on JANUARY 24, 2017

Applies to:

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

Symptoms

On : 2.4.6 version, Definition Component

ACTUAL BEHAVIOR
---------------
Unable to Apply snapshot label on older data currency on LSH View. They are able to apply labels only for latest currency. Also if table instance is used instead of view, they are able to apply label on older currency without any issue.

EXPECTED BEHAVIOR
-----------------------
Customer is expecting to apply snapshot label on older data currency on LSH view.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create Application area named "snapshot issue"
2. create wa named "src_wa"
3. Create loadset named "LS_AE_SRC"
4. Create table descriptor using AE_SRC.mdd
5. Install the loadset
6. Run the loadset using AE_SRC.csv
7. Go to "src_wa" and apply the snapshot label "TestCase_55_1" on "AE_SRC" table
8. Run "LS_AE_SRC" again by providing AE_NEW.csv. This basically create two data currency on the source
8. Create new workarea named "view_wa"
9. Create View program named "AE_VIEW"
10. Add "AE_SRC" as table descriptor
11. add "select * from ae_src" as source code
12. Install the view program.
13. Run apply_label.sql by providing all argument. This basically attempt apply snapshot on the first data currency which is loaded in step 6.


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