My Oracle Support Banner

EAR9.2: AR_UPDATE2 ABENDED at Step AR_REV_EST.UPDT_AMT.REV_AMT1 ORA-01407: cannot update ("EMDBO"."PS_RE_ACT_TAO4"."REV_AMT_ITEM") to NULL When Maintenance Offset Follows Unpost Transaction (Doc ID 3044398.1)

Last updated on SEPTEMBER 03, 2024

Applies to:

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

Symptoms

AR_UPDATE2 fails When Maintenance Offset Follows Unpost Transaction:

AR_UPDATE2 ABENDED at Step AR_REV_EST.UPDT_AMT.REV_AMT1 ORA-01407: cannot update ("EMDBO"."PS_RE_ACT_TAO4"."REV_AMT_ITEM") to NULL Failed SQL stmt:

ORA-01407: cannot update ("EMDBO"."PS_RE_ACT_TAO4"."REV_AMT_ITEM") to NULL Failed SQL

 Replication Steps:

1. Enable KK for AR/BI under Set Up Financials/Supply Chain / Install / Installation Option/Products;
2. Create new invoice for 500 USD amount under navigation Account Receivables / Pending Item;
3. Create Deposit Payment for 500 USD amount and put the amount On Account under navigation Account Receivables / Payments/ Online Payments / Regular Deposit;
4. Create new Debit Item for 500 USD amount under Account Receivables / Pending Item;
Check the Customer balance; Item OA is Closed.
5. Unpost the Group ID 443 for the Debit Item created above;
6. Create maintenance worksheet to match the billing invoice and the OA item;
7. Run Receivables Update.
AR_UPDATE2 goes to No Success.

Cause

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
Symptoms
Cause
Solution
References


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