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

Whar are the different default triggers created when Master Deletes Property is set to Cascade?

1 Answers  

---

What is a visual attribute?

1 Answers  

---

What is the use of transactional triggers?

1 Answers  

---

What is term? What is use of term?

1 Answers  

---

What is the usage of the confine mode in Layout Editor ?

2 Answers   Convergys,

---

I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....

4 Answers  

---

What is the difference between bind and lexical parameter?

0 Answers  

---

What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,

---

What are the two repeating frame always associated with matrix object?

1 Answers  

---

What are the various sub events a mouse double click event involves?

1 Answers  

---

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 Answers  

---

How do you reference a Parameter?

1 Answers  

---