Request to Add Organization_id to Sql in Po_requisition_validate_pvt (POXRQVLB.pls)

(Doc ID 2293227.1)

Last updated on AUGUST 02, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Requisitions

Problem in PO_REQUISITION_VALIDATE_PVT POXRQVLB.pls version 120.0.12020000.4

In po_requisition_validate_pvt there is a sql which read from mtl_secondary_inventories and does not use the organization_id in the where clause.
This causes  call to the public package to fail.
The same sub inventory name is in several organizations.
details : Package name: po_requisition_validate_pvt
Problematic code (line# 7012)

need to add ORGANIZATION_ID = source_organization_id
check the use of nvl...


" BEGIN
  SELECT 'T'
  INTO l_valid
  FROM mtl_secondary_inventories
  WHERE secondary_inventory_name = p_req_line.source_subinventory
  AND quantity_tracked = 1;"

Cause

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