12 Supply Chain
This section include the configurations of Supply Chain Hub for each module.
Supply Chain Hub
The hub has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them it is imperative to validate the core functionality of the framework that will use them in the Implementation Guide - Supply Chain Hub Frameworks section.
System Parameters
Listed below is the list of configurations at system level that are used by this application. Those configurations include configurations specific for the module and purge parameters used by Purge Framework detailed in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
The parameters are defined in table ORCV_SYSTEM_PARAMETERS.
Table 12-1 System Parameters - Supply Chain Hub
| AREA | PARAMETER | DESCRIPTION | VALUE 1 |
|---|---|---|---|
| PURGE | PURGE_DAYS | Number of days post expiration Operational News data is purged | 30 |
Application Options
Application Options core functionality is detailed in Implementation Guide - Supply Chain Hub Frameworks section Profile, Supply Chain Hub has the following Application Options defined:
The application options are defined in table ORCV_PRFL_CFG_APP_OPTIONS.
Table 12-2 Application Options - Supply Chain Hub
| APP ALIA S | ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | DEFAUL T VALUE | CONFIGURATIO N LEVEL |
|---|---|---|---|---|
| SPCH | FAQ_LINK | Homepage FAQ Link. | NULL | Global |
| SPCH | OP_NEWS_EXPIRE_D AYS | Defines the number of days after expire date the operational news is not shown in dashboard badge. | 6 | Global |
| SPCH | TRBL_LINK | Homepage Troubleshooting Link. | NULL | Global |
Codes
Certain operations require codes to define the options available at system level. Below you can find the list of code types and the codes available, the sequence and their description.
The codes are defined in tables ORCV_CODE_HEAD and RCV_CODE_DETAIL
Table 12-3 Codes
| CODE TYPE | CODE TYPE DESCRIPTION |
| CFGL | Configuration Level |
| MDID | Modules |
| ONNT | News Type |
| ONTA | Target Audience |
| ONTT | Target Type |
Procure to Pay – Purchase Orders
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide , - Supply Chain Hub Frameworks section .
System Parameters
Listed below are the system level configurations used by this application. These configurations include purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-4 System Parameters - Purchase Orders
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORDHEAD_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORDHEAD_ITEMS_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORDLOC_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORD_ITEMS_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORD_NEW_ITEMS_TMP | 2 |
Application Configuration
Table 12-5 Application Configuration - Purchase Orders
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | DEFAULT VALUE | CONFIGURATIO N LEVEL |
|---|---|---|---|
| DELIVERY_NBD_NAD | Indicates which dates should be considered. Valid values are: (1)-Delivery Date (2)- Not before date/Not after date | 1 | Global |
| ACK_REQUIRED |
Indicates if the supplier is required to acknowledge the PO. Valid values Y-Yes/N-No |
Y | Supplier Default |
| CUSTOMER_ORDER_IND | Indicates if Customer Orders should be available in Procure to Pay. Values Y-Yes/N-No | Y | Supplier Default |
| MULTI_DELIVERY _PO | Indicator to define if POs created and managed by supplier support multiple deliveries. Valid values Y-Yes/N-No | Y | Supplier Default |
| VMI_ORDERS | Indicator to define if supplier can create orders. Valid values Y-Yes/N-No | Y | Supplier Default |
Procure to Pay – Shipments
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them it is imperative to validate the core functionality of the framework that will use them in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Below is a list of configurations at system level used by this application. These configurations include purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-6 System Parameters - Shipments
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ASN_ORD_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ASN_ORD_ITEM_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ASN_ADD_ITEM_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ASN_CTN_TMP | 2 |
Application Configuration
Table 12-7 Application Configuration - Shipments
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | DEFAULT VALUE | CONFIGURATI ON LEVEL |
|---|---|---|---|
| ASN_QTY_TOLERANCE | Value in percentage of how many units can be shipped in each ASN above the PO quantity. If set to NULL, no limit is applied to the quantity that can be shipped in excess. | 0 |
Supplier Default |
| ASN_BEFORE_DAYS | Number of days allowed for the shipment date before the maximum Not Before Date. | 10 |
Supplier Default |
| ASN_AFTER_DAYS | Number of days allowed for the shipment date after the minimum Not After Date. | 10 |
Supplier Default |
Procure to Pay – Finance Documents
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them it is imperative to validate the core functionality of the framework that will use them in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Below is a list of configurations at system level used by this application. These configurations include purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-8 System Parameters - Finance Documents
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VAL UE 2 |
|---|---|---|---|---|
| CONFIG | DOCS_LOV_CRE | Code Head associated to LOV for creation mode on DOCS screen | DOCC | NA |
| CONFIG | DOCS_LOV_VIEW | Code Head associated to LOV for view mode on DOCS screen | DOCV | NA |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ADD_ITEM_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_HEAD_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ITEM_TAX_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ITEM_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ORDRTV_TMP | 2 |
Other System Parameters
In the table below are the System Parameters of Finance module that need to be updated accordingly.
Table 12-9 Other System Parameters - Finance Documents
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VAL UE 2 |
|---|---|---|---|---|
| GTS | TAX_BASIS_TYPE | Used in GTS calculation taxes. Valid values are B for Both, C for cost, R for retail, or N for non-merchandise | C | NA |
| PURGE | PURGE_DAYS | Default purge period. | ORCV_FIN_INT_DOC_XREF | 30 |
Return to Vendor
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Listed below is a list of system level configurations used by this application. Those configurations include configurations specific to the module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-10 System Parameters - Return to Vendor
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | Value 2 |
|---|---|---|---|---|
| CONFIG | CANCEL_S9T_DEFAULT_REASON | Default S9T Reason code when a RTV is canceled | C9 | NA |
| CONFIG | REJECT_S9T_DEFAULT_REASON | Default S9T Reason code when a RTV is rejected | R9 | NA |
| CONFIG | UNAVAILABLE_DISP_CODE | MFCS Disposition Code for the U (Unavailable) reason code. | ATS | NA |
| PURGE | PURGE_DAYS | Default purge period for hist tables. | ORCV_SPRV_RTV_HEAD_HIST | 60 |
| PURGE | PURGE_DAYS | Default purge period for stg tables. | ORCV_SPRV_RTV_HEAD_STG | 30 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_SPRV_RTV_HEAD_TMP | 2 |
Inventory and Sales
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Below is a list of configurations at system level used by this application. Those configurations include configurations specific to the module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-11 System Parameters - Inventory and Sales
| AREA | PARAMETER | DESCRIPTION | VALU E 1 | Value 2 |
|---|---|---|---|---|
| CONFIG | NUMBER_WEEKS_SALES_FORECAST | Number of weeks for item forecast. VALUE_1 - Number of weeks to determine the weeks start, VALUE_2 (optional) - Number of weeks to determine the weeks end | 2 | 3 |
| CONFIG | NUMBER_WEEKS_SALES_HIST | Number of weeks to display in Sales Details screen of Inventory and Sales | 5 | NA |
Application Configuration
Listed below are the configurations at global level that are used by this application.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS and ORCV_PRFL_CFG_APP_SUPP_OPTIONS tables.
Table 12-12 Application Configuration - Inventory and Sales
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | DEFAULT VALUE |
|---|---|---|
| LOW_STOCK_THRESHOLD | Limit value to use as a reference to determine low stock of an item | 10 |
Items Management
This Module has multiple configurations to support its functionalities and, in the subsections, below, those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide , Supply Chain Hub Frameworks section.
System Parameters
Listed below are configurations at system level used by this application. Those configurations include configurations specific to the module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section.
The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below. The values for the UDA’s are examples and can be modified according to project implementation.
Table 12-13 System Parameters - Item Management
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | ADD_DIFFS_OPTION | Option to add new diffs. Y-Active, N-Inactive | N | NA |
| CONFIG | BARCODE_TYPES_GRANTED | List of valid Barcode types that can be assigned to items. | EAN13 | NA |
| CONFIG | BARCODE_TYPES_GRANTED | List of valid Barcode types that can be assigned to items. | ITEM | NA |
| CONFIG | BARCODE_TYPES_GRANTED | List of valid Barcode types that can be assigned to items. | MANL | NA |
| CONFIG | BARCODE_TYPES_GRANTED | List of valid Barcode types that can be assigned to items. | UPC-A | NA |
| CONFIG | DIFFS_QUEUE_NAM E | This will hold the diffs default queue name for Items Management | ORCV_SPIM_DIFF_AQ | NA |
| CONFIG | DIFF_AGGREGATE_IND |
Default value for Diff_Aggregate_Ind. Valid values: Y, N(Default) |
N | NA |
| CONFIG | DIFF_CRE_SINGLE_SKU | Default differentiator group/id for create single SKU option. | DIFF_GRP_ID | DIFF_ID |
| CONFIG | EXCLUDED_UDA | UDAs that should be excluded from the user assigning to an item. | OFF_SALE_DATE | 9003 |
| CONFIG | EXCLUDED_UDA | UDAs that should be excluded from the user assigning to an item. | ON_SALE_DATE | 9002 |
| CONFIG | EXCLUDED_UDA | UDAs that should be excluded from the user assigning to an item. | STOCK_AVAIL | 9004 |
| CONFIG | EXPLD_ALL_SKUS | Flag indicating whether all Style entities are exploded to child SKUs. | Y | NA |
| CONFIG | GENERATE_EAN | Defines if the Generate EAN functionality is enabled. | Y | NA |
| CONFIG | IMAGE_TYPE | Default type of image | M | NA |
| CONFIG | ITEM_S9T_REASON_CODE | Default reason code for S9T Update Details | S | NA |
| CONFIG | ITEM_STANDARD_UOM |
Default Items Management Standard UOM. |
EA | NA |
| CONFIG | ITEM_STORE_ORD_MULT |
Default Items Management Store Ord Mult. |
E | NA |
| CONFIG | LOCATION_STATUS_GRANTED | List of valid Location statuses that can be assigned to locations. | A | NA |
| CONFIG | LOCATION_STATUS_GRANTED | List of valid Location statuses that can be assigned to locations. | C | NA |
| CONFIG | MAX_JOBS_RUNNING | Maximum jobs to run in parallel to process items. | 16 | NA |
| CONFIG | PRICE_CALC_AUTO | Controls if price calculation should auto run on Approval if configuration is not MFCS. Possible values are Y and N. | N | NA |
| CONFIG | PRICE_CALC_CONFIG | Controls what method is being used for price calculation. Possible values are MFCS and STRAT. | MFCS | NA |
| CONFIG | PRICE_CALC_REQ | Controls if price calculation is mandatory. Possible values are Y and N. | N | NA |
| CONFIG | PRICE_CALC_TRIGG ER | Controls what service is being used for price calculation. Use ids from ORCV_PRICE_CALC_CONF IG. | -1 | NA |
| CONFIG | PURCHASE_TYPE | Default purchase type | 0 | NA |
| CONFIG | QUEUE_NAME | This will hold the default queue name for Items Management | ORCV_SPIM_ITEM_AQ | NA |
| CONFIG | REFS | Flag indicating whether all refs should be displayed or not | N | NA |
| CONFIG | REF_ATTR | Flag indicating whether modal with reference attributes should be displayed or not | Y | NA |
| CONFIG | REF_ATTR_RETAILE R | Flag indicating whether modal with reference attributes should be displayed if user is a retailer or not | N | NA |
| CONFIG | ROUND_LVL | Defines how order quantities will be rounded to Case, Layer and Pallet. | C | NA |
| CONFIG | ROUND_TO_CASE_P CT | This will hold the case Rounding Threshold value. | 50.0000 | NA |
| CONFIG | ROUND_TO_INNER_ PCT | This will hold the Inner Rounding Threshold value. | 50.0000 | NA |
| CONFIG | ROUND_TO_LAYER_ PCT | This will hold the layer Rounding Threshold value. | 50.0000 | NA |
| CONFIG | ROUND_TO_PALLET _PCT | This will hold the pallet Rounding Threshold value. | 50.0000 | NA |
| NOTIF_CON FIG | ITEMS_PENDING_A CTION_DAYS | Number of days to generate alerts for items with pending actions. | 1 | NA |
| PURGE | PURGE_DAYS | Default purge period for error tables. | ORCV_SPIM_ITEM_ERRORS_DETAIL | 30 |
| PURGE | PURGE_DAYS | Default purge period for staging tables. | ORCV_SPIM_ITEM_HEADER | 30 |
| PURGE | PURGE_DAYS | Default purge period for temporary tables. | ORCV_SPIM_ITEM_HEADER_TMP | 30 |
Data purging for Items Management is defined based on the main table ORCV_SPIM_ITEM_HEADER and temporary tables based on ORCV_SPIM_ITEM_HEADER_TMP.
Other System Parameters
In the table below are the System Parameters of Items module that need to be updated accordingly.
Table 12-14 Other System Parameters - Items Management
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | ITEM_CONSIGNMENT_PRICING_IND |
Check if pricing consignment is enable or disable. |
N | NA |
| CONFIG | ITEM_INT_REVISIO N_UDA | UDA that must be used exclusively in the integration process. | 9001 | NA |
| CONFIG | RESERVE_ITEM_MAX_AMOUNT | Maximum number of items that can be reserved via the item reserve web service. | 10 | NA |
| CONFIG | RESERVE_ITEM_MAX_EXPIRY | Maximum days until the item reservation expires. | 1 | NA |
| INTEGRATI ON | INDUCTION_TEMPLATE | Template key. | ORCV_S9T_MFCS_ITEMS_INDUCTION_V24 | NA |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_ITEM_INT_ILTRT | 30 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_ITEM_INT_MASTER | 30 |
Data purging for Items Integration is defined based on the main table ORCV_ITEM_INT_MASTER.
Application Configuration
Listed below are configurations at supplier/global level that are used by this application.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS and ORCV_PRFL_CFG_APP_SUPP_OPTIONS tables.
Table 12-15 Application Configurations - Items Management
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | ATTRIBUT E VALUE |
|---|---|---|
| ADD_NEW_DIFF | App option to define if the supplier as permission to add new diffs. | N |
| BUYER_PACK_ORDER_AS_TYPE | Default Order as Type value for Buyer packs. | E |
| CASE_NAME | Code referencing the name used by supplier to refer to the case. | CS |
| COMPLEX_PACK_TYPE | Default Type for Complex Packs. | V |
| COST_UOM | Default cost UOM. This is held to allow costs to be managed in a separate UOM than the standard UOM. | EA |
| COST_ZONE_GROUP | Default Cost Zone Group for the item. | 1000 |
| DEFAULT_UOP | Default unit of purchase for the item/supplier/ country. | EA |
| DIM_OBJECT | Default Units of an item contained in an inner pack supplied by the supplier for item dimensions definition. | EA |
| DIRECT_SHIP_IND | Indicates if this supplier is eligible for a direct shipment from the supplier to the customer. | N |
| HANDLING_SENSITITY | This will hold the default the default handling sensitivity. | NA |
| HANDLING_TEMPERATURE | This will hold the default the default handling temperature. | NA |
| HI | Default number of tiers that make up a complete pallet (height). | 1 |
| INNER_NAME | Code referencing the name used by supplier to refer to the inner. | INR |
| INNER_PACK_SIZE | This will hold the default the default inner pack size | 1 |
| PALLET_NAME | Code referencing the name used by supplier to refer to the pallet. | PAL |
| SIMPLE_PACK_TYPE | Default Type for Simple Packs. | V |
| STORE_ORD_MULT | This will hold the default the default store ord mult. | I |
| SUPP_PACK_SIZE | This will hold the default Supplier Pack Size. | 1 |
| TI | Default number of shipping units (cases) that make up one tier of a pallet. | 1 |
Cost Changes Management
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide , Supply Chain Hub Frameworks section.
System Parameters
Listed below are configurations at system level used by this application. Those configurations include configurations specific to the module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-16 System Parameters - Cost Changes Management
| Area | Parameter | Description | Value 1 | Value 2 | Value 3 |
|---|---|---|---|---|---|
| CONFIG | COST_PRIOR_BLOCK_DAYS | Number of days to block Cost Change until RMS integration. | 1 | NA | NA |
| CONFIG | COST_PRIOR_DEADLINE_DAYS | Number of deadline days. | 1 | NA | NA |
| CONFIG | DEFAULT_COST_CHG_LVL | Supplier default Cost Change Level (Valid Values: UNIT, INNER, CASE). | UNIT | NA | NA |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPCC_COSTCHG_HEAD | 30 | NA |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPCC_COSTCHG_HEAD_TMP | 2 | NA |
| REASON_CODES | AUTO | Reason Code Code (VALUE_3) to be used in automation of Action (VALUE_2) for Entity (VALUE_1). | COSTCHG | APPROVE | APRVCC |
| REASON_CODES | AUTO | Reason Code Code (VALUE_3) to be used in automation of Action (VALUE_2) for Entity (VALUE_1). | COSTCHG | REJECT | RJCTCC |
| REASON_CODES | CODES | Reason Codes Code Type (VALUE_2) for Entity (VALUE_1). | COSTCHG | CCRC | NA |
| REASON_CODES | HIDE_CODES | Reason Codes Hide Code Type (VALUE_3) to hide from the CODES (Parameter) code type (VALUE_2). | COSTCHG | REJECT | CCHR |
| REASON_CODES | HIDE_CODES | Reason Codes Hide Code Type (VALUE_3) to hide from the CODES (Parameter) code type (VALUE_2). | COSTCHG | UPDATE | CCHU |
| CONFIG | COST_PRIOR_BLOCK_DAYS | Number of days to block Cost Change until RMS integration. | 1 | NA | NA |
| CONFIG | COST_PRIOR_DEADLINE_DAYS | Number of deadline days. | 1 | NA | NA |
Data purging for Cost Changes Management is defined based on the main table ORCV_SPCC_COSTCHG_HEAD and temporary tables based on ORCV_SPCC_COSTCHG_HEAD_TMP.
Other System Parameters
In the table below are the System Parameters of Costs module that need to be updated accordingly.
Table 12-17 Cost Changes Management - Other System Parameters
| Area | Parameter | Description | Value 1 | Value 2 |
|---|---|---|---|---|
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_COSTS_INT_CC_HEAD_PUBINFO | 30 |
Application Configuration
Listed below are configurations defined at Global Level for the Module or Supplier Level for supplier specific configuration in the Module.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS once specific suppliers are configured the details will be stored in ORCV_PRFL_CFG_APP_SUPP_OPTIONS.
Table 12-18 Application Configuration - Cost Changes Management
| ATTRIBUTE ID | DESCRIPTION | VALU E | CONFIGURATION LEVEL |
|---|---|---|---|
| COST_CHANGE_TOLERANCE | Percentage value to determine when cost change is significant | 10 | Supplier |
Supplier Performance
This Module has multiple configurations to support its functionalities and, in the subsections, below, those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide , Supply Chain Hub Frameworks section.
System Parameters
Listed below are configurations at the system level used by this application. Those configurations include configurations specific to the module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section.
The parameters are defined in table ORCV_SYSTEM_PARAMETER. The default values are listed below.
Table 12-19 System Parameters - Supplier Performance
| AREA | PARAMETER | DESCRIPTI ON | VALUE 1 | VALU E 2 |
|---|---|---|---|---|
| CONFIG | COMP_ERROR | Minimum Compliance Error Level | 3 | NA |
| CONFIG | DEFECT_REASON | Adj Reason Code | 5 | NA |
| CONFIG | DEFECT_REASON | Adj Reason Code | 60 | NA |
| CONFIG | DEFECT_REASON | Adj Reason Code | 93 | NA |
| CONFIG | EARLY_LATE_DAYS | Number of days to be considered as Early/ Late receipt | 3 | NA |
| CONFIG | METRIC_DAYS_WINDOW | Maximum window to be used for ASN and Invoices Metrics | 30 | NA |
| CONFIG | QUEST_MIN_FREQ |
Questionnai re Minimum Frequency (in days) |
365 | NA |
| CONFIG | RECEIVE_WAIT_DAYS | Time to wait for receipt to finish (in days) | 7 | NA |
| CONFIG | RTV_REASON | RTV Reason Code | U | NA |
| CONFIG | RTV_REASON | RTV Reason Code | W | NA |
| CONFIG | SCORE_AVG_DAYS |
Score Moving Average Days |
365 | NA |
| PURGE | PURGE_DAYS | Default purge period for questionnai re revision tables | ORCV_SPPF_QUESTN_HEAD_ REV | 730 |
| PURGE | PURGE_DAYS | Default purge period for reply tables | ORCV_SPPF_QUESTN_REPLY_ HEAD | 730 |
| PURGE | PURGE_DAYS | Default purge period for supplier score tables | ORCV_SPPF_SUPP_SCORE_HIS T | 730 |
Application Configuration
Listed below are configurations at supplier/global level that are used by this application.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS and ORCV_PRFL_CFG_APP_SUPP_OPTIONS tables.
Table 12-20 Application Configuration - Supplier Performance
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | ATTRIBUTE VALUE | CONFIGURATION LEVEL |
|---|---|---|---|
| PF_TEMPLATE_ID | Default Template ID | 1 | Supplier |
Quality Control
This Module has multiple configurations to support its functionalities and, in the subsections, below, those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide , Supply Chain Hub Frameworks section.
System Parameters
Listed below are the system level configurations in this Module. Those configurations include specific configurations for the Module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-21 System Parameters - Quality Control
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | COMPLETE_INSPECTION | Flag to define if all items checks must be done to complete Job. | Y | NA |
| CONFIG | UNAVAILABLE_DISP_CODE | MFCS Disposition Code for the U (Unavailable) reason code. | ATS | NA |
| PURGE | PURGE_DAYS | Default purge period for stg tables. | ORCV_QLCT_JOB_HEAD | 60 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_HEAD_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_CHECK_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_ITEM_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_ITEM_CHECK_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_RESULT_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_ITEM_RESULT_TMP | 2 |
Other System Parameters
In the table below are the System Parameters of Shipments module that need to be updated accordingly.
Table 12-22 Other System Parameters - Quality Control
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | CLOSE_SHIP_WAIT_TIME | Wait time in Hours for WMS to close Shipment | 24 | NA |
Deals Management
This Module has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Listed below are the system level configurations in this Module. Those configurations include specific configurations for the Module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-23 System Parameters - Deals Management
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | ASSOCIATE_PROMO | Determines if for a VPF Deal the system should allow associate a promotion. Button available -'Y' or disabled - 'N' | Y | NA |
| CONF IG | DEAL_CLASS | Calculation class of the deal component. Valid values are: CU for cumulative, CS for cascade and EX for exclusive. | CU | NA |
| CONFIG | DISPLAY_CLOSED_DEALS_DAYS | Number of days closed deals in MFCS will continue to be displayed in SCH Deals management dashboards/screens. | 0 | NA |
| CONFIG | EXPLODE_MERCH_HIER_IND | Flag indicating whether the merch hierarchy should be exploded upon publishing. | N | NA |
| CONFIG | INCLUDE_CLOSED_DEALS_INCOME | If closed deals income (under the DISPLAY_CLOSED_DEALS_ DAYS) will be included on the income dashboards or not. | N | NA |
| CONFIG | INT_DAYS_BEFORE_START | Minimum number of days prior to the start date for deal to be processed. | 2 | NA |
| CONFIG | RECALCULATE_OPEN_PO |
Determines if open PO's will be recalculated for new Off-Invoice Deals. |
N | NA |
| CONF IG | RECOGNIZE_WH_AS_LOCATIONS | Determines if the warehouses should be considered as locations. Valid values are: 1 - Yes, 0 - No. | 1 | NA |
| CONFIG | SUPPORTED_BILLING_TYPE | Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. | BB | NA |
| CONFIG | SUPPORTED_BILLING_TYPE | Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. | BBR | NA |
| CONFIG | SUPPORTED_BILLING_TYPE | Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. | VFP | NA |
| PURGE | PRG_NEW_SUB_DAYS | Number of days after which new and submitted deals will be purged. | 28 | NA |
| PURGE | PRG_REJ_DAYS | Number of days after which rejected deals will be purged. | 7 | NA |
| PURGE | PURGE_DAYS | Default purge Period. |
ORCV_SPDM_DEAL_HEAD_TMP |
2 |
Application Configuration
Listed below are configurations defined at Global Level for the Module or Supplier Level for supplier specific configuration and the defaults in the Module.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS once specific suppliers are configured the details will be stored in ORCV_PRFL_CFG_APP_SUPP_OPTIONS.
Table 20-3 Application Configuration - Deals Management
Table 12-24 Application Configuration - Deals Management
| ATTRIBUTE ID | DESCRIPTION | VALU E | CONFIGURATI ON LEVEL |
|---|---|---|---|
| ASSOCIATE_PROMO | Yes or No value. It determines if for a specific supplier and for a Deal of type VFP, if the system should allow associate a promotion (Promotion button available -'Y') or not (Promotion button disable - 'N'). | Y | Supplier |
| BILL_BACK_METHOD |
Credit Note ('C'), Debit Note ('D'). |
D | Supplier |
| BILL_BACK_PERIOD | Week, Month, Quarter, Half Year, Annual. Bill Back Period must be greater than or equal to Deal Reporting Level. | W | Supplier |
| CALC_TO_ZERO_IND | This indicator is used in cases where the vendor has specified that a minimum threshold needs to be reached before a discount applies and when that threshold is reached, the discount applies against the entire threshold, including the level below. | N | Supplier |
| COST_APPLY_IND | The 'Cost Apply Type' field indicates whether the deal component impacts the Net Cost ('N'), Net-Net Cost ('NN') or Dead Net Cost ('DNN') on the FUTURE_COST table. | NN | Supplier |
| DEAL_APPLICATION_TIMING | 'O' for PO approval, 'R' for receiving for BB/BBR. Is null for VFP | O | Supplier |
| DEAL_CLASS | Valid values are 'CU' for cumulative, 'CS' for cascade and 'EX' for exclusive. | CU | Supplier |
| DEAL_COMP_TYPE | This field is for informational purpose only as a way to describe the component. | TBB | Supplier |
| DEAL_INCOME_CALCULATION | Actuals Earned to date ('A'), Pro-rated using forecast('P') | A | Supplier |
| DEAL_REPORTING_LEVEL | Week, Month, Quarter. | W | Supplier |
| GROWTH_REBATE_IND | The Growth Rebate information is available only for Bill Back Rebate deals and is for informational/ reporting purposes. | N | Supplier |
| INVOICE_PROCESSING_LOGIC | Valid values in the case of BB and BBR type of deals: Automatic All Values ('AA'), Manual All Values ('MA'), Automatic Positive Values Only ('AP'), Manual Positive Values Only ('MP'), No Invoice Processing ('NO') | AA | Supplier |
| PRICE_COST_APPL_IND | This indicator defines whether the deal is to be used in the pricing cost calculation used by Pricing to determine the margin on the items linked with the deal(future_cost). | Y | Supplier |
| REBATE_CALC_TYPE | This field is defaulted to 'Linear' and disabled for a BB deal, while for a BBR, the user can set it to 'Linear' or 'Scalar' | L | Supplier |
| SECURITY_IND | This indicator can be used to implement user-based security for the deal that is currently being created. When set, the deal details can be viewed or edited only by users who have the same or higher privileges compared to the deal creator. | N | Supplier |
| STOCK_LEDGER_IND | This checkbox indicates whether the deal income is posted to the Stock Ledger in addition to the General Ledger. | Y | Supplier |
| SUPPLIER_APPROVE_NEEDED | This configuration shows if supplied also needs to approve deals. The default is yes. | Y | Supplier |
| THRESHOLD_LIMIT_UOM | Default to 'EA'. If units are selected (Threshold Limit Type), the user also has to define the Unit of Measure (UOM) that the threshold tracks. | EA | Supplier |
| TRAN_DISCOUNT_IND | Yes ('Y'), No ('N') | N | Supplier |
Supplier Penalties
This Module has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Framework section.
System Parameters
Listed below are the system level configurations in this application. Those configurations include specific configurations for the Module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 21-2 System Parameters - Supplier Penalties
Table 12-25 System Parameters - Supplier Penalties
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | REQ_SUPP_APPROVE | Indicates if the Penalty Rules approval for all suppliers is needed(Y-Yes/N-No). | N | NA |
| PURGE | PURGE_DAYS | Default purge period for stg tables. | ORCV_SPPY_PENALTY_HEAD | 60 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_SPPY_PENALTY_ITEM_T MP | 2 |
| PURGE | PURGE_DAYS | Default purge period for tmp tables. | ORCV_SPPY_PENALTY_HEAD_T MP | 2 |
| PURGE | PURGE_DAYS | Default purge period for rule engine tmp tables. | ORCV_SPPY_RLEG_SHIP_STG | 7 |
| PURGE | PURGE_DAYS | Default purge period for rule engine tmp tables. | ORCV_SPPY_RLEG_PO_STG | 7 |
| PURGE | PURGE_DAYS | Default purge period for rule engine tmp tables. | ORCV_SPPY_RLEG_QA_STG | 7 |
Application Configuration
Listed below are configurations defined at Global Level for the Module or Supplier Level for supplier specific configuration and the defaults in the Module.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS once specific suppliers are configured the details will be stored in ORCV_PRFL_CFG_APP_SUPP_OPTIONS.
Table 12-26 Application Configuration - Supplier Penalties
| ATTRIBUTE ID | DESCRIPTION | VALU E | CONFIGURATION LEVEL |
|---|---|---|---|
| DOCUMENT_TYPE | Indicates what document should be generated for supplier (C-Credit Note, D-Debit Memo). | NULL | Supplier |
| REQ_SUPP_APPROVE | Indicates if the Penalty Rules approval for a specific supplier is needed(Y-Yes/N-No). | N | Supplier |
Retail Price
This Module has multiple configurations to support its functionalities and, in the subsections, below, those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Listed below are the system level configurations in this Module. Those configurations include specific configurations for the Module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-27 System Parameters - Retail Price
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | PRICE_EVENT_DUE_DAYS | Number of days prior to a price event to trigger the e-mail alert notification before approval. | 7 | NA |
| CONFIG |
PRICE_PRIOR_DEADLINE_DAYS |
Number of Deadline days. | 1 | NA |
| CONFIG | PROMO_END_TIME | Promotion default end time. | 23:59 | NA |
| CONFIG | PROMO_START_TIME | Promotion default start time. | 00:00 | NA |
| CONFIG | S9T_REASON_CODE | Default reason code used by S9T. Corresponding code type is PERR. | 6 | NA |
| CONFIG | SEARCH_MAX_RANGE | Dashboard Past Window (in days) | 30 | NA |
| PURGE | PURGE_DAYS | Default purge period. | ORCV_SPPM_PRICE_EVENT | 30 |
Other System Parameters
In the table below are the System Parameters of Items module that need to be updated accordingly.
Table 12-28 Other System Parameters - Retail Price
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | ITEM_CONSIGNMENT_PRICING_IND |
Check if pricing consignment is enable or disable. |
N | NA |
Application Configuration
Listed below are configurations defined at Global Level for the Module or Supplier Level for supplier specific configuration in the Module.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS once specific suppliers are configured the details will be stored in ORCV_PRFL_CFG_APP_SUPP_OPTIONS.
Table 12-29 Application Configuration - Retail Price
| ATTRIBUTE ID | DESCRIPTION | VALU E | CONFIGURATI ON LEVEL |
|---|---|---|---|
| ALLOW_PRICE_CHANGES | Allow Supplier Price Changes. | Y | Supplier |
| ALLOW_RET_USER_EMER_EVENTS | Allow Retailer Users to create emergency events. | Y | Supplier |
| ALLOW_SIMPLE_PROMO | Allow Supplier Simple Promotions. | Y | Supplier |
| ALLOW_SUP_USER_EMER_EVENTS | Allow Suppliers Users to create emergency events. | N | Supplier |
| ALLOW_ZONE_LEVEL_EVENTS | Allow Zone Level Events. | N | Supplier |
| PRICE_EVENT_TOLERANCE | Change % Tolerance to classify the New Price as Substantial Change. | 20 | Supplier |
| SUP_PRM_END_DATE_REQ | Promotion End Date Required. | Y | Supplier |
| SUP_ZONE_GROUP_PRC | Zone Group Display ID to be used by Price Changes. | 1 | Supplier |
| SUP_ZONE_GROUP_PRM | Zone Group Display ID to be used by Simple Promotions. | 1 | Supplier |
Financial Summary
This Module has multiple configurations to support its functionalities and, in the subsections, below, those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide , Supply Chain Hub Frameworks section.
System Parameters
Listed below are the system level configurations in this Module. Those configurations include specific configurations for the Module and purge parameters used by Purge
Chapter 23
Other Cloud Services Configuration
Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-30 System Parameters - Financial Summary
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | SPFS_DOCT_TYPE | Doc Type used at Financial Summary MV. | CRDNT | NA |
| CONFIG | SPFS_DOCT_TYPE | Doc Type used at Financial Summary MV. | MRCHI | NA |
| CONFIG | YTD | Year To Date used in Financial Summary Dashboard. Value_1 YTD start month, Value_2 YTD start day. | 1 | 1 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPFS_SUB_PAYMENT_DOC | 7 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPFS_SUB_PAYMENT_HEAD | 7 |
| PURGE | PURGE_DAYS | Default purge Period. | ORCV_SPFS_SUB_PAYMENT_HEAD_ERR | 7 |
Appointments Management
This Module has multiple configurations to support its functionalities and, in the subsections, below, those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Listed below are the system level configurations in this Module. Those configurations include specific configurations for the Module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
Table 12-31 System Parameters - Appointments Management
| ARE A | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | APPT_APPR_REASON_CODE | The Reason Code Value for Appointments Approve. | ARCA | NA |
| CONFIG | APPT_APPR_REASON_CODE_S9T | The Reason Code Value for Appointments Approve via Upload. | ARAU | NA |
| CONFIG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | CD | NA |
| CONFIG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | CPO | NA |
| CONFIG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | CRTV | NA |
| CONFIG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | DD | NA |
| CONFIG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | SLUV | NA |
| CONFIG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | UD | NA |
| CONFIG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | UPO | NA |
| CON IG | APPT_CANC_REASON_CODES | The Reason Codes Values for Appointments Cancel. | URTV | NA |
| CONFIG | APPT_CANC_REASON_C ODES_S9T | The Reason Code Value for Appointments Cancel via Upload. | ACUP | NA |
| CONFIG | APPT_CHK_IN_REASON_CODE | The Reason Code Value for Appointments Check-In. | ARCI | NA |
| CONFIG | APPT_CHK_IN_REASON_CODE_S9T | The Reason Code Value for Appointments Check-In via Upload. | ACIU | NA |
| CONFIG | APPT_MAX_DAYS_RANGE | Maximum number of days in advance to book appointments. | 90 | NA |
| CONFIG | APPT_RCV_REASON_CODE | The Reason Code Value for Appointments Receive. | ARCR | NA |
| CONFIG | APPT_RCV_REASON_CODE_S9T | The Reason Code Value for Appointments Receive via Upload. | ARRU | NA |
| CONFIG | AVL_EXCEPTION_MAX_DAYS_RANGE | Maximum number of days in advance to create availability exceptions. | 90 | NA |
| PURGE | PURGE_DAYS_APPT_ST_ NEW | Default purge days period for appointment in status NEW. | ORCV_SPAP_APPOINTMENT | 30 |
| PURGE | PURGE_DAYS_APPT_ST_ OTHER | Default purge days period for appointment in status other status than NEW. | ORCV_SPAP_APPOINTMENT | 365 |
| PURGE | PURGE_DAYS_SLOT_AVL_EXCEPT | Default purge days period for slot availability exceptions. | ORCV_SPAP_SLOTS_AVL_EXCEPT | 30 |
Application Configuration
The list below is the list of configurations at a global level that are used by this application.
The parameters are defined in the ORCV_PRFL_CFG_APP_OPTIONS table.
Table 12-32 Application Configurations - Appointments Management
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | ATTRIBUTE VALUE | CFG LEVEL |
|---|---|---|---|
| APPT_EXPIRE_DEADLINE_DAYS | The number of days after an unclosed appointment will be marked as Expired status. | 1 | Supplier |
Customer Order Fulfillment
This application has multiple configurations to support its functionalities and in the subsections below those configurations are highlighted. For some of them, it is imperative to validate the functionality of common frameworks in the Oracle Retail Supply Chain Collaboration Implementation Guide, Supply Chain Hub Frameworks section.
System Parameters
Listed below is the list of configurations at the system level used by this application. Those configurations include configurations specific to the module and purge parameters used by Purge Framework detailed in Implementation Guide - Supply Chain Hub Frameworks section. The parameters are defined in table ORCV_SYSTEM_PARAMETERS and below are listed the default values.
Table 12-33 System Parameters - Customer Order Fulfillment
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALU E 2 |
|---|---|---|---|---|
| CONFG |
CUSTOMER_OR DER_ MASTER |
Value to determine the system that manages Customer Order. Valid values: SPCO, MFCS. | MFCS | NA |
| CONFIG | DISPATCH_NOT _ INVOICED_DAY S | Number of days since Customer Order was dispatched and not invoiced to trigger Event Alert. | 7 | NA |
| CONFIG | SPCO_REPORT_ BI | Value to determine the Report ID to generate the Customer Order Bi Publisher report. | REPORT_PDF_SPCO_COF | NA |
| CONFIG |
SPCO_SUPPORT_CANCEL |
Value to determine if OMS is capable of receiving FO cancellation from Supplier or SCH.COF module. Valid values: Y/N. | Y | NA |
| PURGE | PURGE_DAYS | Default purge Period for Control tables. | ORCV_SPCO_ORDCUST_CONTROL | 30 |
| PURGE | PURGE_DAYS | Default temporary table purge Period. | ORCV_SPCO_ORDCUST_DETAIL_TMP | 2 |
| PURGE | PURGE_DAYS | Default purge Period for DOC table. | ORCV_SPCO_ORDCUST_FDOC | 30 |
| PURGE | PURGE_DAYS | Default purge Period for Completed/Cancelled Customer Orders Header table. | ORCV_SPCO_ORDCUST_HEAD | 30 |
| PURGE | PURGE_DAYS | Default purge Period for History tables. | ORCV_SPCO_ORDCUST_HEAD_HIST | 30 |
| PURGE | PURGE_DAYS | Default temporary table purge Period. | ORCV_SPCO_ORDCUST_HEAD_TMP | 2 |
Custom Validations Framework
System Parameters
Listed below are the system level configurations used by this application. These configurations include purge parameters used by Purge Framework. The parameters are defined in table ORCV_SYSTEM_PARAMETERS. The default values are listed below.
| Area | Parameter | Description | Value 1 | Value 2 |
|---|---|---|---|---|
| PURGE | PURGE_DAYS | Default purge period. | ORCV_CVAL_PROCESS_ATTRIBUTES | 30 |
| PURGE | PURGE_DAYS | Default purge period. | ORCV_CVAL_PROCESS_CONTROL | 30 |
| PURGE | PURGE_DAYS | Default purge period. | ORCV_CVAL_RESULT | 30 |