My Oracle Support Banner

Po_requisition_update_pub.update_req_distribution API SQLERRM = ORA-01403: data not found (Doc ID 2668015.1)

Last updated on MAY 08, 2020

Applies to:

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

Symptoms

After installing patch 27852024, the po_requisition_update_pub.update_req_distribution API function stopped working

When API is run, the value p_req_dist_tbl in the action_flag field was set to "NEW".

  Following error now occurs"SQLERRM = ORA-01403: data not found."

Error occurs:
Package version PO_REQUISITION_UPDATE_PVT:
POXRQUPVTB.pls

Line 1700:
INSERT INTO PO_REQ_DISTRIBUTIONS_ALL
  (DISTRIBUTION_ID,


SELECT po_req_distributions_s.NEXTVAL,
  SYSDATE


FROM financials_system_parameters fsp

WHERE p_req_dist_tbl_out (i) .action_flag = 'NEW'


Line 1808:
SELECT *
INTO l_dist_rec
FROM PO_REQ_DISTRIBUTIONS_all
WHERE distribution_id = p_req_dist_tbl_out (i) .distribution_id
  AND requisition_line_id = p_req_dist_tbl_out (i) .req_line_id;

 The error here is ORA-01403, because the p_req_dist_tbl_out (i) .distribution_id field is empty.

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


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