E1: 42: P4210/P42101 - Potency Item Quantity Incorrectly De-Committed When Cancelling Sales Order Line (Doc ID 2960542.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Symptoms

Sales order created for potency item correctly calculates and hard commit quantities however if order line is cancelled, system incorrectly de-commit available quantity creating integrity issue in stock.

Steps:

1. P4101 – Create item master for item # FGPOT (FG POTENCY ITEM)
2. Item Master - Additional System Info – Grade and Potency TAB – Standard Potency 25.00
3. P41026 – Create a new Item Branch (30) for Item # FGPOT (FG POTENCY Item)
4. Additional System Info – Grade and Potency TAB – Standard Potency 25.00
5. Item unit Of Measure (UoM) Conversion
   - 1 DR = 40.00000 KG
   - 1 KA = 1.000000 KG
   - 1 UN = 40.00000 KG
6. P4105 – Standard Item Cost – B/P = 30
7. Manually create Lot # 20230710005 in B/P # 30 for Item FGPOT
8. P41202 – Item Availability - OnHand = 2.5000 / Available = 2.5000
9. P42101 - Enter sales order for 10 KG (Secondary UoM) for the Lot/Serial 20230710005 with Potency 25% just created in previously step. Make sure it does Click in Submit and Close button to save the order.
10. P41202 - Summary Availability – Sales Order hard committed 2.5 KA (Primary UOM) (10*25/100). Working as expected.
11. P42101 – Inquire back into the sales order just created and cancel the line. Go to order details, select the line and take More Row Actions to “Cancel Line”. Then, click Submit and Close button.
12. P41202 - Summary availability – See that the now incorrectly Available = 10.0000 and Committed = -7.5000. It seems like the application did not convert the potency back and, it incorrectly updates hard committed to – 7.5 (2.5 – 10)

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.