Home › Discussions › Questions & Answers › Finding Accounting Period Name from a Specific Date

Finding Accounting Period Name from a Specific Date

Avatar photoCustomer Questions & Answers 5 replies

I have a specific date (e.g., 23-Apr-2025) and need to find the corresponding Oracle accounting period name. Which FSG function performs this lookup?

5 replies

  • Support Enginatics

    You should use the function `br_period_from_date`. This function returns the accounting period name corresponding to the specified date.

  • If the ledger is specified, where does the function get the calendar definition?

  • Support Enginatics

    The period names returned are Ledger-specific, meaning they follow the calendar of the selected ledger.

  • Can I use an offset with this date?

  • Support Enginatics

    Yes, the Offset parameter allows you to retrieve future or past periods by specifying a positive or negative numerical offset value. A negative offset retrieves past periods, such as -1 for the previous period.

  • You must be logged in to reply to this post.