My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.