My Oracle Support Banner

EGL 9.2+: SQL Error When Clicking The Budget Header Status Link (Doc ID 2265405.1)

Last updated on MAY 12, 2021

Applies to:

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


SQL error on the KK header status

Getting a SQL error when clicking the budget header status link on budget journals


Error in PeopleCode ScrollSelect processing. (2,213) KK_ACT_LOG_WRK.FUNCTION_FIELD.FieldFormula Name:FETCH_ACTIVTY_LOG PCPC:29935 Statement:481
Called from:KK_ACT_LOG_INQURY.Activate Statement:19

A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, 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.

The issue can be reproduced at will with the following steps:

  1.  Create Budget Journal Navigation: Commitment control > Budget Journals > Enter Budget Journals
  2.  Post journal
  3.  View Posted Journal: Commitment control > Budget Journals > Enter Budget Journals > Budget Lines Tab
  4.  Click "Posted" link under the Budget Header Status field on the budget lines page
  5.  Pop up message: "A SQL error occurred. Please consult you system log for details"
  6.  Click OK
  7.  Complete error is displayed





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.