What is Item Replenishment ?

Item Replenishment Overview:

One can use the replenishment counting system to plan your inventories. This may be ideal for replenishing free stock items that you store on the production floor, or office supplies kept in departmental cabinets. Oracle Inventory provides an open interface for loading replenishment count data collected from some other system. In some situations, you may want to do your own planning and use Oracle Inventory to create your internal requisitions. As items are issued from a sub-inventory without formal issuing procedures, it is necessary to take inventory of non–tracked sub-inventories to record item usage and determine reorder necessity.

Business Scenario

In order to determine when and how much to replenish, periodical physical count of the items in non–tracked sub-inventories can be entered through the Replenishment Counts window, or via a batch load transaction such as a bar code reader. Oracle Inventory permits on–hand quantity as an additional replenishment information type for non–tracked sub-inventories. If an on–hand quantity is entered, Oracle Inventory uses min–max planning to determine whether an order should be placed. Oracle Inventory provides an external interface for loading replenishment count data collected electronically, such as by a bar code reader. Once you have populated the replenishment interface tables, you can run the Validate Replenishment Interface program to validate the counts and put the information into the appropriate tables.

               

Type of Interface: OPEN Interface

Technical Overview

MTL_REPLENISH_HEADERS, MTL_REPLENISH_LINES are the main tables. MTL_REPLENISH_HEADERS _INT, MTL_REPLENISH_LINES_INT are the Interface tables

The production tables are MTL_REPLENISH_HEADERS and MTL_REPLENISH_LINES. For each record in the MTL_REPLENISH_HEADERS there should be at least one record in MTL_REPLENISH_LINES. The corresponding interface tables are  MTL_REPLENISH_HEADERS_INT and MTL_REPLENISH_LINES_INT.                                

One should be very careful about many things like the Count type (On-Hand Qty, Order Qty, Order Maximum) depend on the item such that On-Hand Qty is applicable to non-tracked items, Order Qty is applicable to Reorder Level planned items while Order Maximum is applicable to items that are Min-Max planned. The replenishment count is mandatory in the first two conditions while it is not needed in Min-Max Planning. With the On-hand Qty, count qty is the on-hand balance while with Order Qty it is the reorder qty.             

Required fields for MTL_REPLENISH_HEADERS_INT are

ORGANIZATION_ID/ORGANIZATION_CODE, PROCESS_MODE, PROCESS_STATUS, REPLENISH_HEADER_ID, REPLENISH_COUNT_NAME, SUBINVENTORY_CODE,

PROCESS_MODE:

 2 - Concurrent

3 - Background

The replenishment validator polling process will pick up interface replenishment counts marked for Background processing. The validator will pick up and process all replenishment counts with a process mode of Background each time it runs.

You use Concurrent processing mode if you want to launch a dedicated replenishment validator process to explicitly process a single  replenishment count, identified as a parameter to the program, from the interface table.

PROCESS_STATUS

1 – Hold

2 – Pending

3 – Processing

4 – Error

5 – Completed

Required fields for MTL_REPLENISH_LINES_INT are INVENTORY_ITEM_ID, ORGANIZATION_ID, COUNT_TYPE_CODE, COUNT_QUANTITY, and COUNT_UOM_CODE

COUNT_TYPE_CODE

Enter the type of the replenishment count entry. The valid count types are:

1 - On-hand Quantity: Use On-hand Quantity to identify counts that are the result of stock-takes of sub-inventories in which you do not track on-hand quantities.

2 - Order Quantity: Use Order Quantity when you want to specify the quantity to be ordered. This count type may be used with either tracked or non-tracked sub-inventories.

3 - Order Maximum: Use Order Maximum when you want to place an order for the min-max maximum quantity specified for item in the sub-inventory specified. This count type may be used with either tracked or non-tracked sub-inventories.

Setting Up the Replenishment Interface

Access the Replenishment Interface through the Oracle Inventory menu (Counting/Replenishment Counts/Process Interface). Select the type of request by choosing Single Request. In the Request Name field, select Validate Replenishment Interface. In the Parameters window, select Concurrent or Background as the Processing Mode and select the Count Name for processing. Select Submit Request to begin processing. You can also use the Schedule button to specify resubmission parameters that will control how frequently the Replenishment Validator polls for records in the interface tables.

Validations Performed

The value of REPLENISH_HEADER_ID must be unique among existing replenishment counts

§         The value of REPLENISH_COUNT_NAME must be unique among existing count headers

§         The value of LAST_UPDATED_BY must be a valid user name

§         ORGANIZATION_ID must be a valid identifier of an organization

§         SUBINVENTORY_CODE must refer to an existing sub-inventory

§         DELIVERY_LOCATION_ID must be a valid identifier of a location associated with the organization generating the replenishment

§         There must be at least one line per header

§         The ORGANIZATION_ID at the header level must be the same as that at the line level

§         COUNT_TYPE_CODE must be either 1, 2, or 3 and must be consistent with whether the sub-inventory is tracked or non-tracked

§         The value of COUNT_QUANTITY must be consistent with COUNT_TYPE_CODE and must be greater than zero INVENTORY_ITEM_ID must refer to a transactable item in the organization specified

§         The item must exist in the sub-inventory and must be min-max planned in that sub-inventory

§         The COUNT_UOM_CODE must be valid and conversions to primary UOM must exist

§         Each line must correspond to a header

Error Messages: (Values for the ERROR_FLAG)

Possible values for the ERROR_FLAG column in the MTL_REPLENISH_HEADERS_INT table are:

1 - Non-unique replenishment header id

2 - Non-unique replenishment count name

3 - Invalid user name

4 - Invalid organization identifier

5 - Invalid subinventory

7 - Header with no corresponding replenishment lines

10 - Header failed because line failed

18 - Delivery location is not valid

Possible values for the ERROR_FLAG column in the MTL_REPLENISH_LINES_INT table are:

1 - No corresponding header id

3 - Invalid user name

8 - Invalid item identifier or item isn’t transactable

9 - Invalid unit of measure or no conversion to primary unit of measure exists

11 - No item specified in either identifier or segments

12 - Invalid count type

13 - On-hand count type used for tracked sub inventory