Answer / anil

this is one of the program.it will transfer report control from report execution to another 3rd generation language get the information and complete the remaining process
there r 5 user exits
1.fnd srwinit
2.fnd srwexit
3.fnd flexsql
4.fnd flexidval
5.fnd formatcurrency

Answer / 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

How do you reference a parameter indirectly?

1 Answers  

---

What built-in is used for showing the alert during run-time?

1 Answers  

---

why the Ctl file u put only in bin folder why not in other folder

0 Answers  

---

What are the difference between lov & list item?

1 Answers   ESS,

---

can i write commit in Before report trigger

4 Answers  

---

what u write in Ctl file

2 Answers  

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

0 Answers  

---

Is it possible to split the printpreviewer into more than one region?

1 Answers  

---

What are the built-ins used for processing rows?

1 Answers  

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

0 Answers  

---

what is bit map and character mode

1 Answers  

---

Explain the following file extention related to library?

1 Answers  

---