My Oracle Support Banner

EAR9.2: AR_POSTING Abends at step AR_POSTING.ITEMS.ADDNEW6 with a Unique Constraint "ORA-00001: unique constraint (xxxxxxPS_ITEM_GST) violated" Error (Doc ID 2726015.1)

Last updated on MARCH 15, 2022

Applies to:

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

Symptoms

On : 9.2 version, AR Update - Posting

When attempting to run ARUPDATE job, the following error occurs at Step AR_POSTING.ITEMS.ADDNEW6 (SQL)




Steps To Replicate:

  1. Setup India GST E Invoicing.
  2. Create an online invoice for India Business Unit and India customer with 2 or more lines.
  3. Change the status to RDY.
  4. Run the job BIJOB41.
  5. Run the BI_GST_EINV process for outbound file.
  6. Run the BI_GST_EINV process for inbound file.
  7. Run the Preload process BIPRELD.
  8. Run BILDGL01 process.
  9. Run BILDAR01 process.
  10. Invoice will be sent to AR now.
  11. Set the group to Batch Standard.
  12. Run ARUPDATE.
  13. See the abend.

See the attached document Replication for detailed scenario.

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.