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 Editable
PURGE PURGE_DAYS Number of days post expiration Operational News data is purged 30 Yes

Note:

Within the user interface, the Data Administration module includes selected system parameters available for editing.

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 Editable
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ORDHEAD_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ORDHEAD_ITEMS_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ORDLOC_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ORD_ITEMS_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ORD_NEW_ITEMS_TMP 2 Yes

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

Other System Parameters

In the table below are the System Parameters of Orders module that need to be updated accordingly.

Table 12-6 Other System Parameters - Procure to Pay - Purchase Orders

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
INTEGRATION INDUCTION_TEMPLATE Template key. PURCHASE_ORDER_DATA NA Yes

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-7 System Parameters - Shipments

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ASN_ORD_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ASN_ORD_ITEM_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ASN_ADD_ITEM_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_ASN_CTN_TMP 2 Yes

Application Configuration

Table 12-8 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-9 System Parameters - Finance Documents

AREA PARAMETER DESCRIPTION VALUE 1 VAL UE 2 Editable
CONFIG DOCS_LOV_CRE Code Head associated to LOV for creation mode on DOCS screen DOCC NA No
CONFIG DOCS_LOV_VIEW Code Head associated to LOV for view mode on DOCS screen DOCV NA No
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_DOC_ADD_ITEM_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_DOC_HEAD_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_DOC_ITEM_TAX_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_DOC_ITEM_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPPP_DOC_ORDRTV_TMP 2 Yes

Other System Parameters

In the table below are the System Parameters of Finance module that need to be updated accordingly.

Table 12-10 Other System Parameters - Finance Documents

AREA PARAMETER DESCRIPTION VALUE 1 VAL UE 2 Editable
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 Yes
PURGE PURGE_DAYS Default purge period. ORCV_FIN_INT_DOC_XREF 30 Yes

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-11 System Parameters - Return to Vendor

AREA PARAMETER DESCRIPTION VALUE 1 Value 2 Editable
CONFIG CANCEL_S9T_DEFAULT_REASON Default S9T Reason code when a RTV is canceled C9 NA No
CONFIG REJECT_S9T_DEFAULT_REASON Default S9T Reason code when a RTV is rejected R9 NA No
CONFIG UNAVAILABLE_DISP_CODE MFCS Disposition Code for the U (Unavailable) reason code. ATS NA No
PURGE PURGE_DAYS Default purge period for hist tables. ORCV_SPRV_RTV_HEAD_HIST 60 Yes
PURGE PURGE_DAYS Default purge period for stg tables. ORCV_SPRV_RTV_HEAD_STG 30 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_SPRV_RTV_HEAD_TMP 2 Yes

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-12 System Parameters - Inventory and Sales

AREA PARAMETER DESCRIPTION VALU E 1 Value 2 Editable
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 Yes
CONFIG NUMBER_WEEKS_SALES_HIST Number of weeks to display in Sales Details screen of Inventory and Sales 5 NA Yes

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-13 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-14 System Parameters - Item Management

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG ADD_DIFFS_OPTION Option to add new diffs. Y-Active, N-Inactive N NA Yes
CONFIG BARCODE_TYPES_GRANTED List of valid Barcode types that can be assigned to items. EAN13 NA No
CONFIG BARCODE_TYPES_GRANTED List of valid Barcode types that can be assigned to items. ITEM NA No
CONFIG BARCODE_TYPES_GRANTED List of valid Barcode types that can be assigned to items. MANL NA No
CONFIG BARCODE_TYPES_GRANTED List of valid Barcode types that can be assigned to items. UPC-A NA No
CONFIG DIFFS_QUEUE_NAM E This will hold the diffs default queue name for Items Management ORCV_SPIM_DIFF_AQ NA No
CONFIG DIFF_AGGREGATE_IND

Default value for

Diff_Aggregate_Ind. Valid values: Y, N(Default)

N NA Yes
CONFIG DIFF_CRE_SINGLE_SKU Default differentiator group/id for create single SKU option. DIFF_GRP_ID DIFF_ID No
CONFIG EXCLUDED_UDA UDAs that should be excluded from the user assigning to an item. OFF_SALE_DATE 9003 Yes
CONFIG EXCLUDED_UDA UDAs that should be excluded from the user assigning to an item. ON_SALE_DATE 9002 Yes
CONFIG EXCLUDED_UDA UDAs that should be excluded from the user assigning to an item. STOCK_AVAIL 9004 Yes
CONFIG EXPLD_ALL_SKUS Flag indicating whether all Style entities are exploded to child SKUs. Y NA Yes
CONFIG GENERATE_EAN Defines if the Generate EAN functionality is enabled. Y NA Yes
CONFIG IMAGE_TYPE Default type of image M NA No
CONFIG ITEM_S9T_REASON_CODE Default reason code for S9T Update Details S NA No
CONFIG ITEM_STANDARD_UOM

Default Items

Management Standard UOM.

EA NA No
CONFIG ITEM_STORE_ORD_MULT

Default Items

Management Store Ord Mult.

E NA No
CONFIG LOCATION_STATUS_GRANTED List of valid Location statuses that can be assigned to locations. A NA No
CONFIG LOCATION_STATUS_GRANTED List of valid Location statuses that can be assigned to locations. C NA No
CONFIG MAX_JOBS_RUNNING Maximum jobs to run in parallel to process items. 16 NA Yes
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 Yes
CONFIG PRICE_CALC_CONFIG Controls what method is being used for price calculation. Possible values are MFCS and STRAT. MFCS NA No
CONFIG PRICE_CALC_REQ Controls if price calculation is mandatory. Possible values are Y and N. N NA Yes
CONFIG PRICE_CALC_TRIGGER Controls what service is being used for price calculation. Use ids from ORCV_PRICE_CALC_CONF IG. -1 NA No
CONFIG PURCHASE_TYPE Default purchase type 0 NA No
CONFIG QUEUE_NAME This will hold the default queue name for Items Management ORCV_SPIM_ITEM_AQ NA No
CONFIG REFS Flag indicating whether all refs should be displayed or not N NA Yes
CONFIG REF_ATTR Flag indicating whether modal with reference attributes should be displayed or not Y NA Yes
CONFIG REF_ATTR_RETAILE R Flag indicating whether modal with reference attributes should be displayed if user is a retailer or not N NA Yes
CONFIG ROUND_LVL Defines how order quantities will be rounded to Case, Layer and Pallet. C NA No
CONFIG ROUND_TO_CASE_PCT This will hold the case Rounding Threshold value. 50.0000 NA Yes
CONFIG ROUND_TO_INNER_ PCT This will hold the Inner Rounding Threshold value. 50.0000 NA Yes
CONFIG ROUND_TO_LAYER_PCT This will hold the layer Rounding Threshold value. 50.0000 NA Yes
CONFIG ROUND_TO_PALLET_PCT This will hold the pallet Rounding Threshold value. 50.0000 NA Yes
NOTIF_CON FIG ITEMS_PENDING_ACTION_DAYS Number of days to generate alerts for items with pending actions. 1 NA Yes
PURGE PURGE_DAYS Default purge period for error tables. ORCV_SPIM_ITEM_ERRORS_DETAIL 30 Yes
PURGE PURGE_DAYS Default purge period for staging tables. ORCV_SPIM_ITEM_HEADER 30 Yes
PURGE PURGE_DAYS Default purge period for temporary tables. ORCV_SPIM_ITEM_HEADER_TMP 30 Yes

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-15 Other System Parameters - Items Management

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG ITEM_CONSIGNMENT_PRICING_IND

Check if pricing

consignment is enable or disable.

N NA Yes
CONFIG ITEM_INT_REVISIO N_UDA UDA that must be used exclusively in the integration process. 9001 NA Yes
CONFIG RESERVE_ITEM_MAX_AMOUNT Maximum number of items that can be reserved via the item reserve web service. 10 NA Yes
CONFIG RESERVE_ITEM_MAX_EXPIRY Maximum days until the item reservation expires. 1 NA Yes
INTEGRATI ON INDUCTION_TEMPLATE Template key. ITEM_MASTER_DATA NA No
PURGE PURGE_DAYS Default purge Period. ORCV_ITEM_INT_ILTRT 30 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_ITEM_INT_MASTER 30 Yes

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-16 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-17 System Parameters - Cost Changes Management

Area Parameter Description Value 1 Value 2 Value 3 Editable
CONFIG COST_PRIOR_BLOCK_DAYS Number of days to block Cost Change until MFCS integration. 1 NA NA Yes
CONFIG COST_PRIOR_DEADLINE_DAYS Number of deadline days. 1 NA NA No
CONFIG DEFAULT_COST_CHG_LVL Supplier default Cost Change Level (Valid Values: UNIT, INNER, CASE). UNIT NA NA Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPCC_COSTCHG_HEAD 30 NA Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPCC_COSTCHG_HEAD_TMP 2 NA No
REASON_CODES AUTO Reason Code Code (VALUE_3) to be used in automation of Action (VALUE_2) for Entity (VALUE_1). COSTCHG APPROVE APRVCC No
REASON_CODES AUTO Reason Code Code (VALUE_3) to be used in automation of Action (VALUE_2) for Entity (VALUE_1). COSTCHG REJECT RJCTCC No
REASON_CODES CODES Reason Codes Code Type (VALUE_2) for Entity (VALUE_1). COSTCHG CCRC NA No
REASON_CODES HIDE_CODES Reason Codes Hide Code Type (VALUE_3) to hide from the CODES (Parameter) code type (VALUE_2). COSTCHG REJECT CCHR No
REASON_CODES HIDE_CODES Reason Codes Hide Code Type (VALUE_3) to hide from the CODES (Parameter) code type (VALUE_2). COSTCHG UPDATE CCHU No
CONFIG COST_PRIOR_DEADLINE_DAYS Number of deadline days. 1 NA NA Yes

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-18 Cost Changes Management - Other System Parameters

Area Parameter Description Value 1 Value 2 Editable
PURGE PURGE_DAYS Default purge Period. ORCV_COSTS_INT_CC_HEAD_PUBINFO 30 Yes
INTEGRATION INDUCTION TEMPLATE Template Key COST_CHANGE NA No

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-19 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-20 System Parameters - Supplier Performance

AREA PARAMETER DESCRIPTI ON VALUE 1 VALU E 2 Editable
CONFIG COMP_ERROR Minimum Compliance Error Level 3 NA Yes
CONFIG DEFECT_REASON Adj Reason Code 5 NA No
CONFIG DEFECT_REASON Adj Reason Code 60 NA No
CONFIG DEFECT_REASON Adj Reason Code 93 NA No
CONFIG EARLY_LATE_DAYS Number of days to be considered as Early/ Late receipt 3 NA Yes
CONFIG METRIC_DAYS_WINDOW Maximum window to be used for ASN and Invoices Metrics 30 NA Yes
CONFIG QUEST_MIN_FREQ

Questionnai re

Minimum Frequency (in days)

365 NA Yes
CONFIG RECEIVE_WAIT_DAYS Time to wait for receipt to finish (in days) 7 NA Yes
CONFIG RTV_REASON RTV Reason Code U NA No
CONFIG RTV_REASON RTV Reason Code W NA No
CONFIG SCORE_AVG_DAYS

Score

Moving

Average

Days

365 NA No
PURGE PURGE_DAYS Default purge period for questionnai re revision tables ORCV_SPPF_QUESTN_HEAD_ REV 730 Yes
PURGE PURGE_DAYS Default purge period for reply tables ORCV_SPPF_QUESTN_REPLY_ HEAD 730 Yes
PURGE PURGE_DAYS Default purge period for supplier score tables ORCV_SPPF_SUPP_SCORE_HIS T 730 Yes

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-21 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-22 System Parameters - Quality Control

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG COMPLETE_INSPECTION Flag to define if all items checks must be done to complete Job. Y NA Yes
CONFIG UNAVAILABLE_DISP_CODE MFCS Disposition Code for the U (Unavailable) reason code. ATS NA No
PURGE PURGE_DAYS Default purge period for stg tables. ORCV_QLCT_JOB_HEAD 60 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_QLCT_JOB_HEAD_TMP 2 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_QLCT_JOB_CHECK_TMP 2 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_QLCT_JOB_ITEM_TMP 2 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_QLCT_JOB_ITEM_CHECK_TMP 2 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_QLCT_JOB_RESULT_TMP 2 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_QLCT_JOB_ITEM_RESULT_TMP 2 Yes

Other System Parameters

In the table below are the System Parameters of Shipments module that need to be updated accordingly.

Table 12-23 Other System Parameters - Quality Control

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG CLOSE_SHIP_WAIT_TIME Wait time in Hours for WMS to close Shipment 24 NA Yes

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-24 System Parameters - Deals Management

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG ASSOCIATE_PROMO Determines if for a VPF Deal the system should allow associate a promotion. Button available -'Y' or disabled - 'N' Y NA Yes
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 No
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 Yes
CONFIG EXPLODE_MERCH_HIER_IND Flag indicating whether the merch hierarchy should be exploded upon publishing. N NA Yes
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 Yes
CONFIG INT_DAYS_BEFORE_START Minimum number of days prior to the start date for deal to be processed. 2 NA Yes
CONFIG RECALCULATE_OPEN_PO

Determines if open PO's

will be recalculated for

new Off-Invoice Deals.

N NA Yes
CONFIG SUPPORTED_BILLING_TYPE Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. BB NA No
CONFIG SUPPORTED_BILLING_TYPE Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. BBR NA No
CONFIG SUPPORTED_BILLING_TYPE Supported Billing types, currently only supports Bill-Back, Bill-Back Rebate and Vendor Funded Promotions. VFP NA No
PURGE PRG_NEW_SUB_DAYS Number of days after which new and submitted deals will be purged. 28 NA Yes
PURGE PRG_REJ_DAYS Number of days after which rejected deals will be purged. 7 NA Yes
PURGE PURGE_DAYS Default purge Period.

ORCV_SPDM_DEAL_HEAD_TMP

2 Yes

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-25 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-26 System Parameters - Supplier Penalties

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG REQ_SUPP_APPROVE Indicates if the Penalty Rules approval for all suppliers is needed(Y-Yes/N-No). N NA Yes
PURGE PURGE_DAYS Default purge period for stg tables. ORCV_SPPY_PENALTY_HEAD 60 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_SPPY_PENALTY_ITEM_T MP 2 Yes
PURGE PURGE_DAYS Default purge period for tmp tables. ORCV_SPPY_PENALTY_HEAD_T MP 2 Yes
PURGE PURGE_DAYS Default purge period for rule engine tmp tables. ORCV_SPPY_RLEG_SHIP_STG 7 Yes
PURGE PURGE_DAYS Default purge period for rule engine tmp tables. ORCV_SPPY_RLEG_PO_STG 7 Yes
PURGE PURGE_DAYS Default purge period for rule engine tmp tables. ORCV_SPPY_RLEG_QA_STG 7 Yes

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-27 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-28 System Parameters - Retail Price

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG PRICE_EVENT_DUE_DAYS Number of days prior to a price event to trigger the e-mail alert notification before approval. 7 NA Yes
CONFIG

PRICE_PRIOR_DEADLINE_DAYS

Number of Deadline days. 1 NA Yes
CONFIG PROMO_END_TIME Promotion default end time. 23:59 NA No
CONFIG PROMO_START_TIME Promotion default start time. 00:00 NA No
CONFIG S9T_REASON_CODE Default reason code used by S9T. Corresponding code type is PERR. 6 NA No
CONFIG SEARCH_MAX_RANGE Dashboard Past Window (in days) 30 NA Yes
PURGE PURGE_DAYS Default purge period. ORCV_SPPM_PRICE_EVENT 30 Yes

Other System Parameters

In the table below are the System Parameters of Items module that need to be updated accordingly.

Table 12-29 Other System Parameters - Retail Price

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG ITEM_CONSIGNMENT_PRICING_IND

Check if pricing

consignment is enable or disable.

N NA Yes

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-30 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-31 System Parameters - Financial Summary

AREA PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG SPFS_DOCT_TYPE Doc Type used at Financial Summary MV. CRDNT NA No
CONFIG SPFS_DOCT_TYPE Doc Type used at Financial Summary MV. MRCHI NA No
CONFIG YTD Year To Date used in Financial Summary Dashboard. Value_1 YTD start month, Value_2 YTD start day. 1 1 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPFS_SUB_PAYMENT_DOC 7 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPFS_SUB_PAYMENT_HEAD 7 Yes
PURGE PURGE_DAYS Default purge Period. ORCV_SPFS_SUB_PAYMENT_HEAD_ERR 7 Yes

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-32 System Parameters - Appointments Management

