Various special variables in the EBS system, summary of special parameter reference formats

1. When establishing a reference column for a descriptive elastic field, if you do not want to refer to the field in this table, but want to refer to a variable in the system, you can write

$PROFILES $. user_id

2. In a multi-layered elastic domain, if the next layer of elastic domain wants to reference the value of the previous elastic field, it can be written in the where statement setting of the set of values referenced by the next layer of elastic fields:

$FLEX $. Province, where province is the column name of the reference field for the previous layer of the elastic field.

Get report request ID in 3.report Builder

RETURN:P _conc_request_id;

FND_GLOBAL.CONC_REQUEST_ID and Fnd_profile. VALUE (' concurrent_request_id ') seems to be useless in the report.

4. Subordinate Value set

Set up two set of values for the book name (cux_sob_id), the vendor name (cux_vendor_id), respectively

Where statements in cux_vendor_id can be written like this:

SET_OF_BOOKS_ID=NVL (: $FLEX $.cux_sob_id,set_of_books_id) or

SET_OF_BOOKS_ID=NVL (: $FLEX $.cux_sob_id:null,set_of_books_id)

This makes the two set of values associated.

We look closely at the 2 statements above, the difference is that the second statement is more than one (: NULL), his role is that when the user does not select his parent parameter, you can first select himself, conversely, if not: NULL the user must select their parent parameter (this example is the name of the book) to select themselves (this example is the vendor name)

Various special variables in the EBS system, summary of special parameter reference formats