My Oracle Support Banner

EBI 9.1+:SQL Error When Running PRO-FORMA Invoice (Doc ID 2199928.1)

Last updated on MAY 16, 2019

Applies to:

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


On 9.2, when attempting to generate the Proforma for the second time in the Express Billing page, system issues a unique constraint error.

Error processing this pro-forma invoice (12501,182) SCM_BI_INVOICE.OnlineOutput.OnExecute Name:ProcessProForma PCPC:520 Statement:14
Called from BI_PB_WRK.PROFORMA_PB.SavePreChange Statement:53

Check the invoice's error status for error details,

The issue can be reproduced at will with the following steps:

  1. Make the Integration Broker setup and overall to activate Vertex;
  2. Create new bill in Express Billing page;
  3. Go to Express Billing and Click on Pro Forma;
  4. The pro-forma is generated correctly;
  5. Click again the pro-forma button;
  6. The SQL error appears;
  7. If trying to generate the pro-forma from Standard Billing, a SQL error appears in this transaction too.


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

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