OBIEE 12c, session variable error "[nqsError: 23006] The session variable, NQ_SESSION."variable nam

Karthi_obiee

I have a similar issue

INIT block:

Select

'REGULAR' AS V_PROG_TYPE

from DUAL

Default 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