My Oracle Support Banner

EBI 9.2: Generate Recurring Invoices BIRECUR Process Failed With an Error, "Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_BI_HDR_TMP) violated" (Doc ID 2961335.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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

Symptoms



Generate Recurring Invoices process (BIRECUR) failed with the following error. 

Error:
-----------------------
Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_BI_HDR_TMP) violated





Replication Steps:
-----------------------------
1. Run BIRECUR with the run control option as ALL  from Billing - Maintain Bills - Create Recurring Bills.




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


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