My Oracle Support Banner

Purchase Order (PO) PO Change Request Workflow Fetches Incorrect Document different Operating Unit (OU) (Doc ID 2395995.1)

Last updated on MAY 08, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, Approvals - Req, PO

PO Change Request Workflow Incorrect PO from different organization

found that the PO change workflow is sending notifications to member of wrong operating unit.
Item: PORPOCHA
Message Name: NEW_PO_CHANGE_JRAD
Sample case: PO change on Italian operating unit (org id 499) sends notification to UK approver (org id 97)

Found bug in PO_ReqChangeRequestWF_PVT
/* $Header: POXVRCWB.pls 120.91.12020000.32 2016/03/08 06:00:17 rkandima ship $ */

CURSOR c_req_change_requests(p_change_request_group_id in number,p_doc_id number)
  SELECT distinct pll.line_location_id
  FROM po_change_requests pcr,
  po_lines_all prl,
  po_line_locations_all pll
  WHERE pcr.change_request_group_id = p_change_request_group_id
  -- AND pcr.request_status='PENDING'
  AND pcr.document_line_id = prl.po_line_id
  AND prl.po_line_id = pll.po_line_id
  AND pcr.document_header_id =p_doc_id
  AND pcr.wf_item_type=itemtype
  UNION
  SELECT distinct pll.line_location_id
  FROM po_change_requests pcr,
  po_requisition_lines_all prl,
  po_line_locations_all pll
  WHERE pcr.change_request_group_id = p_change_request_group_id
  -- AND pcr.request_status='PENDING'
  AND pcr.document_line_id = prl.requisition_line_id
  AND prl.line_location_id = pll.line_location_id
  AND pcr.wf_item_type=itemtype;
  --AND pcr.document_header_id =p_doc_id ;

po_change_requests -> document_line_id is supposed to have PO Line Id
Second query is joined using this field to requisition line id.
This is creating issue.

Changes

 

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!


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