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