Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
D
Appendix: MFPCS Specific Custom Functions, Procedures, and Special Expressions
MFP Cloud Service uses the RPAS Batch Framework to set up the batch process. For more details about understanding batch_control files and its uses in the batch process, see the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide . Any application-specific custom functions are packaged in RASL libraries and those are available to use in the batch_exec_list.txt control file with the service name as ra_custom to trigger to those functions and parameter as the function name. The following list of predefined custom functions are available RASL libraries installed as part of RPAS that are used by MFP.
Custom Function: ap_set_datr
The Platform UI feature allows product/location attributes to be used as filters. In order to use them as filters in the UI, those attributes needs to be registered as dimension attributes. This application-level function registers all the loaded product/location attributes as dimension attributes. It needs to be called each time a new set of product/location attributes is loaded.
It takes two parameters in addition to the function name, attribute measure and attribute hierarchy.
Example:
batch_datr | ra_custom | ap_set_datraddvlocatttsatr
Special Expressions and Procedures Used in MFPCS Configuration
This section contains details about the special expressions that are not standard RPAS expressions/procedures but are used in the MFPCS configuration.
AttributesPickListExpr - Attribute Picklist Expression
This procedure is used to determine a picklist of values from a base string measure along the positions of the specified hierarchy. It also takes in a Filter Boolean as input to control which intersections are to be used to pick data for the picklist.
Syntax:
OUTMEAS ← AttributesPickListExpr(FILTERMEAS, INPUTMEAS, HIER, OUTFORMAT)
Example:
ADHDLikePoCT ← AttributesPickListExpr(ADHDLikePoCB,ADHDLikePoCL, “LOC”, “0”)
Expression Parameters:
The following table shows the parameter details for the expression.
July 15, 2026 Appendix D-1 of D-2
Appendix D Special Expressions and Procedures Used in MFPCS Configuration
| Parameter Name | Parameter Type | Data Type | Description |
|---|---|---|---|
| OUTMEAS | Output | String | Output Picklist Measure which will be a string value. |
| INPUTMEAS | Input | String | Input String Measure containing the picklist values stored along a hierarchy. |
| FILTERMEAS | Input | Boolean | Boolean measure with the same intersection of OUTMEAS. It should be set to true for the intersections picklist that needs to be created. |
| HIER | Input | String | Hierarchy Name specified as a String constant along which the picklist values need to be used. This hierarchy should be present in INPUTMEAS. |
| OUTFORMAT | Input | String | Output format with valid values “0” or “1”. Using ”0” will create a picklist using position names as picklist internal names and labels as attribute values. “1” will create a picklist using position values as name and labels for the picklist. |
July 15, 2026 Appendix D-2 of D-2
In this guide
- Guide: Merchandise Financial Planning Cloud Service Implementation Guide
- Previous: C Appendix: Data Load
- Next: POM