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 MARCH 12, 2018

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.

 

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