My Oracle Support Banner

PRC: PO: Autocreate Failure Reason Codes and Suggested Actions (Doc ID 2220220.1)

Last updated on JANUARY 04, 2023

Applies to:

Oracle Fusion Purchasing - Version 11.1.11.1.0 and later
Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Purpose

This document provides  list of Reason Codes for Automation Failure and Steps to Resolution for Touchless Buying.

Run the below query to find the reason for Touchless PO creation failure.

1. To find the reason for the failure of the automation process, run the following sql query (SQL:1)

SELECT prh.requisition_number
,prl.line_number
,prl.line_status
,prl.req_po_instance_id
,prl.reqs_in_pool_flag
,ph.segment1 AS po_number
,prh.emergency_po_number
,prl.reqtopo_automation_failed
,prl.reqtopo_auto_failed_reason
,msg.context AS failed_reason_text
,DECODE(NVL2(prh.EMERGENCY_PO_NUMBER, 1, - 1), 1, prh.SOLDTO_LE_ID, - 1, NULL) AS SOLDTO_LE_ID
,prh.pcard_id
,prl.line_type_id
,prl.pcard_flag
,prl.requisition_header_id
,prl.requisition_line_id
,prl.prc_bu_id AS req_line_prc_bu
,prh.prc_bu_id AS req_header_prc_bu
,prl.req_bu_id
,prl.assigned_buyer_id
,prl.negotiated_by_preparer_flag
,prl.negotiation_required_flag
,prl.source_document_type
,prl.source_doc_header_id
,prl.vendor_id
,prl.vendor_site_id
,prl.line_location_id
,prl.item_id
,prl.category_id
,prl.amount
,prl.quantity
,prl.unit_price
,ph.document_creation_method
,ph.prc_bu_id AS po_prc_bu
,ph.document_status
,ph.po_header_id
FROM po_headers_all ph
,po_lines_draft_all pl
,por_requisition_lines_all prl
,por_requisition_headers_all prh
,fnd_messages_b msg
WHERE ph.po_header_id(+) = pl.po_header_id
AND prl.po_line_id = pl.po_line_id(+)
AND prl.requisition_header_id = prh.requisition_header_id
AND prh.requisition_number IN (:Bind_Req_Number)
AND prl.reqtopo_auto_failed_reason = msg.message_name(+)
ORDER BY prl.requisition_header_id, prl.line_number;

2. Change the requisition number and run the above query. Observe the attributes reqs_in_pool_flag, reqtopo_automation_failed_reason and message text.

3. Since the requisition is in process requisition, the reqs_in_pool_flag should be set to 'Y'. The reason code will be shown in the attribute reqtopo_auto_failed_reason.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps

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