FS_PRCRUPD - ABENDED at Step FS_PRCRUPD.PHU1200.PHU12E0 (SQL) -- RC = 1438 (Doc ID 2210711.1)

Last updated on DECEMBER 05, 2016

Applies to:

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

Symptoms

Procurement Analysis:  

FS_PRCRUPD is failing when run selecting the option to Include Lines with no Item ID in Define Procurement Controls

ERROR: 
FS_PRCRUPD - ABENDED at Step FS_PRCRUPD.PHU1200.PHU12E0 (SQL) -- RC = 1438

ORA-01438: value larger than specified precision allowed for this column Failed SQL stmt: UPDATE PS_PRCR_UPD_TMP1R SET LEAD_TIME_MAD = LEAD_TIME - NUM_DAYS_DEVIATION WHERE PROCESS_INSTANCE = 2973383


Steps to recreate the issue:
1. Check the "Include Lines with no Item ID" on the Setup Profiles, Define Procurement Options page.
2. Run the FS_PRCRUPD process.

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