Job Updater Parameter Values

The Job Updater Parameter Values (JOBUPDPV) page can be used to set up values for job parameters and other reference table column updates. These values are referenced on the Job Updater page, which are picked up by the Job Parameter Updater batch job. Values can either be a value literal (constant) or a function or expression of some other column value.

For example:

PREV_MONTH_FY is defined as (${CURR_APD} == 1)? ${CURR_FY} - 1 : ${CURR_FY}

Previous month fiscal year value will be evaluated at runtime based on the value of CURR_APD (Current Accounting Period) and CURR_FY (Current Fiscal Year). Assume that CURR_APD is calculated as 1(January) and CURR_FY is calculated as 2023 then PREV_MONTH_FY will be calculated as 2022.

The system by default calculates values for the following entries in the Job Parameter Values table.

APPL_SYS_DT - Application System Date from the Application Parameter (APPCTRL) table.
CURR_FY - FY from the R_CLDT table based on the Application System Date from APPCRL.
CURR_APD - APD from R_CLDT table based on the Application System Date from APPCTRL.
AD_CHAIN_SPEC_RANGE_RUN_ID - Minimum agent id/batch run id of the previous month AD chain run from BS_AGENT table.
AD_CHAIN_MAX_RUN_ID - Maximum Run Id from the AD_DOC_HDR table.

Field InformationField Information

Field Name	Description
Parameter Value	Name of the parameter value that can be referenced in the Job Updater’s Parameter Value column or can be even referenced in the expressions for other parameter values.
Expression	Expression field follows a specific syntax. It can directly take in literal values, which gets set as values on the specified Job Updater table record. It can also take in specific syntax expression that gets evaluated at runtime based on other parameter values. Refer to the example given above.
Parameter Description	Description of the Parameter Value.