My Oracle Support Banner

BI Publisher: Relative Dates In BRM Base Reports (Doc ID 1572784.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

This article is to answer the below queries related to Oracle Communications Billing and Revenue Management(BRM) base reports in BI Publisher.

Qn1:

BRM base reports (BRM 7.5.0.0.0 version) in BI Publisher need to be scheduled and run on the 1st of every month for the last full month. Most BRM reports take the start and end date as a parameter.
How to schedule these reports to use a relative start/end date for the last month?
 
Qn2:
Is there an expression to get the last full month? In other words, if it runs on the 1st it would use the previous first day of month and the previous last day of month?

Solution

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