Previous  Next          Contents  Index  Navigation  Glossary  Library


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 (any one of VALUE, DESCRIPTION, APROMPT or LPROMPT).


CODE="flexfield code"
APPL_SHORT_NAME="application short name"
DATA=":source column name"
[NUM=":structure defining source column/lexical"]
[DISPLAY="{ALL|flexfield qualifier|segment number}"]
[IDISPLAY="{ALL|flexfield qualifier|segment 
[VALUE=":output column name"]
[DESCRIPTION=":output column name"]
[APROMPT=":output column name"]
[LPROMPT=":output column name"]
[PADDED_VALUE=":output column name"]
[SECURITY=":column name"]



Specify the flexfield code for this report (for example, GL#). You call FLEXIDVAL multiple times, using a different CODE, to display information for multiple flexfields in one report.


Specify the short name of the application that owns this flexfield (for example, SQLGL).


Specify the name of the field that contains the concatenated flexfield segment values retrieved by your query.


Specify the name of the source column or parameter that contains the flexfield structure information.


The DISPLAY parameter allows you to display segments that represent specified flexfield qualifiers or specified segment numbers, where segment numbers are the order in that the segments appear in the flexfield window, not the segment number specified in the Define Key Segments form.

The default is ALL, which displays all segments. Alternatively, you can specify a flexfield qualifier name or a segment number. You can use these parameters as toggle switches by specifying them more than once. For example, if you to display all but the first segment, you would specify:



You use this parameter to tell FLEXIDVAL what segments you used in your SELECT clause in the corresponding FLEXSQL call. FLEXIDVAL needs this information to determine the format of raw data retrieved by FLEXSQL. You set IDISPLAY to the same value as your DISPLAY parameter in your FLEXSQL call. The default value is ALL, so if you used DISPLAY="ALL" in FLEXSQL, you do not need to use IDISPLAY here.


SHOWDEPSEG="N" disables automatic display of depended upon segments. The default value is Y.


Specify the name of the column in which you want to display flexfield values.


Specify the name of the column in which you want to display flexfield descriptions.


Specify the name of the column in which you want to display flexfield above prompts.


Specify the name of the column in which you want to display flexfield left prompts.


Specify the name of the column in which you want to display padded flexfield values. The segment values are padded to the segment size with blanks.


Specify the name of the column into which flag "S" will be placed if the segment values are secured. You then write logic to hide or display values based on this flag. This token is applicable only for segment values and does not apply to description, left prompt or above prompt.

Note: The datatype of the column as specified by VALUE, DESCRIPTION, APROMPT and LPROMPT is CHARACTER.

See Also

Overview of Reporting on Flexfields Data

Overview of Flexfield Views

Oracle Reports 2.5 Flexfield Support API

General Methodology

Basic Implementation Steps


Oracle Reports and Flexfields Report-Writing Steps

Flexfield Report Examples

         Previous  Next          Contents  Index  Navigation  Glossary  Library