My Oracle Support Banner

E1: 34: Supply Demand (S&D) Inquiry Shows Incorrect Potency Value For Active Ingredient (P4021) (Doc ID 2602782.1)

Last updated on JUNE 04, 2021

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When the P4021 processing options are set to display quantities in potency, the on hand quantities are converted based on the ratio of standard potency to actual potency.  Work order parts list commitments to quantities with
actual potency values are not converted by the ratio of standard potency to actual potency.  This means that the calculations for supply and demand are made using potent and non-potent numbers.  

Steps to duplicate issue:

  1. Enter fresh data item for this test.  Lots are optional.  Set item as active ingredient, setup in Branch Plant.  1 KP (potent kilogram) = 1 KG (kilogram). 
  2. Enter Bill of Material (BOM) for a parent item using potent item as a component.  Routing is optional.
  3. Adjust in a lot quantity such that actual potency is greater than standard potency.  Hence, quantity is super potent, relative to standard.  
  4. Add P48013 work order for top level parent.   
  5. From work order parts list, copy BOM.  
  6. Reinquire and find that the non-potent (KG) qty has been committed to the work order.  No consideration of the lot being 'super' potent, meaning that we are now over committed.  
  7. When the system commits the entire lot quantity, expect P4021, when displaying KG in potent units of measure, then the committed quantity needs to reflect KG in potent units of measure, otherwise the P4021 does not indicate that the lot is consumed.  
  8. KP Potent KG is adjusted (699.30*0.70) by standard potency, not ratio of actual to standard.
  9. The lot, being super potent at 77.720, is sufficient to meet the work order requirement.  
  10. The qty on hand is inflated but the commitment qty is not. This is inconsistent.

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.