Unable to Submit the Program in Real Mode when a Program View is Added as a Source Table Descriptor (Doc ID 2047075.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On Oracle Life Sciences Data Hub (LSH) 2.2.0.14,

ACTUAL BEHAVIOR
---------------
Users are noticing the following error message when submitting a PLSQL Program in Real mode:

o When a Program View is added as a Source TD to the program, users are not able to submit the Program in Real mode, even with the correct roles and privileges assigned.
o If you remove the Program View TD from the program, only then it can be submitted in Real mode without the aforementioned error message.


EXPECTED BEHAVIOR
-----------------------
It is expected that users should be able to run the entire program with having to remove the Program View.

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