My Oracle Support Banner

EBI 9.2:SQL Error When Running PRO-FORMA Invoice "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" (Doc ID 2199928.1)

Last updated on APRIL 26, 2021

Applies to:

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

Symptoms

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


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

Changes

 

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