EAR9.2: Partial Payment Unpost Fails With SQL Error in Exec. (2,280) PAYMENT_ITEM.BAL_CURRENCY.FieldFormula name:UpdatePaymentItemExchangesRates PCPC:11319 Statement:67
Last updated on SEPTEMBER 21, 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 image 1, Unpost.
Partial payment unpost fails and generates a SQL error.
A fatal SQL error is generated,
SQL error in Exec. (2,280) PAYMENT_ITEM.BAL_CURRENCY.FieldFormula name:UpdatePaymentItemExchangesRates PCPC:11319 Statement:67
Called from:AR_WORKSHEET.PAYMENT.PaymentWorksheet.OnExecute Name:BuildPartialUnpostWorksheet Statement:311
Called from:BALANCE_WRK.PARTIAL_UNPOST.Fieldchange name:BuildPartialUnpostWorksheet Statement:7
Called from:BALANCE_WRK.PARTIAL_UNPOST.FieldChange Statement: 11
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
The issue can be reproduced at will with the following steps:
- Locate a payment which has been applied to more than one item.
- Navigate to Accounts Receivable > Receivables Update > Unpost Groups > Payment Group.
- Open the deposit and payment identified in step 1.
- Click on the "Partial Unpost" link.
- A fatal SQL error is generated
The issue has the following business impact:
Due to this issue, users cannot unpost a payment.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms