My Oracle Support Banner

EPC:Transaction Adjustment Search Giving Error - Error in PeopleCode ScrollSelect processing. (2,213) PROJ_ADJ_00_WRK.FUNCLIB.FieldFormula Name:FETCH PCPC:10703 (Doc ID 2505174.1)

Last updated on JANUARY 21, 2020

Applies to:

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

Symptoms

On : 9.2 version, Inquiry

Project Costing:Transaction Adjustment search giving error.

 Transaction Adjustment search giving error in project costing.

Navigation:Project Costing>>Transaction Definition>>Transaction Adjustment

Search by Chartfields giving a SQL error

ERROR
-----------------------
A SQL error occurred. Please consult your system log for details.

Error in PeopleCode ScrollSelect processing. (2,213) PROJ_ADJ_00_WRK.FUNCLIB.FieldFormula Name:FETCH PCPC:10703
Statement: 189
Called from:PROJ_ADJ_00_WRK.GET_ROWS.FieldsChange Statement:40

A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSwelectNew, RowScrollSelect, RowScrollSelectNew) built-in
function.

This error may have been described by a preceding message.

Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Project Costing > Transaction Definitions > Transaction Adjustment
2. Enter project and activity ids and click search
3. Transactions for adjustments appear
4. When using the Search By field and using a chartfield like DEPTID it fails:
5. Now Search By field and using a chartfield like DEPTID it fails:
6. No issue in demo


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.