EAR9.2 ARUPDATE Abended at Step AR_POSTING.DEP_CNTL.UNP_RSN After Partial Payment Unpost (Doc ID 1678448.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Symptoms

On :  9.2 version, AR Update - Posting

ARUPDATE Abended at Step AR_POSTING.DEP_CNTL.UNP_RSN after partial payment unpost.

ERROR
-----------------------
AR_POST1 failed with the following messages:
File: e:\pt85307c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623
Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Subquery returned more than 1 value.
This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
[Microsoft][SQL Server Native Client 11.0][SQL Failed SQL stmt:
UPDATE PS_PAYMENT SET UNPOST_REASON = ( SELECT G.UNPOST_REASON FROM PS_RP_GRPCTL_TAO4 G WHERE G.PROCESS_INSTANCE = XXXXXXX
AND G.DEPOSIT_BU = PS_PAYMENT.DEPOSIT_BU AND G.DEPOSIT_ID = PS_PAYMENT.DEPOSIT_ID
AND G.PAYMENT_SEQ_NUM = PS_PAYMENT.PAYMENT_SEQ_NUM), LAST_UPDATE_DTTM = GETDATE(), OPRID_LAST_UPDT = 'OPRID'
WHERE EXISTS ( SELECT 'X' FROM PS_RP_GRPCTL_TAO4 G WHERE G.PROCESS_INSTANCE = XXXXXXX
AND G.GROUP_TYPE = 'U' AND G.DEPOSIT_BU = PS_PAYMENT.DEPOSIT_BU
AND G.DEPOSIT_ID = PS_PAYMENT.DEPOSIT_ID
AND G.PAYMENT_SEQ_NUM = PS_PAYMENT.PAYMENT_SEQ_NUM
AND G.UNPOST_REASON <> ' ')

Process XXXXXXX ABENDED at Step AR_POSTING.DEP_CNTL.UNP_RSN (SQL) -- RC = 8601 (108,524)

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

1. Locate a payment which has been applied to more than one item.
2. Navigate to Accounts Receivable > Receivables Update > Unpost Groups > Payment Group.
3. Open the deposit and payment identified in step 1.
4. Click on the "Partial Unpost" link.
5. On Partial Unpost Worksheet, unselect one item.
6. Add a new line and enter another item with the same balance amount as the unselected item.
7. Click Save.
8. Go to Worksheet Action. under Options tab, set Unpost Reason.
9. Set Posting Action to Batch Standard.
10. Run ARUPDATE.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot unpost partial payment.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.