Search found 4 matches

by moniz2u
Thu Feb 21, 2013 9:50 am
Forum: Oracle Forms & Reports
Topic: How to fetch data from _V view in R12
Replies: 0
Views: 28623

How to fetch data from _V view in R12

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 ...
by moniz2u
Mon Jan 21, 2013 4:32 am
Forum: Application DBA & System Administration
Topic: How to get executed SQL queries from JSP Web pages
Replies: 0
Views: 11819

How to get executed SQL queries from JSP Web pages

Hi 2 all

Anybody know that How to get executed SQL queries from JSP Web pages in oracle R12 .

Regards ,

Zulqarnain
by moniz2u
Sun Dec 30, 2012 11:13 am
Forum: Oracle Forms & Reports
Topic: Oracle Report show in XML Format
Replies: 0
Views: 22783

Oracle Report show in XML Format

Hi to all

I designed one report in oracle EBS R12 and attach one XML Template for output.This report output show properly but when i add this report in Request Set then its output show in XML format instead of attach template.

If any member have its solution so plz send it.

Regards ,

Zulqarnain
by moniz2u
Sun Dec 30, 2012 5:21 am
Forum: Oracle Forms & Reports
Topic: User name on ORACLE R12 report
Replies: 0
Views: 9818

User name on ORACLE R12 report

Hi 2 all

Anybody know that how to display login user on oracle EBS reports.

Regards

Zulqarnain