15 Inventory and Sales
The Inventory and Sales module is an application available in Supply Chain Hub. This chapter describes the implementation considerations and the operation details for this application.
Functionalities
Inventory and Sales is an application that shows the stock and sales details of items per location. The homepage of Inventory and Sales has the top selling departments and the low stock, and no stock items counts.
Configuration
This section describes the 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 Implementation Considerations
This section describes Inventory and Sales implementation considerations.
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 and below is the list for this application.
ORCV_MV_SPIS_INV_DAILYN_IL
Contains the item-location stock on hand and sales by units’ values in a daily basis.
Pre-Dependencies: ORCV_INV_DAILY_HIST_JOB
Post-Dependencies: ORCV_MV_SPIS_INV_WKLYN_IL_JOB
Frequency: Ad-hoc, Nightly
ORCV_MV_SPIS_INV_WKLYN_IL
Contains the item-location stock on hand and sales by unit’s values from the n weeks.
Pre-Dependencies: ORCV_MV_SPIS_INV_DAILYN_IL_JOB
Post-Dependencies: None
Frequency: Ad-hoc, Nightly
References
Inventory and Sales has dependencies on Inventory batch jobs that are listed below. The details of those dependencies are available in the Supply Chain Hub Frameworks section.
| MODULE | PROGRAM NAME |
|---|---|
| Inventory | ORCV_INV_DAILY_IL_HIST_JOB |
| Inventory | ORCV_INV_WKLY_IL_HIST_JOB |
| Inventory | ORCV_MV_INV_ITEM_LOC_SOH_JOB |
Operations
This section describes Inventory and Sales operations.
Materialized Views Refresh Details
This section describes Materialized Views Refresh Details.
ORCV_MV_SPIS_INV_DAILYN_IL
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPIS_INV_DAILYN_IL |
| Result Table A | Name of _A result table. | ORCV_SPIS_INV_DAILYN_IL_A_R |
| Result Table B | Name of _B result table. | ORCV_SPIS_INV_DAILYN_IL_B_R |
| Source View | The View that contains business logic to be used to populate the result table. | ORCV_V_SPIS_INV_DAILYN_IL_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPIS_INV_DAILYN_IL_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. | LOC |
ORCV_MV_SPIS_INV_WKLYN_IL
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPIS_INV_WKLYN_IL |
| Result Table A | Name of _A result table. | ORCV_SPIS_INV_WKLYN_IL_A_R |
| Result Table B | Name of _B result table. | ORCV_SPIS_INV_WKLYN_IL_B_R |
| Source View | The View that contains business logic to be used to populate the result table. | ORCV_V_SPIS_INV_WKLYN_IL_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPIS_INV_WKLYN_IL_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. | LOC |
ORCV_MV_SPIS_INV_WKLY_DEP
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPIS_INV_WKLY_DEP |
| Result Table A | Name of _A result table. | ORCV_SPIS_INV_WKLY_DEP_A_R |
| Result Table B | Name of _B result table. | ORCV_SPIS_INV_WKLY_DEP_B_R |
| Source View | The View that contains business logic to be used to populate the result table. | ORCV_V_SPIS_INV_WKLY_DEP_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPIS_INV_WKLY_DEP_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. | 6 |
| Filter Fields | Column name of the view to be used for threading. | DEPT |
ORCV_MV_SPIS_INV_WKLY_IL
| COLUMN | DESCRIPTION | VALUE |
|---|---|---|
| Result Synonym | Name of the synonym pointing to the result table. | ORCV_MV_SPIS_INV_WKLY_IL |
| Result Table A | Name of _A result table. | ORCV_SPIS_INV_WKLY_IL_A_R |
| Result Table B | Name of _B result table. | ORCV_SPIS_INV_WKLY_IL_B_R |
| Source View | The View that contains business logic to be used to populate the result table. | ORCV_V_SPIS_INV_WKLY_IL_R |
| Driving View | This field contains the view to distribute the refresh process. | ORCV_V_SPIS_INV_WKLY_IL_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. | LOC |