PO_SPND_HIST PROCESS FAILS WHEN A PO HAVING DUE DATE MORE THAN 999 DAYS
Last updated on SEPTEMBER 26, 2017
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
PO_SPND_HIST process fails when a PO having due date more than 999 days is processed. The error message is ORA 12899 Value too large for column SYSADM. PS_PO_SPND_D_TMP2. DAYS_AGED_CHAR. This happens when the program tries to insert the data for Purchase Orders having more than 999 days from current date.
1 - Run the Application Engine PO_SPND_HIST
2 - Make sure that there are POs having due date more than 999 days
3 - Error received
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