CREATEPO: Requisitions Not Converted Into Purchase Orders Automatically As GET_BUYER Does Not Retrieve Buyer Using Some Responsibilities (Doc ID 1319922.1)

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

When using the worklist from some specific (non-purchasing) responsibilities to approve requisitions, the Purchase Order (PO) Create Documents workflow (CREATEPO) is not converting them into purchase orders. The output from wfstat.sql indicates that this is happening because GET_BUYER fails to retrieve the buyer information. This is shown as followed in the wfstatus.sql results:

16-SEP-10 14:32:18 ENOUGH_INFO_TO_AUTOCREATE/DOES_CONTRACT_EXIST COMPLETE Y
16-SEP-10 14:32:18 ENOUGH_INFO_TO_AUTOCREATE/GET_BUYER COMPLETE
ACTION_FAILED
16-SEP-10 14:32:18 GET_BUYER/START COMPLETE
#NULL
16-SEP-10 14:32:18 GET_BUYER/GET_BUYER_FROM_REQ_LINE COMPLETE
ACTION_FAILED
16-SEP-10 14:32:18 GET_BUYER/GET_BUYER_FROM_ITEM COMPLETE
ACTION_FAILED
16-SEP-10 14:32:18 GET_BUYER/GET_BUYER_FROM_CATEGORY COMPLETE
ACTION_FAILED
16-SEP-10 14:32:18 GET_BUYER/OK_TO_USE_BUYER_ON_SRC_DOC COMPLETE N
16-SEP-10 14:32:18 GET_BUYER/OK_TO_USE_BUYER_ON_CONTRACT COMPLETE N
16-SEP-10 14:32:18 GET_BUYER/END-3 COMPLETE
#NULL
16-SEP-10 14:32:18 ENOUGH_INFO_TO_AUTOCREATE/END-2 COMPLETE
#NULL

Cause

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 hundreds of Community platforms