My Oracle Support Banner

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 JUNE 18, 2021

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 8.8 SP1 and later
PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

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).

Typically what happens when a requisition is sourced via Requisition Selection (manually) page or by the AutoSelect Requisition (PO_REQSORC) process (also called 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

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.