R12: Imported Requisitions do Not Approve, Reason Unable to Reserve Purchase Requisitions (Doc ID 2674563.1)

Last updated on MARCH 15, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.