EBI 9.2: Error Message (235,2309) When Generating ProForma On Invoice Using Format XMLPUB With Bursting Functionality Enabled
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.
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.
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 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 "
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.
The delivered Pro-Forma report online functionality should work regardless of the usage of Bursting feature or not.
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