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 |