EGL : 9.1 SQL Error FUNCLIB_PSARCH.PSARCH_COUNT_ROWS.FieldChange Using Delivered Archive Templates In DB2 Database

(Doc ID 1904016.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


When attempting to fetch the row count on Archive Data To History Page on a DB2 database the following error occurs.

A fatal PeopleCode SQL error occurred. Please consult your system log for details
SQL error in Exec. (2,280) FUNCLIB_PSARCH.PSARCH_COUNT_ROWS.FieldChange PCPC:12823 Statement:210

The issue can be reproduced at will with the following steps:
1. PeopleTools >Data Archive Manager > Archive Data To History .
2. Provide the bind values.
3. Click on view details and select the row count hyperlink.


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