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 |
|---|---|---|---|
| PURG E | 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 |
|---|---|---|---|---|
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORDHEAD_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORDHEAD_ITEM S_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORDLOC_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORD_ITEMS_TM P | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_ORD_NEW_ITEM S_TMP | 2 |
Application Configuration
Table 12-5 Application Configuration - Purchase Orders
| ATTRIBUTE ID | ATTRIBUTE DESCRIPTION | DEFAULT VALUE | CONFIGURATIO N LEVEL |
|---|---|---|---|
| DELIVERY_NBD_N AD | 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_ORDE R_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_TOLER ANCE | 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_DA YS | 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 |
|---|---|---|---|---|
| CONFI G | DOCS_LOV_CR E | Code Head associated to LOV for creation mode on DOCS screen | DOCC | NA |
| CONFI G | DOCS_LOV_VI EW | Code Head associated to LOV for view mode on DOCS screen | DOCV | NA |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ADD_ITEM_ TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_HEAD_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ITEM_TAX_ TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ITEM_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPPP_DOC_ORDRTV_T MP | 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_TY PE | Used in GTS calculation taxes. Valid values are B for Both, C for cost, R for retail, or N for non-merchandise | C | NA |
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 |
|---|---|---|---|---|
| CONF IG | CANCEL_S9T_DEFAULT_RE ASON | Default S9T Reason code when a RTV is canceled | C9 | NA |
| CONF IG | REJECT_S9T_DEFAULT_REA SON | Default S9T Reason code when a RTV is rejected | R9 | NA |
| CONF IG | UNAVAILABLE_DISP_CODE | MFCS Disposition Code for the U (Unavailable) reason code. | ATS | NA |
| PURG E | PURGE_DAYS | Default purge period for hist tables. | ORCV_SPRV_RTV_ HEAD_HIST | 60 |
| PURG E | PURGE_DAYS | Default purge period for stg tables. | ORCV_SPRV_RTV_ HEAD_STG | 30 |
| PURG E | 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 |
|---|---|---|---|---|
| CONF IG | NUMBER_WEEKS_SALES_FOR ECAST | 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 |
| CONF IG | NUMBER_WEEKS_SALES_HIS T | 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_THRESH OLD | 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_OPTIO N | Option to add new diffs. Y-Active, N-Inactive | N | NA |
| CONFIG | BARCODE_TYPES_G RANTED | List of valid Barcode types that can be assigned to items. | EAN13 | NA |
| CONFIG | BARCODE_TYPES_G RANTED | List of valid Barcode types that can be assigned to items. | ITEM | NA |
| CONFIG | BARCODE_TYPES_G RANTED | List of valid Barcode types that can be assigned to items. | MANL | NA |
| CONFIG | BARCODE_TYPES_G RANTED | 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_I ND |
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_U OM |
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_RUNNIN G | 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_CONFI G | 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_ERR ORS_DETAIL | 30 |
| PURGE | PURGE_DAYS | Default purge period for staging tables. | ORCV_SPIM_ITEM_HEA DER | 30 |
| PURGE | PURGE_DAYS | Default purge period for temporary tables. | ORCV_SPIM_ITEM_HEA DER_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_CONSIGNME NT_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_MA X_AMOUNT | Maximum number of items that can be reserved via the item reserve web service. | 10 | NA |
| CONFIG | RESERVE_ITEM_MA X_EXPIRY | Maximum days until the item reservation expires. | 1 | NA |
| INTEGRATI ON | INDUCTION_TEMPL ATE | Template key. | ORCV_S9T_MFCS_ITEMS_I NDUCTION_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 | VALU E 2 |
|---|---|---|---|---|
| CONF IG | COST_PRIOR_BLOCK_DAYS | Number of days to block Cost Change until publish to MFCS | 1 | NA |
| CONF IG | COST_PRIOR_DEADLINE_D AYS | Number of days that will be used to show cost change near deadline on dashboard. | 1 | NA |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPCC_COSTCHG_HEAD | 30 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPCC_COSTCHG_HEAD_ TMP | 2 |
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.
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-17 Application Configuration - Cost Changes Management
| ATTRIBUTE ID | DESCRIPTION | VALU E | CONFIGURATION LEVEL |
|---|---|---|---|
| COST_CHANGE_TOLER ANCE | 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-18 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-19 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-20 System Parameters - Quality Control
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONF IG | COMPLETE_INSPECTI ON | Flag to define if all items checks must be done to complete Job. | Y | NA |
| CONF IG | UNAVAILABLE_DISP_ CODE | MFCS Disposition Code for the U (Unavailable) reason code. | ATS | NA |
| PURG E | PURGE_DAYS | Default purge period for stg tables. | ORCV_QLCT_JOB_HEAD | 60 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_HEAD_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_CHECK_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_ITEM_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_ITEM_CHECK_T MP | 2 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_QLCT_JOB_RESULT_TMP | 2 |
| PURG E | 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-21 Other System Parameters - Quality Control
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONF IG | CLOSE_SHIP_WAIT_T IME | 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-22 System Parameters - Deals Management
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONF IG | 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 |
| CONF IG | DISPLAY_CLOSED_DEALS_DAYS | Number of days closed deals in MFCS will continue to be displayed in SCH Deals management dashboards/screens. | 0 | NA |
| CONF IG | EXPLODE_MERCH_HIER_IND | Flag indicating whether the merch hierarchy should be exploded upon publishing. | N | NA |
| CONF IG | INCLUDE_CLOSED_DEALS_INCO ME | If closed deals income (under the DISPLAY_CLOSED_DEALS_ DAYS) will be included on the income dashboards or not. | N | NA |
| CONF IG | INT_DAYS_BEFORE_START | Minimum number of days prior to the start date for deal to be processed. | 2 | NA |
| CONF IG | 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 |
| CONF IG | SUPPORTED_BILLING_TYPE | Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. | BB | NA |
| CONF IG | SUPPORTED_BILLING_TYPE | Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. | BBR | NA |
| CONF IG | SUPPORTED_BILLING_TYPE | Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. | VFP | NA |
| PURG E | PRG_NEW_SUB_DAYS | Number of days after which new and submitted deals will be purged. | 28 | NA |
| PURG E | PRG_REJ_DAYS | Number of days after which rejected deals will be purged. | 7 | NA |
| PURG E | PURGE_DAYS | Default purge Period. |
ORCV_SPDM_ DEAL_HEAD_T MP |
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-23 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-24 System Parameters - Supplier Penalties
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFI G | REQ_SUPP_APPROVE | Indicates if the Penalty Rules approval for all suppliers is needed(Y-Yes/N-No). | N | NA |
| PURG E | PURGE_DAYS | Default purge period for stg tables. | ORCV_SPPY_PE NALTY_HEAD | 60 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_SPPY_PE NALTY_ITEM_T MP | 2 |
| PURG E | PURGE_DAYS | Default purge period for tmp tables. | ORCV_SPPY_PE NALTY_HEAD_T MP | 2 |
| PURG E | PURGE_DAYS | Default purge period for rule engine tmp tables. | ORCV_SPPY_RLE G_SHIP_STG | 7 |
| PURG E | PURGE_DAYS | Default purge period for rule engine tmp tables. | ORCV_SPPY_RLE G_PO_STG | 7 |
| PURG E | PURGE_DAYS | Default purge period for rule engine tmp tables. | ORCV_SPPY_RLE G_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-25 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_APPR OVE | 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-26 System Parameters - Retail Price
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFI G | PRICE_EVENT_DUE_D AYS | Number of days prior to a price event to trigger the e-mail alert notification before approval. | 7 | NA |
| CONFI G |
PRICE_PRIOR_DEADLI NE_ DAYS |
Number of Deadline days. | 1 | NA |
| CONFI G | PROMO_END_TIME | Promotion default end time. | 23:59 | NA |
| CONFI G | PROMO_START_TIME | Promotion default start time. | 00:00 | NA |
| CONFI G | S9T_REASON_CODE | Default reason code used by S9T. Corresponding code type is PERR. | 6 | NA |
| CONFI G | SEARCH_MAX_RANGE | Dashboard Past Window (in days) | 30 | NA |
| PURG E | PURGE_DAYS | Default purge period. | ORCV_SPPM _ PRICE_EVEN T | 30 |
Other System Parameters
In the table below are the System Parameters of Items module that need to be updated accordingly.
Table 12-27 Other System Parameters - Retail Price
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONFIG | ITEM_CONSIGNME NT_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-28 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_EVE NTS | 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-29 System Parameters - Financial Summary
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONF IG | SPFS_DOCT_T YPE | Doc Type used at Financial Summary MV. | CRDNT | NA |
| CONF IG | SPFS_DOCT_T YPE | Doc Type used at Financial Summary MV. | MRCHI | NA |
| CONF IG | YTD | Year To Date used in Financial Summary Dashboard. Value_1 YTD start month, Value_2 YTD start day. | 1 | 1 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPFS_SUB_PAYMENT_DO C | 7 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPFS_SUB_PAYMENT_HE AD | 7 |
| PURG E | PURGE_DAYS | Default purge Period. | ORCV_SPFS_SUB_PAYMENT_HE AD_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-30 System Parameters - Appointments Management
| ARE A | PARAMETER | DESCRIPTION | VALUE 1 | VALUE 2 |
|---|---|---|---|---|
| CONF IG | APPT_APPR_REASON_CO DE | The Reason Code Value for Appointments Approve. | ARCA | NA |
| CONF IG | APPT_APPR_REASON_CO DE_S9T | The Reason Code Value for Appointments Approve via Upload. | ARAU | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | CD | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | CPO | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | CRTV | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | DD | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | SLUV | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | UD | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | UPO | NA |
| CONF IG | APPT_CANC_REASON_C ODES | The Reason Codes Values for Appointments Cancel. | URTV | NA |
| CONF IG | APPT_CANC_REASON_C ODES_S9T | The Reason Code Value for Appointments Cancel via Upload. | ACUP | NA |
| CONF IG | APPT_CHK_IN_REASON_ CODE | The Reason Code Value for Appointments Check-In. | ARCI | NA |
| CONF IG | APPT_CHK_IN_REASON_ CODE_S9T | The Reason Code Value for Appointments Check-In via Upload. | ACIU | NA |
| CONF IG | APPT_MAX_DAYS_RANG E | Maximum number of days in advance to book appointments. | 90 | NA |
| CONF IG | APPT_RCV_REASON_CO DE | The Reason Code Value for Appointments Receive. | ARCR | NA |
| CONF IG | APPT_RCV_REASON_CO DE_S9T | The Reason Code Value for Appointments Receive via Upload. | ARRU | NA |
| CONF IG | AVL_EXCEPTION_MAX_D AYS_RANGE | Maximum number of days in advance to create availability exceptions. | 90 | NA |
| PURG E | PURGE_DAYS_APPT_ST_ NEW | Default purge days period for appointment in status NEW. | ORCV_SPAP_APPOINTM ENT | 30 |
| PURG E | PURGE_DAYS_APPT_ST_ OTHER | Default purge days period for appointment in status other status than NEW. | ORCV_SPAP_APPOINTM ENT | 365 |
| PURG E | 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-31 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-32 System Parameters - Customer Order Fulfillment
| AREA | PARAMETER | DESCRIPTION | VALUE 1 | VALU E 2 |
|---|---|---|---|---|
| CONF IG |
CUSTOMER_OR DER_ MASTER |
Value to determine the system that manages Customer Order. Valid values: SPCO, MFCS. | MFCS | NA |
| CONF IG | DISPATCH_NOT _ INVOICED_DAY S | Number of days since Customer Order was dispatched and not invoiced to trigger Event Alert. | 7 | NA |
| CONF IG | SPCO_REPORT_ BI | Value to determine the Report ID to generate the Customer Order Bi Publisher report. | REPORT_PDF_SPCO_COF | NA |
| CONF IG |
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 |
| PURG E | PURGE_DAYS | Default purge Period for Control tables. | ORCV_SPCO_ORDCUST_CONT ROL | 30 |
| PURG E | PURGE_DAYS | Default temporary table purge Period. | ORCV_SPCO_ORDCUST_DETAI L_TMP | 2 |
| PURG E | PURGE_DAYS | Default purge Period for DOC table. | ORCV_SPCO_ORDCUST_FDOC | 30 |
| PURG E | PURGE_DAYS | Default purge Period for Completed/Cancelled Customer Orders Header table. | ORCV_SPCO_ORDCUST_HEAD | 30 |
| PURG E | PURGE_DAYS | Default purge Period for History tables. | ORCV_SPCO_ORDCUST_HEAD _HIST | 30 |
| PURG E | PURGE_DAYS | Default temporary table purge Period. | ORCV_SPCO_ORDCUST_HEAD _TMP | 2 |