WS: 09: Transactions with Enhanced Subledger Type 1 or Type 2 Detail do not Post in Detail in the Account Balance Records (P09870) (Doc ID 2787511.1)

Last updated on DECEMBER 01, 2022

Applies to:

Symptoms

When using Enhanced Subledger Accounting, transactions with either (or both) Enhanced Subledger Type 1 or Enhanced Subledger Type 2 information on the F0911 detail records may fail to post in detail (where the Enhanced Subledger Type 1 / Type 2 value becomes part of the unique key) in the Account Balance (F0902) record, and instead the update to the F0902 balance is done in summary on only the primary record for the account in question.  Conversely, transactions with either (or both) Enhanced Subledger Type 3 or Enhanced Subledger Type 4 information on the F0911 detail DO post in detail to the F0902 balance records, resulting in additional F0902 records for the account in question where the Enhanced Subledger information (for example the Enh Subledger Code 1 and Enh Subledger Type 1 values) makes up part of the unique key.

Steps to produce the issue:

1. Ensure that Enhanced Subledger Types, Categories, and Rules have been set up for ESA Type 1 and/or 2.
2. Enter a journal entry with ESA Type and Code populated for either ESA Type 1 and/or ESA Type 2 on at least one line of the journal entry.
3. Post the journal entry batch.
4. Review the F0911 and F0902 records created/updated as a result of the post and observe that ESA information is present on the F0911 records (thus posting in detail), while the ESA information is not present on the F0902 records (thus posting in summary).

Changes

Cause

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