My Oracle Support Banner

E1: 42: Refresh Inventory Commitments (R42990) (Doc ID 2230896.1)

Last updated on OCTOBER 23, 2018

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later
Information in this document applies to any platform.

Purpose

Overview

Prior to the enhancement, if no active sales orders exist prior to running the Repost Active Sales Orders (R42995), when R42995 was run for locations that have hard/soft committed buckets filled but no open orders in the Sales Order Detail (F4211) exist, commitments would not be cleared for those Item Locations in the F41021 file. One workaround involved creating a 'dummy' order for the specific item so that R42995 would correctly repost the order. The 'dummy' order would then need to be cancelled after running the Repost Active Sales Orders (R42995) program. Another workaround involved using a database utility program such as SQL to clear the commitment buckets in the Item Location (F41021) prior to running the Repost Active Sales Orders (R42995). This process was more efficient if numerous items need to have the quantities and amounts reposted but do not have an open order in the Sales Order Detail (F4211). This process eliminated the need to create and delete what could be many individual "dummy" orders.

Scope

To refresh any inventory commitments in F41021 (Item Location File) where the item does not have any active sales orders associated with it. The existing program R42995 Repost Active Sales Orders refreshes the commitments for only those items that have an active sales order. There may be a case where the sales orders are all completed for an item, but for some reason there is still an outstanding commitment recorded in F41021 that needs to be cleared out. R42995 will not update this item in F41021.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 New Program Available in JD Edwards EnterpriseOne 9.2
 When to Run Refresh Inventory Commitment
 Difference between Repost Inventory Commitments (R42990) and Repost Active Sales Orders (R42995)
 Refresh Inventory Commitments Processing Options
 Sample Data Selection
 Refresh Inventory Commitments Logic
 Fields Updated in F41021
 Report Output
 Repost Active Sales Orders (R42995)
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.