Standard Oracle System context

Submitted by code_admin on Tue, 07/10/2018 - 18:12

Some Oracle tables will not return results until you set the context.

See what sessions you have

[geshifilter-]select * from fnd_sessions where session_id=userenv('sessionid')[/geshifilter-]

Create a session

[geshifilter-]delete from fnd_sessions where session_id=userenv('sessionid'); insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),sysdate); commit;[/geshifilter-]

RJM Article Type
Quick Reference