How To Resolve the Error "ORA-00001: unique constraint (SYSADM.PS_INTFC_BI) violated" when Running the 'OM Billing Interface' Process (OM_BILL)

(Doc ID 1367466.1)

Last updated on FEBRUARY 03, 2017

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 8 SP1 and later
Information in this document applies to any platform.


The 'OM Billing Interface' process (OM_BILL) (navigation: Order Management, Quotes and Orders, Create OM Billing Entries, Process OM Billing) fails with the following error:

SQL error. ORA-00001: unique constraint (SYSADM.PS_INTFC_BI) violated.

Process 16052812 ABENDED at Step OM_BILL.MCA.Step01 (SQL) -- RC = 805 (108,524)

How to resolve it?


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