How to fetch data from _V view in R12

To discuss Oracle Forms & Reports related technical issues.
Post Reply
moniz2u
Posts: 4
Joined: Wed Mar 03, 2010 12:31 pm
Location: Pakistan

How to fetch data from _V view in R12

Post by moniz2u »

I am using <b>ap_view_prepays_v</b> view in report and also set org-id using below code in Before & After Report trigger.

<b>Before Report Trigger</b>
SRW.USER_EXIT('FND SRWINIT');
mo_global.set_policy_context('S',:P_ORGID);

<b>After Report Trigger</b>
SRW.USER_EXIT('FND SRWEXIT')

Some time data from above view are displaying and some time are not displaying , when i run report in design mode it running fine any time .

Plz help me how to resolve this issue .

Thanks ,

Zulqarnain<font color="blue"></font id="blue">
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest