My Oracle Support Banner

Error When Accounting For Lease Revision Transaction: Subledger Accounting Was Unable To Retrieve A Value For The Accounting Flexfield Account Rule. (Doc ID 2923603.1)

Last updated on MAY 18, 2023

Applies to:

Oracle Fusion Lease Accounting - Version and later
Information in this document applies to any platform.


When attempting to generate accounting for the Lease Accounting module, the following error occurs.

Subledger Accounting was unable to retrieve a value for the accounting flexfield account rule.
Cause: GL account can't be derived by account rule.
Action: Review the account rule definition and the extract source values, if applicable, for the event and make sure a valid GL account can be derived for the subledger journal entry.

The issue can be reproduced at will with the following steps:
1. run Create Accounting for Lease Accounting application
2. check Create Accounting Execution Report
3. see that certain events have this error and that the accounts could not be generated for them.

Example from Lease Revision transaction:

Event Class: Lease Revision
Event Type: Lease Revision

Line Accounting Class       Account                                                                                   Entered Currency  Entered Debit  Entered Credit
1                         Asset       123.116000.0000000.0000000.000.0000.0000.0000000.0000000   USD                        199.73               0.00
2                         Liability    123.208000.0000000.0000000.000.0000.0000.0000000.0000000   USD                         0.00                 199.73
3                         Liability   <null>                                                                                        USD                         59.98                0.00 ----> the account could not be generated for this line
4                         Asset       123.116000.0000000.0000000.000.0000.0000.0000000.0000000   USD                         0.00                 59.98


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

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