My Oracle Support Banner

EPC: When Using the Transaction Adjustment Page With Chartfield Values in the Search Criteria, the User Receives SQL Error (Doc ID 2709323.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

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


When using the Transaction Adjustment page with chartfield values in the search criteria, for example, a specific account, the user receives an error. If only the Project Costing chartfield values are used (e.g. Project Costing Business Unit, Project ID, Activity ID), no error occurs and rows are returned as expected.

1. Navigate to Project Costing - Transaction Definitions - Transaction Adjustment.
2. Enter PC BU, Project, Activity and an account and click Search.
  - Error message opens "A SQL error occurred. Please consult your system log for details"




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.