Unable to Add a New Department in Federal Page

(Doc ID 2131913.1)

Last updated on APRIL 28, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When attempting to add new Department USF, the following errors occurs.

Error 1:
Class Row method GetRowset scroll DEPT_SUBCOM_BEL is invalid. (2,270) DEPT_TBLBEL_SBR.IND_COMMITTEE_BEL.RowInit PCPC:235
The scroll name has been used as a parameter of the specified method. It is not valid for the current object.
Use the PeopleCode Debugger or a PeopleCode trace to determine the point of the error, and correct the program.

-- After clicking OK on the above message, below error message occurs.

Error 2:
Error in PeopleCode ScrollSelect processing. (2,213) DERIVED_BUDGET.TRIGGER_WRK_SCROLL.RowInit PCPC:8807 Statement:222
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.) Navigate to Set Up HCM > Foundation Tables > Organization > Department USF, click on Add a new value tab.
2.) Add a value in Department, and click on Add push button, the above error message occurs.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms