Home › Discussions › Questions & Answers › Configuring br_period_offset to Return a Range

Configuring br_period_offset to Return a Range

Avatar photoCustomer January 4, 2025 at 1:31 am

I need `br_period_offset` to output a period range, for example, the start of the fiscal year up to the current period. How do I configure this?

Viewing 4 reply threads
  • Author
    Replies
    • Support January 5, 2025 at 9:41 pm  

      You must set the Return Range parameter to ‘Yes’. This formats the result as a period range spanning from the offset period to the base period.

    • Avatar photoCustomer January 7, 2025 at 9:02 am  

      Can you give an example of the output format?

    • Support January 8, 2025 at 7:45 pm  

      If the base period is Mar-08 with an offset of -2, the function would return ‘Jan-08-Mar-08’.

    • Avatar photoCustomer January 9, 2025 at 6:59 pm  

      If I am calculating a period range, should I still ensure the base period format is correct?

    • Support January 10, 2025 at 10:42 pm  

      Yes, the Period Name input must exactly match the format configured in Oracle, regardless of the offset or range parameters.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123992

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 20560

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14853

How to check if a patch is applied in Oracle EBS 12.2 14616

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14264

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12113

Migration to Java Web Start in Oracle EBS 12.2 instance 10115

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 10071

Securing sensitive data with Oracle VPD 8061

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6638

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2027
2036
2025
2024
2023
2022
2021
2020
2019
2018