My Oracle Support Banner

EBI 9.2: Error Message (235,2309) When Generating ProForma On Invoice Using Format XMLPUB With Bursting Functionality Enabled (Doc ID 2372752.1)

Last updated on FEBRUARY 01, 2021

Applies to:

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

Symptoms

ISSUE:

Having implemented the solution provided for <Bug 26551717> (BI: Abended At Step BIIVC000.SELBILLS.VATTMPS Upon Applying <Bug 25990190>), should a User create a new Billing Invoice, using the Invoice Format XMLPUB, if the ProForma process is launched online to finalize the transaction, the system is throwing an Error Message.

This happens if at the XML BI Publisher Report Definition level for BI_PRNXPN01 the Bursting functionality has been enabled by BILL_TO_CUST_ID.

REPLICATION STEPS:

     1.- Have an FSCM 9.2 Image #25 environment, with the PRP solution from <Bug 26551717> applied
     2.- Log into the FSCM 9.2 Image #25 environment as a Billing User
     3.- Navigate to: Reporting Tools > BI Publisher > Report Definition
     4.- Open the existing definition for BI_PRNXPN01
     5.- Go to the Bursting tab, and ensure to set up the following configuration:
          - Burst By = BILL_TO_CUST_ID
          - Template controlled by = BILL_TO_CUST_ID
          - Data Value = BILL_TO_CUST_ID
          - Template ID = BI_PRNXPN01_1
          - Language = English
          - Search Field = BILL_TO_CUST_ID
     6.- Navigate to: Billing > Maintain Bills > Standard Billing
     7.- Add a brand new Invoice in a Business Unit with VAT functionality, such as CAN01, with Customer ID 1008
     8.- Fill in the Bill Type Identifier as PMB, and ensure that the Invoice Form field is defined as XMLPUB
     9.- Save the changes
     10.- Launch the Pro Forma Job for this new Invoice (BIJOBP03)
     11.- The system throws an online Error Messages

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

     " Error generating report output: (235,2309) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name: ProcessReport PCPC: 83664 Statement: 1670
       Called from: SCM_BI_XMLP.BI_XMLP.OnExecute Name: DoProcessReport Statement: 47
       Called from: SCM_BI_XMLP.XMLFile.OnExecute Name: GenReport Statement: 11
       Called from: SCM_BI_INVOICE.OnlineOutput.OnExecute Name: GenerateRpt Statement: 80
       Called from: SCM_BI_INVOICE.OnlineOutput.OnExecute Name: ProcessProForma Statement: 39
       Called from: BI_PB_WRK.PROFORMA_PB.SavePreChange Stateme "

ACTUAL RESULT:

Billing Users are unable to successfully run the Pro-Forma process on the new Invoice created, should Bursting functionality have been enabled at the XML Report Definition level, and hence the transaction cannot be finalized.

EXPECTED BEHAVIOR:

The delivered Pro-Forma report online functionality should work regardless of the usage of Bursting feature or not.

 

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.