Understanding the Inventory Commitment Refresh Process

When you run the Repost Active Sales Orders program (R42995), the system updates commitments for items that are on active sales orders only. Active sales orders have records in the Sales Order Detail table (F4211), and the Repost Active Sales Orders program reads and reposts records from that table. You might also need to update your inventory for items that do not have active sales orders. Those inventory items will not have records in the F4211 table, so the Repost Active Sales Orders program does not process them.

You can use the Refresh Inventory Commitments program (R42990) to clear all commitments for items for which no active sales order exists. The Refresh Inventory Commitments program reads and updates the Item Location File (F41021). When you run the program, it clears quantities from the F41021table and then resets the quantities for the following fields based on the soft commitments for work orders:

  • PCOM (Quantity Soft Committed)

  • SCMS (Secondary Quantity Soft Commit)

You can set data selection to specify branches, items, locations, and other selection criteria.

When you run the Refresh Inventory Commitments program, the program:

  • Ignores items for which all nine of the sales order related quantities are 0.

  • Determines whether active sales orders exist for the items included in the data selection, and ignores those items.

    The process ignores items with active sales orders even when you include the items in the data selection.

  • If the Check for Configured Items processing option is enabled, checks for active sales orders for the parent item of items included in the data selection.

  • Clears the sales order related quantity fields in the F41021 table.

  • Updates the Quantity Soft Committed field (PCOM) in the F41021 table with the value from the Work Order Soft Commit field (FUN1) in the F41021 table, and updates the Secondary UOM Conversion Factor (SCMS) field in the F41021 table using a conversion factor that is based on the dual unit of measure calculation.

  • Sets the Quantity Hard Committed (HCOM) field to 0 in the Location Detail File (F4602) if the Warehouse Control Flag is set to On for the branch being processed.

  • Prints a report.

  • Runs the Repost Active Sales Orders program (R42995) if the processing option is set to run the program.

    Note: The system uses the data selection in the Repost Active Sales Orders version that you specify in the processing options.
Important: Oracle strongly recommends that you run the Refresh Inventory Commitments program when no one is on the system. The system does not lock records. Therefore, if a sales order record is accessed during an update, the record might not process correctly.