EGL: Uploading Journal Using Spreadsheet Journal Import (JRNL1_WS) Template Results to Message: 'Adjustment Period Is Not Open'. (Doc ID 2945904.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

There is a requirement to record few entries related to endowments that get submitted on beginning of the year and some throughout the year, and required reversals by yearend.
Using Spreadsheet Journal Import template (JRNL1_WS), user needs to record Journal at certain date, and reverse at the last day of the year. 
For the scenario, the reversal function is used to reverse journals to a specified period. However, this results to error or warning message:

Error/warning message:

Steps to replicate:

1.  Using Spreadsheet Journal Import template, populate header details including Journal Date (i.e. 04/01/2022 and Reverse on 03/31/2023.  Note that this is within same fiscal calendar).
2.  Click 'Import Now' button.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.