Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c, session variable error "[nqsError: 23006] The session variable, NQ_SESSION."variable nam
Answers
-
I have a similar issue
INIT block:
Select
'REGULAR' AS V_PROG_TYPE
from DUALDefault initializer 'REGULAR'
INIT block test results are good
Session variable used in Opaque View has PROG_TYPE = 'VALUEOF(NQ_SESSION.V_PROG_TYPE)'
when trying to view data in rpd physical layer throws error
- [nQSError: 23006] The session variable, NQ_SESSION.V_PROG_TYPE, has no value definition.
once I click on OK on this dialogue box I see another dialogue box says Empty result set.
OBIEE version 12.2.1.4.0
0