The Subledger Period Close Exceptions Report lists all accounting events and journal entries that fail period close validation. It is automatically submitted by General Ledger when closing a GL period if there are unprocessed accounting events or untransferred journal entries.
You can also generate the Subledger Period Close Exceptions Report through a concurrent request as follows:
For the application associated with the responsibility
For all applications in the General Ledger responsibility
Subledger Period Close Exceptions Report Parameters
| Parameter | Required | Valid Values |
|---|---|---|
| Ledger /Ledger Set | Yes | All ledgers and ledger sets included in the access set identified by the profile options GL: Data Access Set and SLA: Additional Access Set |
| Period From | Yes | All periods from the accounting calendar associated with the selected ledger or ledger set |
| Period To | Yes | All periods from the accounting calendar equal to or coming after the From period up to the end of the fiscal year |
| Journal Source | No | All General Ledger journal sources registered with Subledger Accounting |
| Event Class | No; enabled only when a concurrent request is submitted for a specific journal source | All event classes enabled for the application associated with the journal source |
| Journal Category | No; enabled only when a concurrent request is submitted for a journal source | All journal categories used by Subledger Accounting |
Note: Not all data elements have a corresponding field on the seeded subledger period close exceptions report templates.
Subledger Period Close Exceptions Report Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Event Date | EVENT_DATE | Event date; if journal entry exists, journal entry GL date |
| Transaction Created by | CREATED_BY | User who submitted the Subledger Accounting program |
| Creation Date | CREATION_DATE | Event creation date; if journal entry exists, journal entry creation date |
| Last Update Date | LAST_UPDATE_DATE | Last date event updated; if journal entry exists, last date journal entry updated |
| User Name | USER_NAME | In case of events, name of user who created the event; in case of journal entries, name of user who created the journal entries |
| Transaction Number | TRANSACTION_NUMBER | Subledger transaction number |
| Transaction Date | TRANSACTION_DATE | Subledger transaction date |
| Application Id | APPLICATION_ID | Internal identifier of the application owning the journal entry or accounting event |
| Ledger ID | LEDGER_ID | Internal identifier of the ledger owning the journal entry or accounting event |
| Ledger Short Name | LEDGER_SHORT_NAME | Short name of the ledger owning the journal entry or accounting event |
| Ledger Description | LEDGER_DESCRIPTION | Description of the ledger owning the subledger journal entry |
| Ledger Name | LEDGER_NAME | Name of the ledger owning the subledger journal entry or accounting event |
| Ledger Currency | LEDGER_CURRENCY | Currency of the ledger owning the subledger journal entry or accounting event |
| Status | PRINT_STATUS | Accounting event status if no journal entries exist If journal entry exists: if it is accounted in final mode, status of the General Ledger transfer status code; otherwise status of the journal entry |
| On Hold Flag | ON_HOLD_FLAG | Indicates whether event is on hold; Y for Yes, N for No |
| On Hold | ON_HOLD_FLAG | Values are Yes or No. |
| Journal Category Name | JOURNAL_CATEGORY_NAME | Journal category name associated with the event class of the event |
| USER_JE_CATEGORY_NAME | Journal category name associated with the event class of the event in user's language | |
| Journal Source Name | JOURNAL_SOURCE | Journal source associated with the application owning the journal entry |
| USER_JE_SOURCE | Journal source associated with the application owning the journal entry in user's language | |
| Event Id | EVENT_ID | Accounting event internal identifier |
| Event Date | ACCOUNTING_DATE | Event date of the accounting event; if journal entry exists, accounting date of the journal entry |
| Event Number | EVENT_NUMBER | Accounting event number |
| Event Class Code | EVENT_CLASS_CODE | Event class code of the accounting event |
| Event Class Name | EVENT_CLASS_NAME | Event class name of the accounting event |
| Event Type Code | EVENT_TYPE_CODE | Event type code of the accounting event |
| Event Type Name | EVENT_TYPE_NAME | Event type name of the accounting event |
| User Transaction Identifier Name | USER_TRX_IDENTIFIER_NAME_1 (to 10) | User transaction identifiers column names attached to the event class of the accounting event |
| User Transaction Identifier Value | USER_TRX_IDENTIFIER_VALUE_1 (to 10) | User transaction identifiers values attached to the event class of the accounting event |
| Balance Type | BALANCE_TYPE | Valid only for journal entries and not for events; balance type of the journal entry. Possible values include Actual, Budget, and Encumbrance. |
| Balance Type Code | BALANCE_TYPE_CODE | A for Actual, B for Budget, and E for Encumbrance |