Home › Discussions › Questions & Answers › Date Input Rules for Journal Effective Date Balance Types

Date Input Rules for Journal Effective Date Balance Types

Avatar photoCustomer June 17, 2022 at 3:54 am

I am using the JED (Journal Effective Date) balance type. Does the Period parameter accept standard date inputs, and how should I handle ranges?

Viewing 6 reply threads
  • Author
    Replies
    • Support June 18, 2022 at 9:32 am  

      Yes, for JED, JEDP, or JEDU balance types, the period parameter functions as a date parameter, accepting date ranges like ’01/01/2007-05/01/2007′.

    • Avatar photoCustomer June 20, 2022 at 2:25 am  

      If my regional settings use hyphens for dates (e.g., 01-01-2007), will that cause issues?

    • Support June 20, 2022 at 8:31 pm  

      Yes, because the hyphen (“-”) serves as a range delimiter in Blitz FSG, you must avoid using it as a date separator.

    • Avatar photoCustomer June 21, 2022 at 3:53 am  

      What is the recommended date format to ensure compatibility?

    • Support June 21, 2022 at 11:46 am  

      We recommend using slashes (“/”) as date separators and ensuring that you format the dates as text in Excel to prevent automatic conversion based on your regional settings.

    • Avatar photoCustomer June 23, 2022 at 10:30 am  

      What is the difference between JED and JEDP?

    • Support June 23, 2022 at 4:04 pm  

      JED captures journal activity that is both posted and unposted, while JEDP only includes posted journals for the specified date range.

  • Author
    Replies
Viewing 6 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™ 123806

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14683

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11999

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9946

Migration to Java Web Start in Oracle EBS 12.2 instance 9938

Securing sensitive data with Oracle VPD 7865

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

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