ERPstuff - Oracle EBS Community

Dear Experts

i am initialising using this script

begin
fnd_global.apps_initialize (user_id => 1112
,resp_id => 50707
,resp_appl_id =>222
);
end;

, but i am not able to query

in view

select * from ar_cash_receipts;

please suggest if we need to do something more to initialise session.

i ...

Thanks Mr. Rangaraj

Really nice work, reallly damn crisp and to the point.


may almighty increase your tribe

Dear Naveed,

This requirement of yours can be done in more than one ways.

1. select * from table where column_name = Nvl(:parameter, column_name)

2. select * from table where (:parameter is null ) <b>OR</b> (column_name = :parameter)

Both of them works. if you have any more share it too.

Best ...