[james_foran]

Have a look at how the VPD is set up. there is another way to test the query...

1) Run the following PL/SQL
begin vpd.set_user('USER_GID");end;

2) Run the query
select * from ob_order_base.

3) Run the query
SELECT SYS_CONTEXT('gl_user_ctx','CORPORATION_GID') from dual

The results of 2 will allow you to quickly see what effect the VPD is having, as it is applied at the Database level.

The results of 3 should tell you if your VPD Context is set correctly.

If you are still having issues, I would advise that you get a DBA to run through the above also. They should be able to get right into the issue.