My Oracle Support Banner

R12: AP/CE: The Create Accounting Process on the Secondary Is Failing With Error 95325: “The GL date DD-MON-YYY is not in an open or a future enterable period” Even Though the Related Period Is Open in GL (Doc ID 3067488.1)

Last updated on JANUARY 20, 2025

Applies to:

Oracle Cash Management - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the concurrent program Create Accounting in the Oracle Payables and Cash Management modules, the following error message occurs for the secondary ledger in several transactions:

 

Error Number: 95325
Error Message: The GL date DD-MON-YYY is not in an open or a future enterable period. Please select a valid GL date or open the period.

 

Steps to reproduce the issue:

  1. Log into Oracle applications using a Payables responsibility / Cash Management responsibility
  2. Submit concurrent program "Create Accounting"
    (N) Other> Requests > Run
  3. Enter "Create Accounting" for the name and hit tab
  4. Enter the operating unit and hit tab
  5. Fill out the parameters
  6. Click "OK"
  7. Review the concurrent request output
  8. Switch to General Ledger responsibility related to secondary ledger
  9. Setup - Open/Close
  10. Inquire by that period - Find
  11. The status is Open.

 

The FND Debug Log shows these messages:


MODULE LOG_LEVEL MESSAGE_TEXT
xla.plsql.xla_accounting_err_pkg.stack_error 2 BEGIN of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_appli_s_name = XLA
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_msg_name = XLA_AP_INVALID_GL_DATE
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_entity_id = &entity_id
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_event_id = &event_id
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ledger_id = &ledger_id
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ae_header_id = &ae_header_id
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_ae_line_num =
xla.plsql.xla_accounting_err_pkg.stack_error 2 p_accounting_batch_id =
xla.plsql.xla_accounting_err_pkg.stack_error 1 l_msg_number = 95325
xla.plsql.xla_accounting_err_pkg.stack_error 2 END of procedure STACK_ERROR
xla.plsql.xla_accounting_err_pkg.build_message 2 END of procedure BUILD_MESSAGE
xla.plsql.xla_je_validation_pkg.validate_headers 3 END LOOP - invalid headers
AP.PLSQL.AP_ETAX_UTILITY_PKG.RETURN_TAX_LINES 1 Get open gl_date
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date 1 Begining of Function
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date 1 Index Value: DD-MON-YYYY
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date 1 Period Name not there in plsql table : &period_name

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


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