My Oracle Support Banner

'PTVs NOT enabled' Error Generated when Source Code has Static Program Reference (Doc ID 2656620.1)

Last updated on APRIL 14, 2020

Applies to:

Oracle Life Sciences Data Hub - Version 2.5.0 to 2.5.0 [Release 2.5.0]
Information in this document applies to any platform.


On Oracle Life Sciences Data Hub (LSH) 2.5.0 version,

When attempting to access the data from a View table when source code has static program reference,
the following error occurs if browsing data from LSH UI:


Next attempts of accessing data from the View are completed successfully without errors.

The issue can be reproduced with the following steps:
1. Create a table in DB CODE_LIST_GENDER (code VARCHAR2(1), code_value VARCHAR2(100)).
2. Load values like ('F','Female') , ('M','Male') , ('O','Other').
3. From LSH, create Domain (DM1), Application area (AA1), Work area (WA1).
4. Create a Load Set as Oracle Table or Views.
5. Add the Remote Location details for the DB.
6. Create Table Descriptor code list table.
7. Create Table Instance using Table Descriptor.
8. Go to Table Instance and update it as 'Create Table as View'.
9. Install Load Set and table.
10. Create a program PRG1.
11. Add Table Instance from step 8 as a source table.
12. Create source code for the program instance having a function (pkg_get_data.fn_get_data) that accepts code and returns code value (using the DB table created above).
13. Create a table ('SUBJECT_DETAILS' should have one column for gender) and a Load Set (LS1) to load data into the same table.
14. Install the Work Area.
15. Load the data into the table using Load Set (LS1).
16. Create new Application area (AA2), Work Area (WA2).
17. Create view program (SUBJECT_DETAILS_V).
18. Add table descriptor from SUBJECT_DETAILS instance.
19. Add view source code using above LSH table SUBJECT_DETAILS. For column gender replace with pkg_get_data.fn_get_data("GENDER").
20. Add PRG1 as static reference as secondary source code.
21. Install the Work Area.
22. After install try to access view table (browse data).
     Error is shown in UI. Try to browse again. It works.
23. Create Business Area (BA_SUBJECT_DETAILS_V) and add view table SUBJECT_DETAILS_V as a Table Descriptor.
24. Install Business Area.
25. Initialize BA and try to access the table "SELECT * FROM BA_SUBJECT_DETAILS_V.SUBJECT_DETAILS_V;"
     Query fails first time. Second execution attempt fetches the data.


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

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