Journal and Transaction Details Report
The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level details. It includes the account combinations on each line for the selected accounts.
- You can run and schedule this report only from Oracle Analytics Publisher. From the Reports and Analytics work area, select Browse Catalog, and then expand Shared Folders, Financials, General Ledger, Journals.
- The report can be run by ledger set and accounting date range, as well as for multiple ledgers and subledger applications.
- The output from the report includes a wide set of attributes from the various subledgers.
- Data access set security is enforced on the ledger and ledger set for the user submitting the report.
Here are some key points for report administrators.
- The report data model consolidates customer requirements to get the journal and transaction details of multiple subledgers, ledgers, accounting periods for various chart of account segments. These are the most commonly used functionalities for which report customizations are done, and they've been incorporated into the Journal and Transaction Details report.
- The SQL query can be taken as a basic structure and further modified to meet business requirements. Modules from the query can be reused to create other Analytics Publisher reports.
- The SQL query consists of multiple WITH clause views that provide specific information from various subledgers. Review the data model comments for more details of each view.
- To ease modification, the report doesn’t use Before Report triggers or PL/SQL packages.
Parameters
This table describes the report parameters and whether they're required.
Parameter | Description | Required |
---|---|---|
Ledger Set | Select a ledger set. | No |
Ledger | Accept the default value of All ledgers or select one or more ledgers. If you selected a ledger set, you can select one or more ledgers for that ledger set. | Yes |
From Period | Specify the starting accounting period. | Yes |
To Period | Specify the ending accounting period. | Yes |
Subledger | Select one or more subledgers. | Yes |
Event Class | Select one or more event classes for the selected subledger. | No |
From Accounting Date | Specify the starting accounting date. | No |
To Accounting Date | Specify the ending accounting date. | No |
Natural Account | Select one or more chart of accounts segment values with the Natural Account Segment label. The values listed are based on the chart of accounts associated with the selected ledgers. | No |
Primary Balancing Segment Value | Select one or more chart of accounts segment values with the Primary Balancing Segment label. The values listed are based on the chart of accounts associated with the selected ledgers. | No |
Financial Category | Select one or more financial categories. | No |
Report Output
This table describes the fields in the report output and the type of information they represent.
Field | Description | Information Type |
---|---|---|
Event Class | Group of accounting event types. | Subledger Accounting |
Entity Code | Unique name assigned to an entity. | Subledger Accounting |
Ledger | Name of the ledger. | General Ledger |
Ledger Category | Type of ledger, such as primary or secondary. | General Ledger |
Ledger Currency | Currency of the ledger. | General Ledger |
Period | Accounting period of the journal. | General Ledger |
Journal Source | Source of the journal. | General Ledger |
Journal Category | Category of the journal. | General Ledger |
Journal Batch | Name of the journal batch. | General Ledger |
Journal | Name of the journal header. | Subledger Accounting |
Journal Description | Description of the journal header. | Subledger Accounting |
Entered Currency | Currency of the journal. | Subledger Accounting |
Journal Line Number | Number of the journal line. | Subledger Accounting |
Journal Line Description | Description of the journal line. | Subledger Accounting |
Segment 1 | Chart of accounts segment 1 value. | General Ledger |
Segment 2 | Chart of accounts segment 2 value. | General Ledger |
Segment 3 | Chart of accounts segment 3 value. | General Ledger |
Segment 4 | Chart of accounts segment 4 value. | General Ledger |
Segment 5 | Chart of accounts segment 5 value. | General Ledger |
Segment 6 | Chart of accounts segment 6 value. | General Ledger |
Segment 7 | Chart of accounts segment 7 value. | General Ledger |
Segment 8 | Chart of accounts segment 8 value. | General Ledger |
Segment 9 | Chart of accounts segment 9 value. | General Ledger |
Segment 10 | Chart of accounts segment 10 value. | General Ledger |
Account | Concatenation of chart of account segment values, which represents a full account combination. | General Ledger |
Posting Date | Date when the journal batch was posted. | General Ledger |
Accounting Date | Date used to determine the accounting period and rates for foreign currency journals. | Subledger Accounting |
Balance Type | Type of balance, such as actual or encumbrance. | General Ledger |
Transaction Number | Transaction number of the subledger journal. | Subledger Accounting |
Journal Source Distribution Type | Distribution type of the journal source. | Subledger Accounting |
Accounting Class Code | Accounting class associated with the journal line. | Subledger Accounting |
Net Accounted Amount | Accounted debits net of accounted credits for the journal. | Subledger Accounting |
Net Entered Amount | Entered debits net of entered credits for the journal. | Subledger Accounting |
Business Unit | Name of the business unit. | Header Level |
Document Number | Number of the invoice or transaction. | Header Level |
Document Date | Date of the invoice or transaction. | Header Level |
Document Description | Description of the invoice or transaction. | Header Level |
Document Type Lookup Code | Type of invoice or transaction. | Header Level |
Document Status | Status of the invoice or transaction | Header Level |
Subledger Entered Currency | Entered currency of the subledger transaction. | Header Level |
Document Amount | Amount of the invoice or transaction. | Header Level |
Subledger Accounted Amount | Accounted amount of the subledger transaction. | Header Level |
Document Line Number | Number of the invoice or transaction line. | Line Level |
Document Line Description | Description of the invoice or transaction line. | Line Level |
Document Line Type Lookup Code | Type of invoice or transaction line. | Line Level |
Document Line Accounted Amount | Accounted amount of the invoice or transaction line. | Line Level |
Document Line Amount | Amount of the invoice or transaction line. | Line Level |
Distribution Line Number | Number of the invoice or transaction distribution line. | Distribution Level |
Distribution Type Code | Type of invoice or transaction distribution. | Distribution Level |
Distribution Accounted Amount | Accounted amount of the invoice or transaction distribution. | Distribution Level |
Distribution Entered Amount | Entered amount of the invoice or transaction distribution. | Distribution Level |
Party Name | Name of the party. | Party Information |
Party Site Name | Name of the party site. | Party Information |
For the mapping of table columns in the different subledger applications to the fields with the information types of Header Level, Line Level, Distribution Level, and Party Information, see the related topic on Oracle Customer Connect.