PO_SPND_HIST PROCESS FAILS WHEN A PO HAVING DUE DATE MORE THAN 999 DAYS (Doc ID 2267176.1)

Last updated on MAY 17, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
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

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