My Oracle Support Banner

BIP - BRM Base Reports Not Working When Date Range is Passed (Doc ID 2416121.1)

Last updated on MAY 25, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.18.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.18.0 Billing and Revenue Management (BRM) version, Business Intelligence Publisher (BIP) Version 11.1.1.9

When one user was trying to run the BRM Payment reports with date range as input parameters from BIP program, the reports were throwing error.
It happened for PaymentSummary or PaymentDetail reports which took both start date and end date parameters.


ERROR
-----------------------
The report cannot be rendered because of an error, please contact the administrator.
Error Detail
oracle.xdo.servlet.ReportException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to BI Publisher.
2. Navigate to BRM Base Reports.
3. Run the BRM Reports while providing 'to' and 'from' interval which can be used to get the appropriate report.


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