My Oracle Support Banner

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.

Symptoms

9.2 Purchasing

----------------------

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.

Replication Steps:

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

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.