My Oracle Support Banner

Requisition Imported From MIN-MAX Have The Destination Type Changed From Inventory To Expense when opened in Iprocurement (Doc ID 1498241.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle iProcurement - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


When a requisition is imported from MIN-MAX planning setting the parameter "Initiate Approval after Reqimport" to "N" then then Destination Type on Requisition lines is "Inventory" and Requisition is created in Incomplete status.
But when opening the requisition in iProcurement  the Destination Type is updated to "Expense" and the "Destination Subinventory" is set to Null

Expect the destination is not modified from INVENTORY to EXPENSE and the Destination Subinventory not set to Null when requisition imported from Min-Max is opened in iProcurement

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

1-Run the Min-Max Planning report with option Restock for Item X which is under Min

2-Run the the Requisition import with the option "Initiate Approval after Reqimport" set to No

3-One requisition is created in Incomplete Status (and the destination type is Inventory and destination subinventory exists when checking in PO_REQUISITION_LINES_ALL)

4-Open the requisition in iProcurement

5-The destination type is changed to "Expense" and the destination subinventory disappears from the table PO_REQUISITION_LINES_ALL


To view full details, sign in with your My Oracle Support account.

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

In this Document

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