My Oracle Support Banner

PO_AUTO_SRC Fails with Process ABENDED at Step PO_POCALC.VS0500.CHKUPN2 (Doc ID 2516531.1)

Last updated on JANUARY 24, 2020

Applies to:

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

Symptoms

ISSUE
---------------
When running PO_AUTO_SRC the process is running to No Success 


ERROR
-----------------------
-- 11:50:50.962 Process 1230712 ABENDED at Step PO_POCALC.VS0500.CHKUPN2 
(Action SQL) -- RC = 8601 
ROLLBACK 

-- 11:50:51.007 SQL Error: [Microsoft][ODBC Driver 11 for SQL Server][SQL 
Server]'LENGTH' is not a recognized built-in function name. 
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not 
be prepared. (SQLSTATE 42000) 8180 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Requisition
2. Add contract to the requistion
3. Select Requisition
4. PO Auto Source

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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