EAR9.2: Fatal PeopleCode SQL Error On 'Group Search For Unpost' Page When 'Group Unit' Value Is Not Configured On 'Receivables Data Entry 1' User Preferences Setup

(Doc ID 2184028.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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


On : 9.2 version, Unpost

When attempting to search a AR group to unpost in the navigation: Main Menu>Accounts Receivable >Receivable Update >Unpost Groups>Group Search for Unpost, the following error occurs.


SQL error in Exec.(2, 280) Unpost_QRY_WRK.GROUP_SEARCH_PB.FieldChange

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

1. Navigate search AR group to unpost: Main Menu>Accounts Receivable >Receivable Update >Unpost Groups>Group Search for Unpost.
2. Select Group Unit as DEU01
3. Select Customer and click on search button.
4. The above error message is displayed.


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