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.
FS_PRCRUPD is failing when run selecting the option to Include Lines with no Item ID in Define Procurement Controls
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms