Troubleshooting Requisition Stuck In Sourcing Workbench with a Stage Status of Error, POCalc or PO Create and List of the Staging Tables (Doc ID 1276857.1)

Last updated on FEBRUARY 26, 2024

Applies to:

Purpose

This document will assist in troubleshooting a requisition stuck in the Sourcing Workbench (staging tables) with a Stage Status (STAGE_STATUS) of Error (E), POCALC (V) or PO Create (P) and the IN_PROCESS_FLG = Y (Yes). Navigation: Menu > Purchasing > Purchase Orders > Stage/Source Requests > Sourcing Workbench.

Typically what happens when a requisition is sourced via Requisition Selection page (Menu > Purchasing > Purchase Orders > Stage/Source Requests > Requisition Selection) manually or by the Auto Select Requisition (PO_REQSORC) process also called Auto Requisition Selection (Menu > Purchasing > Purchase Orders > Stage/Source Requests > Auto Requisition Selection). When the requisition is sourced successfully the following core staging tables are populated with the requisition information and the "Stage Status" in the Sourcing Workbench will display as "Staged."

PO_HDR_STG (populated by Requisition Selection only, the PO_REQSORC process does not populate this table)
PO_ITM_STG
PO_DISTRIB_STG

After the requisition is sourced the PO Calculations (PO_POCALC) process is run to perform further functions to start developing the Purchase Order (PO) and populate other staging tables. If the PO_POCALC process completes successfully the Stage Status (STAGE_STATUS) on the Sourcing Workbench will display as "Ready" (B).

The next process that is run in order to complete building the PO is the Create Purchase Order (PO_POCREATE) process. When this process completes running successfully the Stage Status will change from "Ready" to "Completed" (C).

On rare occasions, either the PO_POCALC or PO_POCREATE processes abend or are stopped/suspended unexpectedly. If PO_POCALC process fails the Stage Status of the requisition in the Sourcing Workbench will change to "POCALC" (V). If PO_POCREATE process fails the Stage Status is changed to "PO Create" (P). At this point their is no way to recover the requisitions or PO's without performing some SQL updates to reset the data.

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.