E1: 41: P4113 Option To Not Transfer Hold Code To Location, Invalid Location And Duplicate Entries In F4111 (Doc ID 1908753.1)

Last updated on MAY 06, 2016

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

 

There is a requirement to add a processing option that will allow the FROM
and TO lot status codes (LOTS) on the Item Location Records (F41021) to
remain 
unchanged during an inventory transfer. Prior to Bug 10905630: LOT STATUS
UPDATED THROUGH AN - SAR: 7863765  clients could use P4113 Processing Option
5 
on the Process Tab = 1 (Do not Default the Lot Status from the From location
to the To location) to allow a transfer from a held location to a location
not on hold. Bug 10905630 changed the P4113 Processing Option 5. According to
the Final Disposition for Bug 10905630, when this processing option is set to
1, the TO location hold code will only be used in the case where we have
transfer between two held lots. When a transfer is done from a held lot to a
non-held lot,  always the  held lot status is used regardless of the
processing options.
 
Business case: P4113 is considered to describe the business case but the same
issue occurs when using R47121.
Having 30 percent of the inventory locations (F41021 records) on hold for
purposes of QA, while an item is on QA hold it is not available for the MRP 
program to use when planning customer orders. When the QA process is done,
the P4113 Inventory Transfer program is used to move from QA (Hold Location)
to Warehouse (non Hold Location).                 
As a result of the change in Bug 10905630, if only 1 item in a QA location is
transferred to a location with 500 items, the result of the transfer is that
501 items are now on hold and unavailable to MRP. This causes MRP to think
there are no good parts available to fill an order. Consequently, the MRP
system directs purchasing to create a new purchase order for 501 items. The
unnecessary purchase order will then require the company to pay an expedite 
fee to the vendor in order to supply materials in time to fulfill the
promised delivery dates to their customers. It is standard practice in
manufacturing to designate locations as Hold locations.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms