CUSTOMPROP Statement—Specify Value Set Expressions for Default Values

C-LANG Statements › CUSTOMPROP Statement—Specify Value Set Expressions for Default Values

CUSTOMPROP Statement—Specify Value Set Expressions for Default Values

The CUSTOMPROP statement specifies value set expressions for default values. For example, if the default value of an argument is an SQL statement that contains profile (:$PROFILES$) or flexfield (:$FLEX$) expressions, you can specify how the agent resolves the expressions using this statement.

Supported Job Types

This statement is optional for the following job types:

Syntax

This statement has the following format:

CUSTOMPROP KEY(expression) VALUE(value)

expression

Specifies the expression to resolve.

Limits: Up to 256 characters; case-sensitive

Examples:

:$FLEX$.EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT
:$PROFILES$.GL_ACCESS_SET_ID

value

Specifies the default value for the expression. The value can contain a constant or an SQL SELECT query to run.

Limits: Up to 256 characters; case-sensitive

Examples:

SELECT EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT from SOME_TABLE where SOME_KEY = ‘Default’
SELECT '1' FROM DUAL

Notes:

If you want the agent to quote the resolved value, put the default value in single quotes, for example, 'SELECT '1' FROM DUAL'.
The agent does not resolve Field or Segment validation value sets.

Notes:

Enclose values that contain delimiters (such as spaces) in double quotation marks.
To specify multiple default value set expressions, use multiple CUSTOMPROP statements.

Example: Specify a Default Value Set Expression

Suppose that the default value of an argument in a single request program is the following SQL statement:

SELECT inventory_item_id from mtl_system_items where SEGMENT1 = :$FLEX$.EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT

To resolve the flexfield expression, :$FLEX$.EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT, you define the following default value set expression in the job:

:$FLEX$.EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT='SELECT EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT from SOME_TABLE where SOME_KEY = 'Default''

The default value for the expression is enclosed in single quotes so that the agent quotes the resolved value.

Assuming that the SQL SELECT statement returns Acct123, the following SQL query determines the default argument value:

SELECT inventory_item_id from mtl_system_items where SEGMENT1 = 'Acct123'

The following job definition specifies the default value set expression:

AGENT CYBOA
PROGRAM GMFDSUR
APPLDISPLNAME 'Process Manufacturing Financials'
RESPNAME 'System Administrator'
OAUSER SYSADMIN
ARGDEFAULTS Y
CUSTOMPROP KEY(':$FLEX$.EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT') +
  VALUE('SELECT EAM_SRS_MAINTAINED_ITEM_NAMES_W_ACT +
         from SOME_TABLE where SOME_KEY = 'Default'')