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, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

SQL error on the KK header status

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


ERROR
-----------------------

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.



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

 

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