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

Strict Period Name Input Rules for Balance Function

Avatar photoCustomer October 11, 2024 at 1:53 am

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support October 12, 2024 at 10:04 am  

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

    • Avatar photoCustomer October 12, 2024 at 3:05 pm  

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

    • Support October 13, 2024 at 12:54 pm  

      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 October 15, 2024 at 3:09 pm  

      Is there an error message indicating this specific issue?

    • Support October 15, 2024 at 8:58 pm  

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

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

Login with: