14 Return to Vendor
The Return to Vendor module is an application available in Supply Chain Hub. This chapter describes the implementation considerations and the operation details for this application.
Implementation Overview
Return to Vendor application gives the possibility to create and maintain returns to vendors (RTV).
Functionality
The RTV's can be created, updated, rejected, approved or cancelled in Return to Vendor module. When RTV's are approved or cancelled they are published to MFCS. All RTV's, even those created in MFCS, can be cancelled in Return to Vendor module.
Status Workflow
Figure 14-1 Return to Vendor Status Workflow
Return to Vendor follows a workflow path for RTV, and the status can change depending on:
- The user permissions.
- The current status of the RTV.
RTV Status:
- New (N) – Initial Status after submitting a new RTV.
- Waiting Authorization Code (W) - Status that denotes that the RTV is missing the Supplier Authorization code.
- Rejected (R) - Status used when a RTV is Rejected.
- Approved (A) - Status that denotes that the RTV creation is complete and ready to be shipped.
- Shipped (S) - Status when RTV was shipped to destination.
- Cancelled (X) - Status when RTV is Cancelled.
Configuration
This section describes configurations.
POM Configuration
Batch scheduler details with all batches, dependencies and frequencies can be downloaded following the steps in the Supply Chain Hub Frameworks section.
Other Cloud Services Configuration
This section describes implementation details that must be reviewed from an Oracle Retail Merchandising System perspective.
Reason Codes
The Reason Codes defined in MFCS CODE_HEAD and CODE_DETAIL tables with code type RTVR (Return to Vendor Reasons) are used to show LOVs on the screen and on S9T.
Other Implementation Considerations
This section describes Return to Vendor implementation considerations.
Custom Validations
The module performs validations by implementing Custom Validation Groups of the Custom Validations Framework described in the Supply Chain Hub Frameworks section. The groups are listed below.
SPRV_RTV_SUBMIT
Triggered when the Return to Vendor action is Submitted.
No custom validations exist by default for these custom validations group but can be added.
SPRV_RTV_REJECT
Triggered when the Return to Vendor action is Rejected.
No custom validations exist by default for these custom validations group but can be added.
Materialized Views
This application requires some results to be materialized in tables using the Materialized View Framework described in the Supply Chain Hub Frameworks section, below is the list for this application. Materialized views used in Cost Change Management are listed in this section.
ORCV_MV_SPRV_RTV_STAT_APPR
The materialized view has the IMCS RTVs in status 10 - Approved
Pre-Dependencies: N/A
Post-Dependencies: N/A
Frequency: Ad-hoc
ORCV_MV_SPRV_RTV_STAT_SHPD
The materialized view has the IMCS RTVs in 15 - Shipped status.
Pre-Dependencies: N/A
Post-Dependencies: N/A
Frequency: Ad-hoc
ORCV_MV_SPRV_RTV_BY_DEPT
The materialized view has the total RTV Order Amount by department from the last 30 days.
Pre-Dependencies: N/A
Post-Dependencies: N/A
Frequency: Ad-hoc
Codes
Certain operations require codes to define the options available. Below you can find the list of code types available. The codes are defined in tables ORCV_CODE_HEAD and ORCV_CODE_DETAIL.
| CODE TYPE | CODE TYPE DESCRIPTION |
|---|---|
| RTVC | Reason Codes to Cancel an RTV |
| RTVR | Reason Codes to Reject an RTV |
| RVAI | Available levels for Add Items to RTVs |
| RVAR | Return to Vendor Action Reason Code |
| RVDL | Return to Vendor Dashboard Labels |
| RVEL | Return to Vendor error levels to be used in the Issues List. |
| RVES | Return to Vendor error sources to be used in the error screen. |
Templates
Return to Vendor uses a spreadsheet download process, developed as part of the Retail Supply Chain Hub Frameworks for extraction of data. To support those functions, several different configurations should be reviewed as part of the implementation.
Template Return to Vendor
Table 14-1 Template key: ORCV_SPRV_RTV
| ACTION TYPE | ROLE NAME |
|---|---|
| Download | ORCV_SPRV_RTV_APPR_JOB |
| Download | ORCV_SPRV_RTV_EDIT_JOB |
| Download | ORCV_SPRV_RTV_VIEW_JOB |
| Download Blank | ORCV_SPRV_APP_JOB |
| Upload | ORCV_SPRV_RTV_APPR_JOB |
Table 14-2 Worksheet RTV Header
| ACTION | MANDATORY CELLS / FIELDS | NOTES |
|---|---|---|
| Create |
Action RTV Order Location Supplier |
Creates new RTV Order. |
| Update |
Action RTV Order Location Supplier |
Update RTV Order. |
| Approve |
Action RTV Order Location Supplier Authorization Code |
Approve RTV Order. |
| Cancel |
Action RTV Order Location Supplier |
Cancel RTV Order. |
| Reject |
Action RTV Order Location Supplier |
Reject RTV Order. |
Table 14-3 Worksheet RTV Details
| ACTION | MANDATORY CELLS / FIELDS | NOTES |
|---|---|---|
| Create |
Action RTV Order Item or Barcode Quantity Unit Cost Reason Inventory Type (If Reason is Unavailable) |
Add a new RTV Order Item. |
| Update |
Action RTV Order Item or Barcode Quantity Unit Cost Reason Inventory Type (If Reason is Unavailable) |
Update RTV Order Item. |
| Delete |
Action RTV Order Item or Barcode Quantity Unit Cost Reason Inventory Type (If Reason is Unavailable) |
Delete RTV Order Item. |
Codes
Certain operations require codes to define the options available at system level. Below you can find the list of code types available.
The codes are defined in the ORCV_S9T_CODE_HEAD and ORCV_S9T_CODE_DETAIL tables.
| Code Type | Code Type Description |
|---|---|
| RTVD | Return To Vendor - Action Detail |
| RTVH | Return To Vendor - Action Header |
| RTVR | Return to Vendor - RTV Reason Codes |
References
Return to Vendor also uses Queries module to enable communication between retailer and supplier users, details about Queries are available in the Supply Chain Hub Frameworks section.
Operations
This section describes available Return to Vendor operations.
Integration by Module
Figure 14-3 Return to Vendor Integration by Module
| Step | Description |
|---|---|
| 0 | RSCH Data Access of MFCS data |
| 1 | Return to Vendor publishes Approved or Cancelled RTVs to MFCS MerchIntegrations Rest Service. |
| 2 | Return to Vendor calls Upload Download Java Service to transform files, depending on the request details, Upload Download Java Service might need to callback to Return to Vendor to get more details. |
Materialized Views Refresh Details
This section describes Materialized Views Refresh Details.
ORCV_MV_SPRV_RTV_STAT_APPR
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPRV_RTV_STAT_APPR |
| Result Table A | Name of _A result table. | ORCV_SPRV_RTV_STAT_APPR_A_R |
| Result Table B | Name of _B result table. | ORCV_SPRV_RTV_STAT_APPR_B_R |
| Source View | The View contains business logic to be used to populate the result table. | ORCV_V_SPRV_RTV_STAT_APPR_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPRV_RTV_STAT_APPR_RC |
| Pre-Processor | Name of the pre-process procedure if applicable. |
ORCV_COMMON_MV_REFRESH. COMMON_PRE_PROCESSOR |
| Check Function | Name of the check function to validate if there is a need to refresh or if there are any batch dependencies. | NA |
| Preserve Data | Flag to decide if the data needs to be preserved until the next run cycle. | Y |
| Restart Indicator | Flag to indicate if to allow restart batch processor or not. | N |
| Max Concurrent Threads | This field contains the max_concurrent_threads that created the record. | 4 |
| Filter Fields | Column name of the view to be used for threading. | SUPPLIER |
ORCV_MV_SPRV_RTV_STAT_SHPD
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPRV_RTV_STAT_SHPD |
| Result Table A | Name of _A result table. | ORCV_SPRV_RTV_STAT_SHPD_A_R |
| Result Table B | Name of _B result table. | ORCV_SPRV_RTV_STAT_SHPD_B_R |
| Source View | The View contains business logic to be used to populate the result table. | ORCV_V_SPRV_RTV_STAT_SHPD_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPRV_RTV_STAT_SHPD_RC |
| Pre-Processor | Name of the pre-process procedure if applicable. |
ORCV_COMMON_MV_REFRESH. COMMON_PRE_PROCESSOR |
| Check Function | Name of the check function to validate if there is a need to refresh or if there are any batch dependencies. | NA |
| Preserve Data | Flag to decide if the data needs to be preserved until the next run cycle. | Y |
| Restart Indicator | Flag to indicate if to allow restart batch processor or not. | N |
| Max Concurrent Threads | This field contains the max_concurrent_threads that created the record. | 4 |
| Filter Fields | Column name of the view to be used for threading. | SUPPLIER |
ORCV_MV_SPRV_RTV_BY_DEPT
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPRV_RTV_BY_DEPT |
| Result Table A | Name of _A result table. | ORCV_SPRV_RTV_BY_DEPT_A_R |
| Result Table B | Name of _B result table. | ORCV_SPRV_RTV_BY_DEPT_B_R |
| Source View | The View contains business logic to be used to populate the result table. | ORCV_V_SPRV_RTV_BY_DEPT_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPRV_RTV_BY_DEPT_RC |
| Pre-Processor | Name of the pre-process procedure if applicable. |
ORCV_COMMON_MV_REFRESH. COMMON_PRE_PROCESSOR |
| Check Function | Name of the check function to validate if there is a need to refresh or if there are any batch dependencies. | NA |
| Preserve Data | Flag to decide if the data needs to be preserved until the next run cycle. | Y |
| Restart Indicator | Flag to indicate if to allow restart batch processor or not. | N |
| Max Concurrent Threads | This field contains the max_concurrent_threads that created the record. | 4 |
| Filter Fields | Column name of the view to be used for threading. | SUPPLIER |
ORCV_MV_SPRV_RTV_BY_LOC
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPRV_RTV_BY_LOC |
| Result Table A | Name of _A result table. | ORCV_SPRV_RTV_BY_LOC_A_R |
| Result Table B | Name of _B result table. | ORCV_SPRV_RTV_BY_LOC_B_R |
| Source View | The View contains business logic to be used to populate the result table. | ORCV_V_SPRV_RTV_BY_LOC_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPRV_RTV_BY_LOC_RC |
| Pre-Processor | Name of the pre-process procedure if applicable. |
ORCV_COMMON_MV_REFRESH. COMMON_PRE_PROCESSOR |
| Check Function | Name of the check function to validate if there is a need to refresh or if there are any batch dependencies. | NA |
| Preserve Data | Flag to decide if the data needs to be preserved until the next run cycle. | Y |
| Restart Indicator | Flag to indicate if to allow restart batch processor or not. | N |
| Max Concurrent Threads | This field contains the max_concurrent_threads that created the record. | 4 |
| Filter Fields | Column name of the view to be used for threading. | SUPPLIER |
ORCV_MV_SPRV_DASH_RTV_PENDNG
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPRV_DASH_RTV_PENDNG |
| Result Table A | Name of _A result table. | ORCV_SPRV_DASH_RTV_PENDNG_A_R |
| Result Table B | Name of _B result table. | ORCV_SPRV_DASH_RTV_PENDNG_B_R |
| Source View | The View contains business logic to be used to populate the result table. | ORCV_V_SPRV_DASH_RTV_PENDNG_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPRV_DASH_RTV_PENDNG_RC |
| Pre-Processor | Name of the pre-process procedure if applicable. |
ORCV_COMMON_MV_REFRESH. COMMON_PRE_PROCESSOR |
| Check Function | Name of the check function to validate if there is a need to refresh or if there are any batch dependencies. | NA |
| Preserve Data | Flag to decide if the data needs to be preserved until the next run cycle. | Y |
| Restart Indicator | Flag to indicate if to allow restart batch processor or not. | N |
| Max Concurrent Threads | This field contains the max_concurrent_threads that created the record. | 4 |
| Filter Fields | Column name of the view to be used for threading. | SUPPLIER |