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

If a break order is set on a column would it effect columns which are under the column?

1 Answers  

---

What is the difference between OLE Server & Ole Container?

1 Answers  

---

How can a square be drawn in the layout editor of the report writer?

1 Answers  

---

What is bind reference and how can it carate?

1 Answers  

---

List out the oracle forms configuration files?

0 Answers  

---

BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT. WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES TOTAL SHOULD BE DISPLAYED

1 Answers  

---

What package procedure used for invoke sql plus from sql forms ?

1 Answers  

---

What are the different styles of actvation of ole Objects?

1 Answers  

---

What do you understand by oracle forms?

0 Answers  

---

hiding item in report how like that properly,thats manually but at runtime i want to do

1 Answers  

---

When is PRE-QUERY trigger executed ?

3 Answers  

---

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

0 Answers   Intelligroup, TTPL,

---