Process PO_AUTO_SRC Running To Error

(Doc ID 1981890.1)

Last updated on AUGUST 07, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

Goal

Process PO_AUTO_SRC is erroring out with the below error message.

"File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1620 Error Position: 43 Return: 14 38 - ORA-01438: value larger than specified precision allowed for this column Failed SQL stmt:UPDATE PS_PO_STG_UDWK_T6 SET EXT_PRC_TOL = ROUND((((EXT_PRC_TOL ) * ( CONVERSION_RAT E))),5) WHERE PROCESS_INSTANCE = 2174690 AND EXT_PRC_TOL <> 99999999.99999

This error was occured at step : PO_POCALC.VS4200.TOLCNV3 (SQL) -- RC = 1438"




Solution

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