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