My Oracle Support Banner

Duplicate Snapshot Labels Created For View Program Table Instances (Doc ID 2727991.1)

Last updated on NOVEMBER 15, 2020

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.5.3 and later
Information in this document applies to any platform.

Symptoms

A snapshot label is created for the view program table instance using the API call cdr_pub_exe_snapshot.setormovelabel. Two identical labels are created but each of them retrieves a different set of data.


Steps to recreate the issue:

1. Create an Application Area AA_LABELS1, Work Area WA_LABELS1
2. In WA_LABELS1 create a reload table TAB1 and text load LOAD_TAB1
3. Run LOAD_TAB1 twice. The first run loads 3 records with a timestamp 27-Oct-2020 17:07:25
4. The second run loads 5 records with a timestamp 27-Oct-2020 17:11:01
5. Create an Application Area AA_LABELS2, Work Area WA_LABELS2
6. In WA_LABELS2 create a view program VP based on the source table TAB1
7. In WA_LABELS2 create a business area BA_VP
8. Run a program that calls the API apps.cdr_pub_exe_snapshot.setormovelabel with the snapshot timestamp 27-OCT-2020 17:07:25 and a label LOAD1
9. Expected: Snapshot label LOAD1 with the timestamp 27-OCT-2020 17:07:25. It should show the 3 records loaded into TAB1 by the first load.
10. Actual result: Three data currencies are created for the view program table VP:
  (1) 27-OCT-2020 17:34:17
  (2) 27-OCT-2020 17:33:35 (LOAD1)
  (3) 27-OCT-2020 17:33:35 (LOAD1)
11. When browsing the data, selecting the first LOAD1 (3) shows the first 3 records created by the first load of TAB1
12. When browsing the data, selecting the second LOAD1 (2) shows the second 5 records created by the second load of TAB1
13. When browsing the data, selecting data currency (1) shows the second 5 records created by the second load of TAB1

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.