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

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 Answers  

---

in before report trigger SRW.user_exit(FND_Userinit) what will do

3 Answers  

---

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

1 Answers  

---

how can create the lexical parameter after the select class?

1 Answers   Oracle,

---

how to eliminate duplictes in column except group and section?

2 Answers   iFlex, TCS,

---

---

What is a canvas in oracle forms?

0 Answers  

---

What is the Maximum allowed length of Record group Column?

2 Answers  

---

What are visual attributes?

1 Answers  

---

Which of the two views should objects according to possession?

1 Answers  

---

How to create Drill down report?

0 Answers   ABB, ESS, Infosys,

---

How many pages you can in a single form ?

1 Answers  

---

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

0 Answers  

---