PV_PO_CREATE Process Runs to No Success. Error: PO_POCALC abends on SQL Server at Step PO_POCALC.VS5200.FINDERR4 (Doc ID 2122748.1)

Last updated on JULY 14, 2017

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When an epro requisition is sourced via Expedite Requisition (PV_PO_CREATE) on MicroSoft SQL Server, it may end with No Success.  

This occurs when the PO_POCALC process errors during the price calculation routine with "Calculated PO Price is greater than the requested price plus the percentage of unit price tolerance" (10206,12)

Error:  ABEND: PO_POCALC abends on SQL Server at Step PO_POCALC.VS5200.FINDERR4

SQL error. Function: SQLExec Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'V'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'V'. [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.
 (S Statement:
  UPDATE PS_PO_STG_UDWK_T5 V SET V.TOL_ERR_FLG = 'Y', V.STAGE_STATUS = 'E', V.MESSAGE_SET_NBR = 10206, V.MESSAGE_NBR = 12 WHERE V.PROCESS_INSTANCE = 1104718 AND V.STAGE_STATUS = 'V' AND V. LINE_NBR = 1 AND V.SCHED_NBR = 1 AND V.CALC_PRICE_FLG = 'Y' AND V.PCT_UNIT_PRC_TOL_R <> 999.99 AND V .PRICE_REQ_BSE > 0 AND V.PRICE_PO_BSE > ( 95417.1368790750000000000000000000 * (1.00000 + (((V.PCT_U

Steps to recreate the issue:

1) Create a ePro requisition.

2) Make a change to the vendor price or market rate so that PO Calc will throw sourcing error "Calculated PO Price is greater than the requested price plus the percentage of unit price tolerance" (10206,12)

3) Run Expedite Requisitions (PV_PO_CREATE)

4) Process abends with error:

 

Changes

 > Internal Only: This is a regression issue caused by Bug 19911159 .

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