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

Last updated on NOVEMBER 02, 2016

Applies to:

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

Symptoms

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
-----------------------
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


STEPS
-----------------------
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.

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