My Oracle Support Banner

EAR 9.2: Maintenance Worksheet Gives Fatal Peoplecode Error When an Item ID Is More Than 22 Characters Long. (Doc ID 2647167.1)

Last updated on MARCH 09, 2020

Applies to:

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


Maintenance worksheet gives following error when an Item ID has more than 22 characters.

A fatal PeopleCode SQL error occurred. Please consult your system log for details.

SQL error in Exec. (2,280) AR_MAINT_IC_WRK.ATTACHMENTS_PB.RowInit PCPC:327 Statement:2

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
Error in PeopleCode ScrollSelect processing. (2,213) WS_WRK.LAST_BU.RowInit Name:select_maint_item PCPC:13631 Statement:151
Called from:FUNCLIB_AR_NEXT.NEXT_ITEM_GROUP.FieldChange Name:call_query Statement:67
Called from:FUNCLIB_AR_NEXT.FIRST_ITEM_GROUP.FieldChange Name:get_first_chunk Statement:22
Called from:WS_WRK.LAST_BU.RowInit Statement:279

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.

Replication Steps

1. Create a pending group with two items, one debit pending item for a customer which has item id more than 22 letters long.
2. Second item as credit for customer b with the same amount with item id more than 22 letters.
3. Run arupdate.
4. Create a maintenance worksheet for 'customer a' and click build the errors pops up.




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.