Why the Requisition Distribution Line Status (PS_REQ_LN_DISTRIB.DISTRIB_LN_STATUS) of 'P' Has Been Added to the Application Engine Step Action IN_REPLEN_AE.POInst.OnOrder3.SQL (Doc ID 2090102.1)

Last updated on AUGUST 12, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9 and later
Information in this document applies to any platform.

Goal

When the 'Include Requisition Quantities' check box is selected on the 'Setup Replenishment' page (navigation: Inventory, Replenish Inventory, Setup Replenishment), the 'Replenishment Options' process (IN_REPLEN_AE) (navigation: Inventory, Replenish Inventory, Create Replenishment Requests), the following Application Engine Step Actions are executed:

* IN_REPLEN_AE.POInst.OnOrder3 (SQL action)
* IN_REPLEN_AE.POInst.OnOrder4 (Call Section action) (to calculate the Requisition quantity staged for PO).

From release 9.0, the criteria D.DISTRIB_LN_STATUS = 'O' has been replaced with DISTRIB_LN_STATUS IN ('O', 'P') on the Application Engine Step Action IN_REPLEN_AE.POInst.OnOrder3.SQL

Why is that?

Solution

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 hundreds of Community platforms