Home › Discussions › Questions & Answers › Strict Period Name Input Rules for Balance Function

Strict Period Name Input Rules for Balance Function

Avatar photoCustomer Questions & Answers 5 replies

I am having trouble getting data back from the `br_balance` function, even when the period name looks correct. What is the rule for inputting Period Name?

5 replies

  • Support Enginatics

    The rule is strict: the Period Name must exactly match the format configured in Oracle. Case and date format must align precisely.

  • Avatar photoCustomer

    What happens if I use ‘JAN-2007’ when Oracle expects ‘Jan-07’?

  • Support Enginatics

    If you enter variations that do not match Oracle’s format (like ‘JAN-2007’ instead of ‘Jan-07’), it will result in no data being returned.

  • Avatar photoCustomer

    Is there an error message indicating this specific issue?

  • Support Enginatics

    Yes, such a mismatch will trigger an ‘invalid (Period)’ message in the output.

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