My Oracle Support Banner

EAP: Count Rows on the Data Archive Manager > Archive Run Control Details Page Errors on DB2 - SQL Error in Exec. (2,280) FUNCLIB_PSARCH_PSARCH_COUNT_ROWS.FieldChange (Doc ID 2877255.1)

Last updated on FEBRUARY 21, 2023

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On a DB2 database, clicking on the Count Rows link on the Data Archive Manager > Archive Data To History > View Details link > Archive Run Control Details page is encountering an error.

ERROR
 
A fatal PeopleCode SQL error occured. Please consult your system log for details.

SQL error in Exec. (2,280) FUNCLIB_PSARCH_PSARCH_COUNT_ROWS.FieldChange PCPC:12823 Statement 210
During the execution of SQL, an error in the Exec subroutine. The preceding message should have described the SQL being executed.


STEPS
 
1. Navigate to People Tools > Data Archive Manager > Archive Data To History page

2. Create a new Run Control ID with the below setup:
  - Archive Template: CNTR_AUD
  - Process Type: Selection
  - Selective Query: AP-CNTR_GRP_AUD_ARCHIVE
  - Commit Processing: Set-Base Processing
  - Date: 01/01/2022

3. Click View Details link

4. On Archive Run Control Details page, click Count Rows link

5.  Above error is encountered

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.