Answer / chaudhry

Calls the user exit named in the user_exit_string. Invokes
a 3Gl programe by name which has been properly linked
into your current oracle forms executable.

Answer / preeti

Types of user exits

FND SRWINIT sets your profile option values and allows
Oracle AOL user exits to detect that they have been called
by a Oracle Reports program.[Before Report trigger,
P_CONC_REQUEST_ID lexical parameter]

FND SRWEXIT ensures that all the memory allocated for
Oracle AOL user exits has been freed up properly. [After
Report trigger]



FND FORMAT_CURRENCY is used for MULTIPLE CURRNECY REPORTING
(MRC) [formula Column, P_MIN_PRECISION lexical parameter]



FND FLEXSQL this API is used for get
ELECT/WHERE/HAVING/ORDER BY/GROUP BY from flex field

tables.



FND FLEXIDVAL this API is used for get descriptions from
flexfields, gets input from FND FLEXSQL.

Call this user exit to populate fields for display. You
pass the key flexfields data retrieved by the query into
this exit from the formula column. With this exit you
display values,descriptions and prompts by passing
appropriate token (VALUE/DESCRIPTION/APROMPT/LPROMPT).

it will take inputs from columns of query , the columns are
defined by FND FLEXSQL.

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 Answers  

---

What do you understand by lov and how can it be used?

0 Answers  

---

What is a predefined exception available in forms 4.0?

2 Answers  

---

What does an on-clear-block Trigger fire?

1 Answers  

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

0 Answers  

---

What is a library in Forms 4.0?

1 Answers  

---

what is tripstop report?

0 Answers  

---

Can you attach an lov to a field at design time?

1 Answers  

---

What is the difference between Anchoring Object and Enclosing Objects ?

1 Answers   GE, Netsoft,

---

Deleting a page removes information about all the fields in that page ?

1 Answers  

---

How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?

2 Answers   Convergys,

---

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 Answers  

---