R12: Imported Requisitions do Not Approve, Reason Unable to Reserve Purchase Requisitions
(Doc ID 2674563.1)
Last updated on MARCH 15, 2022
Applies to:
Oracle Purchasing - Version 12.2.6 and laterInformation in this document applies to any platform.
POXRQUPVTB.pls
Reqimport
Symptoms
On : 12.2.6 version, Other Issues
Imported Requisitions do not approve, reason unable to reserve purchase requisitions:
In one of the standard procedures (DB package name po_requisition_update_pvt), it is comparing the distribution_id to a distribution number.
Expected Behavior:
Expect the command to be like:
FOR i in 1..p_req_dist_tbl_out.count
LOOP
BEGIN
SELECT *
INTO l_dist_rec
FROM PO_REQ_DISTRIBUTIONS_all
WHERE distribution_id = p_req_dist_tbl_out(i).distribution_id (instead of p_req_dist_tbl_out(i).distribution_number)
Steps to reproduce:
1. Import requisitions
2. Try to approve using a custom logic
Cause
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
Symptoms |
Cause |
Solution |
References |