Create Receipts In Spreadsheet - Error: The accounting date {GL_DATE} isn't in an open or future-enterable period. (AR-855086) (Doc ID 2739419.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Symptoms

On : 11.13.20.10.0 version, Customer Payments (Receipts)

When attempting to select Receipt Method in Create Receipts in Spreadsheet,
the following error occurs.

ERROR
-----------------------
The accounting date {GL_DATE} isn't in an open or future-enterable period. (AR-855086)

AR_INVALID_ACCOUNTING_DATE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. User has access to 3 Business Units
2. Periods are open for only 2 Business Units
3. Go to Receivables -> Accounts Receivables -> Create Receipts in Spreadsheet
4. Open the ADFDI template, log in.
5. Notice that the Accounting date is defaulted to 31-05-2019 which is the latest open period for one of the BU's which was defaulted.
6. Change the BU to another value and then try to select the Receipt Method, the error comes up.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create receipts using spreadsheet for the desired Business Unit.

Cause

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