E1: 42: Incorrect Update to fields HCMS and HCOM After Credit Order Ship Confirm of Dual UOM Item (Doc ID 2825788.1)

Last updated on DECEMBER 06, 2021

Applies to:

Symptoms

A sales order is raised for a Dual UOM and lot controlled item, and the order is processed through to completion. A credit order for the same item/lot is raised, one line retrieved from via Credit Memo and the other entered manually. The Credit order is then ship confirmed. Small quantities remain in the HCOM (Qty Committed) and HCMS (Secondary Qty Hard Committed)for the line retrieved via Credit Memo - the manually entered line is unaffected.

The issue can be reproduced at will with the following steps:

1. Set a Branch Plant Availability to have just one box checked, the ‘Quantity Hard Committed to SO’ in the Subtract column.

2. Add a new Dual UOM and lot controlled item with KG as the Primary and RL as the Secondary UOM.  

3. Where the item conversion is (for example )57 KG to 1 RL, adjust in KG quantities, to different lots, that are slightly over or under this amount, eg 56.80 KG, 57.35 KG.

4. Raise a sales order by populating just the secondary UOM field, eg 2 RL. The system performs the conversion to KG.

5. Run the Pick Slip program R42520, this will split the line in the sales order.

6. Ship confirm the sales order lines with the exact quantities used in the inventory adjustment, 56.80 kg, etc.

7. Invoice the order and run it through Sales update. 

8. Process a credit order for the item, where the first line is retrieved using the credit memo functionality. The exact KG value, with a negative sign, will be returned to this line.  Add a second line manually for the -1 RL and the lot that was used in the sales order. This line will show the standard conversion for the KG quantity (eg 57 KG).

9. Add a version of Ship confirm P4205, to process CO/C order and line type. Ship confirm line 1: the system will show the exact quantity (56.80) from the line. Ship confirm line 2: manually change the 57 KG to be the exact value used in the order (eg 57.35 or similar)

10. Review item availability P41202; small quantities remain for the lot that was processed via the Credit Memo functionality. There is no issue for the line added manually. The 2 methods (credit memo / manual add) were used to illustrate that the customer cannot rely on the Credit Memo to accurately clear quantities in the HCOM/HCMS fields due to the bug.

Changes

Cause

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