EAR9.2: AR_UPDATE2 Fails At Step AR_REV_EST.ITEMREV.INDSTBI (SQL)

(Doc ID 1993818.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

Statement of the issue:
------------------------------
AR_UPDATE2 fails at Step AR_REV_EST.ITEMREV.INDSTBI (SQL)

Error Message:
-----------------------
AR_UPDATE2 fails at Step AR_REV_EST.ITEMREV.INDSTBI (SQL)

File: e:\pt854-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Positi on: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_RE_IN_DST_TAO4) violated Failed SQL stmt: INSERT INTO PS_RE_IN_DST_TAO4

Process 30756 ABENDED at Step AR_REV_EST.ITEMREV.INDSTBI (SQL) -- RC = 805

Steps to Replicate:
-------------------------

  1. Create an invoice with 3 lines with two lines with discount.
  2. Send the invoice created in step 1 to AR with three lines to AR in PS_PENDING_DST table.
  3. Run ARUPDATE to post this item.
  4. Apply payment against the item.
  5. Run ARUPDATE.

Cause

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