My Oracle Support Banner

After Importing Requisitions from Inventory Min/max Planning, the Internal Requisition Quantity Is Different than the Quantity for the Same Item on the Min Max Planning Report (Doc ID 1918166.1)

Last updated on APRIL 19, 2023

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Min/Max report is showing reorder quantities for an item that are correct but when the requisitions that the Min/Max creates are imported into Purchasing the requisition quantity for this item is not the same as what is on the Min/Max report.  This is only effecting items on internal requisitions sourced internally.

Steps to Recreate the issue
-------------------

  1. Set Purchasing Options field "Enforce Full Lot Quantity" equal to "Mandatory" (See Purchasing Options screenshot below)
  2. Create or modify an item enabled in 2 or more inventory organizations (1 is the Source Org, 1 is the Destination Org)
  3. In the "General Planning" tab for this item make the following quantities different in the "Source" inventory organization than they are in the "Destination" inventory org (See Item Attribute Setup below)
  4. Setup a Sourcing Rule that sources the Destination Org to the Source Org.
  5. Run the Min/Max Planning Report for the Destination Org and review the output for the specific item
  6. Run the Requisition Import with "Import Source" = 'INV'
  7. Examine the Internal Requisition that is created for the specific item.

 

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

Purchasing Options Setup

Item Attribute Setup






Changes

 

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.