PO_SPND_HIST PROCESS FAILS WHEN A PO HAVING DUE DATE MORE THAN 999 DAYS
(Doc ID 2267176.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
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
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