Request to Add Organization_id to Sql in Po_requisition_validate_pvt (POXRQVLB.pls)
Last updated on JULY 03, 2018
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...
WHERE secondary_inventory_name = p_req_line.source_subinventory
AND quantity_tracked = 1;"
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