E1: 42W: Auto Fulfillment (R4277701) Not Allocating Inventory Due to Record Reservations (Doc ID 2908677.1)

Last updated on NOVEMBER 10, 2022

Applies to:

Symptoms

After introducing Fulfillment Load Balance (R4277711) program into production there were many record reservations created. This prevented many orders from being shipped the next day because inventory was not allocated and orders were not released.

Steps to Reproduce

1. Setup a version of Fulfillment Load Balance (R4277711) program
   1. Set Process Tab Option #1 (Number of Concurrent Jobs) to 8
   2. Add the Fulfillment Load Balance (R4277711) program to the JDE Scheduler in the production (live) environment
   3. Data selection was over three branch plants
2. Fulfillment Load Balance (R4277711) program ran overnight
   1. Execution detail shows over 80,000 order lines were in the data selection
   2. There were 8 Auto Fulfillment (R4277701) jobs launched.
   3. PDF report showed the first job processed 32,000 lines the other 48,000 lines were apportioned over 7 other jobs.
   4. Many messages were sent to the Work Center messages indicating inventory could not be allocated because of record reservations
3. Three Fulfillment Release jobs (R4277703) were launched (one for each branch)
   1. Most lines in the report showed quantity released of Zero
   2. Many messages were sent to the Work Center because of record reservations
   3. The next morning users complained there were no orders ready for shipment when they knew there was inventory available in the warehouse.

Cause

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