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 |