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 setting up of parameters in reports 2.0 reports ?

1 Answers  

---

What are built-ins used for Processing rows?

1 Answers  

---

What is an Alert ?

2 Answers  

---

What are the menu items that oracle forms 4.0 supports?

1 Answers  

---

HI GURUS, WHAT IS THE PURPOSE OF LEXICAL PARAMETER IN REPORT DEVELOPMENT.

2 Answers   Cap Gemini,

---

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

State the order in which these triggers are executed ?

1 Answers  

---

What is a record Group?

2 Answers  

---

Explain the different levels at which oracle form services interact.

0 Answers  

---

What are the different window events activated at runtimes?

1 Answers  

---

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

1 Answers  

---

What is the purpose of the product order option in the column property sheet?

1 Answers  

---