ARE A PARAMETER DESCRIPTION VALUE 1 VALUE 2 Editable
CONFIG APPT_APPR_REASON_CODE The Reason Code Value for Appointments Approve. ARCA NA No
CONFIG APPT_APPR_REASON_CODE_S9T The Reason Code Value for Appointments Approve via Upload. ARAU NA No
CONFIG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. CD NA No
CONFIG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. CPO NA No
CONFIG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. CRTV NA No
CONFIG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. DD NA No
CONFIG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. SLUV NA No
CONFIG APPT_CANC_REASON_C ODES The Reason Codes Values for Appointments Cancel. UD NA No
CONFIG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. UPO NA No
CON IG APPT_CANC_REASON_CODES The Reason Codes Values for Appointments Cancel. URTV NA No
CONFIG APPT_CANC_REASON_C ODES_S9T The Reason Code Value for Appointments Cancel via Upload. ACUP NA No
CONFIG APPT_CHK_IN_REASON_CODE The Reason Code Value for Appointments Check-In. ARCI NA No
CONFIG APPT_CHK_IN_REASON_CODE_S9T The Reason Code Value for Appointments Check-In via Upload. ACIU NA No
CONFIG APPT_MAX_DAYS_RANGE Maximum number of days in advance to book appointments. 90 NA Yes
CONFIG APPT_RCV_REASON_CODE The Reason Code Value for Appointments Receive. ARCR NA No
CONFIG APPT_RCV_REASON_CODE_S9T The Reason Code Value for Appointments Receive via Upload. ARRU NA No
CONFIG AVL_EXCEPTION_MAX_DAYS_RANGE Maximum number of days in advance to create availability exceptions. 90 NA Yes
PURGE PURGE_DAYS_APPT_ST_ NEW Default purge days period for appointment in status NEW. ORCV_SPAP_APPOINTMENT 30 Yes
PURGE PURGE_DAYS_APPT_ST_ OTHER Default purge days period for appointment in status other status than NEW. ORCV_SPAP_APPOINTMENT 365 Yes
PURGE PURGE_DAYS_SLOT_AVL_EXCEPT Default purge days period for slot availability exceptions. ORCV_SPAP_SLOTS_AVL_EXCEPT 30 Yes

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-33 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-34 System Parameters - Customer Order Fulfillment

AREA PARAMETER DESCRIPTION VALUE 1 VALU E 2 Editable
CONFG

CUSTOMER_OR DER_

MASTER

Value to determine the system that manages Customer Order. Valid values: SPCO, MFCS. MFCS NA Yes
CONFIG DISPATCH_NOT _ INVOICED_DAY S Number of days since Customer Order was dispatched and not invoiced to trigger Event Alert. 7 NA Yes
CONFIG SPCO_REPORT_ BI Value to determine the Report ID to generate the Customer Order Bi Publisher report. REPORT_PDF_SPCO_COF NA No
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 Yes
PURGE PURGE_DAYS Default purge Period for Control tables. ORCV_SPCO_ORDCUST_CONTROL 30 Yes
PURGE PURGE_DAYS Default temporary table purge Period. ORCV_SPCO_ORDCUST_DETAIL_TMP 2 Yes
PURGE PURGE_DAYS Default purge Period for DOC table. ORCV_SPCO_ORDCUST_FDOC 30 Yes
PURGE PURGE_DAYS Default purge Period for Completed/Cancelled Customer Orders Header table. ORCV_SPCO_ORDCUST_HEAD 30 Yes
PURGE PURGE_DAYS Default purge Period for History tables. ORCV_SPCO_ORDCUST_HEAD_HIST 30 Yes
PURGE PURGE_DAYS Default temporary table purge Period. ORCV_SPCO_ORDCUST_HEAD_TMP 2 Yes

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.

Table 12-35 System Parameters - Custom Validations Framework

Area Parameter Description Value 1 Value 2 Editable
PURGE PURGE_DAYS Default purge period. ORCV_CVAL_PROCESS_ATTRIBUTES 30 Yes
PURGE PURGE_DAYS Default purge period. ORCV_CVAL_PROCESS_CONTROL 30 Yes
PURGE PURGE_DAYS Default purge period. ORCV_CVAL_RESULT 30 Yes