Answer Posted / mark_jella

A user exit is a 3GL program where it can be linked to
the report builder executable
There are 3 types of user interfaces

1> ORACLE user interfaces
2> OCI (Oracle Caller Interface)
3> None-Oracle user exit

We can integrate Oracle reports with Oracle Application
Object Library, and run them as concurrent programs from
your forms or through standard request submission.

These are the user exits available in Oracle Reports that
makes AOL integration.


SRW.USER_EXIT(’FND SRWINIT’);
Define it in Before Report Trigger
This user exit sets up information for use by flexfields,
user profiles, the concurrent manager, and other Oracle
Applications features.

SRW.USER_EXIT(’FND SRWEXIT’);
Define it in After Report Trigger
This user exit frees all the memory allocation done in other
Oracle Applications user exits.


SRW.USER_EXIT(’FND FLEXSQL......');
Call FND FLEXSQL in Before Report Trigger to get the
Flexfield values

SRW.USER_EXIT(’FND FLEXIDVAL......');
Call FND FLEXIDVAL in Format Triggers to populate Flexfield
values

SRW.USER_EXIT(’FND FORMAT_CURRENCY......');
Call this User Exit in any format trigger to format the
Amount fields

In what situation u create the BPA.

2208

---

what is a package n what r the packages availbla in report

2088

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1977

---

what is oracle forms?

1102

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2116

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1673

---

did u p prepared complex report

1992

---

What is an oracle report? List its various types.

963

---

How can we generate report output in excel format?

989

---

all steps of bitmap report?

2347

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2902

---

What is a user exit program in oracle reports?

1027

---

What is an SQL FORMS ?

2782

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2210

---

how report can be generated if we have the database designed in oracle 10g?

1875

---