My Oracle Support Banner

R12: AP/XLA: Create Accounting for an AP Invoice with Multiperiod Accounting (MPA) is Failing with "A multiperiod journal entry cannot be created because there is no GL period defined corresponding to its GL date" (Doc ID 2929392.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle Subledger Accounting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 The user has created an AP invoice with Multiperiod Accounting (MPA) - At invoice lines level, checked the option 'Deferred Option', inserted the following dates on 'Deferred Start Date' <01-Jan-2021> & 'Deferred End Date' <01-Jan-2020> and on the invoice line segment flexfield inserted the Multiperiod Accounting (MPA) trigger. 

 Further, the accounting is failing with accounting error:

 

Error Number: 0
Error Message: A multiperiod journal entry cannot be created because there is no GL period defined corresponding to its GL date for the ledger &ledger name. Please check the source values and assignments for multiperiod accounting attributes and modify if necessary.

 

Steps to reproduce the issue:

  1. Subledger Accounting Method is set up as Multiperiod Accounting (MPA).
  2. Log in a Payables responsibility and create an AP invoice with Multiperiod Accounting (MPA)
  3. At the invoice lines level, check the option 'Deferred Option', insert the following GL dates on 'Deferred Start Date' <01-Jan-2021> & 'Deferred End Date' <01-Jan-2020> and insert on invoice line segment flexfield the Multiperiod Accounting (MPA) trigger.
  4. Validate the invoice.
  5. Run the concurrent program Create Accounting.
  6. Review the output of the concurrent program Create Accounting - Subledger Accounting Program Report.

 

 

Changes

 The Subledger Accounting Method is set up as Multiperiod Accounting (MPA).

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.