My Oracle Support Banner

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

Last updated on MARCH 04, 2019

Applies to:

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


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...

  INTO l_valid
  FROM mtl_secondary_inventories
  WHERE secondary_inventory_name = p_req_line.source_subinventory
  AND quantity_tracked = 1;"


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.