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 AUGUST 09, 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.

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

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

Changes

 

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
Changes
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.