Standard Oracle System context

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-]