Lexical variable is used as place holder variable while the bind variable is to pass the value at run time.
It indicates that whether you want to keep a object and its entire contents on the same logical page. Setting its property to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page.
Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. The end of the anchor with a symbol on it is attached to the parent object.
Since the size of some layout objects may change when the report runs (and data is actually fetched), we need anchors to define where we want objects to appear relative to one another. An anchor defines the relative position of an object to the object to which it is anchored. Positioning is based on the size of the objects after the data has been fetched rather than on their size in the editor. It should also be noted that the position of the object in the Layout editor effects the final position in the report output. Any physical offset in the layout is incorporated into the percentage position specified in the Anchor property sheet.
While Submitting the request you can select schedule button and specify Run The Job Option On Specific Days and Select all Days except Sunday.
A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, depending upon the type of value which will be stored into it.
A format trigger is used when we want to display a particular field, if certain conditions are met.
6. How many different layouts are available in Reports6i? What are they?
in which sequence , form level trigger will fire? in which sequence, report trigger will fire?
how many types of canvas are there in form? what r they?
what are bind variables and lexical reference in oracle reports?
how many types of colums are there in Reports6i? what are they?
what is the purpose of placeHolder column in Report?
can u have a form with out a canvas?
what is confine mode and flex mode in reports?
how do u register report in oracleApps?
There are eight different layout formats :
2. Form Like
3. Mailing Label
4. Form Letter
5. Group Left
6. Group Above
8. Matrix with group
You can use srw.run_report as followssrw.run_report('module=modulename.rdf destype=screen paramform=yes');
The main features in Release 11i is
1.Multi Org-To support Multiple organizations.
1.Multi Currency-Defineing the multiple currencies to single organization
2.Multi Lingual-Suporting of multi Languages.
1. Fnd_File - PL/SQL I/O
2. Fnd_program - Concurrent Program Loaders
3. Fnd_set - Request Set Creation
4. Fnd_request - Concurrent Request Submission
5. Fnd_Submit - Request set Submission
6. Fnd_Request - Info
and so on...
There are 3 tier of Internet Architechture of Oracle Application 11i.
1. Desktop Tier
2. Database Tier
3. Application Tier.