The Open Account Balances Listing identifies General Ledger accounts with outstanding balances and displays the subledger transactions that contribute to that balance. Users can create their own layout and publish their reports using Oracle XML Publisher.
See:
Oracle XML Publisher Introduction, Oracle XML Publisher User's Guide
Create open account balance definitions in the Create Open Account Balances Listing Definition page.
See: Open Account Balance Listing Definitions
Optionally, to update Open Account Balances Listing processing options, navigate to the Update Open Account Balances Listing Processing Options page by clicking Processing Options in the Open Account Balances Listing Definition Search page.
For each ledger used for open account balance reporting, Subledger Accounting defaults the number of processors to 1 and the processing unit size to 5000. Change these defaults to improve the performance of the Open Account Balances Listing Data Manager.
Note: A processing unit is the number of transactions processed by the Open Account Balances Listing Data Manager in one commit cycle.
Create subledger journal entries and transfer them to General Ledger.
After journal entries are transferred to General Ledger, Subledger Accounting automatically submits the Open Account Balances Listing Data Manager program, which maintains the records in the open account balances tables according to the open account balances listing definitions. Users can also manually submit this program as a concurrent request.
Submit the Open Account Balances Listing.
Users define the accounts to be tracked in the Open Account Balances Listing in the Create Open Account Balances Listing Definition page. Define the report definitions either by Accounting Flexfield or by Accounting Flexfield segments. Associate each definition with a single ledger, which indicates the chart of accounts. The chart of accounts sets the context for the following information in the definition details region:
General Ledger accounts
General Ledger account segments
General Ledger account segment values
Define as many definitions as necessary. If defining a report definition by segment, indicate a single segment value, a range of segment values, or a combination of individual values and ranges for different Accounting Flexfield segments. If defining a report by Accounting Flexfield, include one or more entire General Ledger accounts.
Define a ledger.
See: Primary Ledger Setup Steps, Oracle Financials Implementation Guide
Create journal entries and transfer to General Ledger using the Create Accounting program.
Identify links between source transactions and applied transactions by mapping appropriate sources to the Applied-to accounting attributes.
Note: The Open Account Balances Listing relies on the Applied-to accounting attributes, which also support the business flow feature, to determine how an applied transaction affects the outstanding balance of a source transaction.
Note: Do not create Open Account Balances Definition Codes using SQL reserved keywords as same codes are used to create partitions on Subledger Accountning Trial Balances table internally. This results in an error.
When the ledger is defined, the details region displays data according to the value selected in the Defined By field.
Field Name | Description |
---|---|
Code | Unique internal identifier
Note: For technical reasons, the Open Account Balances Listing code cannot contain spaces. |
Defined By | The display in the Details region is determined by the option selected |
Journal Source | Limits information displayed in the report to transactions belonging to the subledger using this journal source |
Balance Side | Determines how applied transactions affect the balance of an account impacted by the original transaction. When the balance side is credit, all debit entries are subtracted from the credit amount to determine the amount remaining. If the balance side is Debit, all credit entries are subtracted from the debit amount to determine the amount remaining. |
Enabled | Indicates whether the report definition is enabled. A disabled report definition does not gather, record, or report open account balance data. |
Segment | Displayed if the Defined By field is Segment. The default is the segment flagged as the natural account segment qualifier. |
Value From/Value To | Displayed if the Defined By field is Segment; specifies the range of segment values to be considered for open account balance reporting. To specify a single value, enter the same value in both fields. |
Note: You cannot update the following fields:
Code
Ledger
Defined By
Journal Source
Balance Side
The Open Account Balances Data Manager maintains reportable information for all enabled open account balance listing definitions. This program is submitted automatically after a successful transfer to General Ledger for the same ledger or manually by running the Open Account Balances Data Manager program. When changes are applied to a Open Account Balances Listing Definition, the Open Account Balances Data Manager program is automatically submitted for the changed definition.
The Open Account Balances Data Manager processes subledger journal entries that are transferred to General Ledger and also final accounted journal entries that are flagged as No Transfer because these entries are already represented in General Ledger.
In the Submit Request window, select Open Account Balance Data Manager.
Enter parameters as described in the table below.
Parameter | Description |
---|---|
Ledger | Provides the context for handling open account balance reportable data |
Report Definition | Limits processing to the report definition entered |
The Open Account Balances Listing displays a General Ledger account, its balance, and a listing of the transactions that contribute to that balance. This report displays the actual accounted balance and does not include encumbrance or budgetary accounts in General Ledger. Users can view the report in detail or summary mode.
This report displays information that originates from subledger journal entries only. Journal entries created manually in General Ledger or anywhere outside of Subledger Accounting are not included. Only transactions with nonzero outstanding balances are displayed.
Subledger Accounting seeds the following templates:
Group by Account, Applied Transaction Detail
This template groups the output by General Ledger account. For each account, the report shows the General Ledger balance and the transactions (grouped by third party) that contribute to the balance of that account.
Group by Account, Summarized
This template groups and summarizes the output by General Ledger account.
Group by Third Party, Applied Transaction Detail
This template groups output by third party. For each third party, the report displays the General Ledger accounts and transactions with outstanding balances.
Note: For the Group by Third Party templates, General Ledger account balances are not displayed because General Ledger does not track individual balances for third parties, only the net balances of an account.
Group by Third Party, Summarized
This template groups the output by third party with one row summarizing each account. No transactions are displayed. For each third party, one row is displayed for every General Ledger account having an outstanding balance.
Parameter | Required | Valid Values |
---|---|---|
Report Definition | Yes | All enabled report definitions; displays definition name, ledger, description, and code |
Journal Source | No | Journal source attached to the application submitting the report. Can be changed only if the SLA: Allow Reports Journal Source Override profile option is enabled. See: SLA: Allow Reports Journal Source Override List of values lists all journal sources assigned to the report definition. |
Start Date | Yes | Defaults to first date of the current fiscal year |
As Of Date | No | GL date of journal entries up to which the open account balance listing will include |
Third Party Name | No | Third parties whose type is either Customer or Supplier. The list of values lists third party name and third party type. |
Show Applied Transaction Detail | Yes | Yes or No; determines whether output displays parent and dependent transaction information. Default is No. |
Include Write Off Balances | Yes | Yes or No; determines whether to show outstanding balances that are the result of write-off accounting. Default is No. |
Account From/To | No | Limits report output by filtering values entered here against reportable values assigned to the report definition |
Account Balance | Yes | List of values options are Year to Date and Current Period. |
Note: Use the following custom parameters to pass information to the template.
Parameter | Required | Valid Values |
---|---|---|
Security Parameter | No | Hidden parameter for use by uptaking subledgers |
Valuation Method | No | No validation |
Security Identifier (Number) | No | No validation |
Security Identifier (Character) | No | No validation |
Custom Parameter 1 | No | No validation |
Custom Parameter 2 | No | No validation |
Custom Parameter 3 | No | No Validation |
The table below describes the information that is retrieved by the Open Account Balances Listing. Users can create new XML Publisher templates using any of these data elements.
See: Creating a Template, Oracle XML Publisher User's Guide
Note: Not all data elements have a corresponding field on the seeded open account balance templates. For the fields not included on the seeded templates, the field name column shows the suggested label for the field.
Template Field Name | Data Element (XML Tag) | Source / Description |
---|---|---|
Account | ACCOUNT | Accounting Flexfield value |
GL Balance | GL_BALANCE | General Ledger account balance |
CODE_COMBINATION_ID | Account code combination identifier | |
BALANCING_SEGMENT_VALUE | Balancing segment value | |
BALANCING_SEGMENT_DESC | Balancing segment value description | |
NATURAL_ACCOUNT_SEGMENT_VALUE | Natural account segment value | |
NATURAL_ACCOUNT_SEGMENT_DESC | Natural account segment value description | |
COST_CENTER_SEGMENT_VALUE | Cost center segment value | |
COST_CENTER_SEGMENT_DESCR | Cost center segment value description | |
MANAGEMENT_SEGMENT_VALUE | Management segment value | |
MANAGEMENT_SEGMENT_DESC | Management segment value description | |
INTERCOMPANY_SEGMENT_VALUE | Intercompany segment value | |
INTERCOMPANY_SEGMENT_DESC | Intercompany segment value description | |
LEDGER_ID | Internal identifier of the ledger corresponding to the report definition | |
Ledger | LEDGER_NAME | Ledger name |
LEDGER_SHORT_NAME | Ledger short name | |
Curr | LEDGER_CURRENCY_CODE | Ledger currency code |
Third Party | THIRD_PARTY_NAME | Third party name referenced on the source transaction |
THIRD_PARTY_NUMBER | Number assigned to the third party referenced on the source transaction | |
THIRD_PARTY_TYPE | Third party type for the source transaction | |
THIRD_PARTY_TYPE_CODE | Third party type code for the source transaction | |
THIRD_PARTY_SITE_NAME | Third party site name referenced on the source transaction | |
SOURCE_ENTITY_ID | Source entity internal identifier | |
SOURCE_TRX_APPLICATION_ID | Internal identifier of the application that owns the source transaction | |
SOURCE_TRX_APPLICATION_NAME | Name of the application that owns the source transaction | |
Transaction Type | SOURCE_TRX_TYPE | Source transaction type |
Transaction Number | SOURCE_TRX_NUMBER | Source transaction number |
Date | SOURCE_TRX_GL_DATE | Source transaction GL date |
SOURCE_TRX_CURR | Source transaction currency | |
SRC_ENTERED_UNROUNDED_ORIG_AMT | Unrounded original amount of the source transaction in the entered currency | |
SRC_ENTERED_UNROUNDED_REM_AMT | Unrounded remaining amount of the source transaction in the entered currency | |
SRC_ENTERED_ROUNDED_ORIG_AMT | Rounded original amount of the source transaction in the entered currency | |
SRC_ENTERED_ROUNDED_REM_AMT | Rounded remaining amount of the source transaction in the entered currency | |
SRC_ACCTD_UNROUNDED_ORIG_AMT | Unrounded original amount of the source transaction in the ledger currency | |
SRC_ACCTD_UNROUNDED_REM_AMT | Unrounded remaining amount of the source transaction in the ledger currency | |
Original Amount | SRC_ACCTD_ROUNDED_ORIG_AMT | Rounded original amount of the source transaction in the ledger currency |
Remaining Amount | SRC_ACCTD_ROUNDED_REM_AMT | Rounded remaining amount of the source transaction in the ledger currency |
APPLIED_TO_APPLICATION_ID | Internal identifier of the application that owns the applied transaction | |
USER_TRX_IDENTIFIER_NAME_1 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_2 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_3 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_4 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_5 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_6 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_7 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_8 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_9 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_NAME_10 | Source transaction identifier name | |
USER_TRX_IDENTIFIER_VALUE_1 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_2 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_3 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_4 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_5 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_6 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_7 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_8 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_9 | Source transaction identifier value | |
USER_TRX_IDENTIFIER_VALUE_10 | Source transaction identifier value | |
APPLIED_THIRD_PARTY_NAME | Third party name on the applied transaction | |
APPLIED_THIRD_PARTY_NUMBER | Third party number on the applied transaction | |
APPLIED_THIRD_PARTY_TYPE | Third party type on the applied transaction | |
APPLIED_THIRD_PARTY_TYPE_CODE | Third party type code on the applied transaction | |
APPLIED_THIRD_PARTY_SITE_NAME | Third party site name on the applied transaction | |
APPLIED_TO_ENTITY_ID | Entity identifier to which the transaction is applied | |
APPLIED_TRX_APPLICATION_ID | Application internal identifier to which the transaction is applied | |
Application | APPLIED_TRX_APPLICATION_NAME | Name of the application that owns the applied transaction |
Type | APPLIED_TRX_TYPE | Applied transaction type |
Number | APPLIED_TRX_NUMBER | Applied transaction number |
Date | APPLIED_TRX_GL_DATE | Applied transaction GL date |
APPLIED_TRX_CURR | Applied transaction currency | |
APPLIED_ENTERED_UNROUNDED_AMT | Unrounded amount applied to the source transaction in the entered currency | |
APPLIED _ENTERED_ROUNDED_AMT | Rounded amount applied to the source transaction in the entered currency | |
APPLIED _ACCTD_UNROUNDED_AMT | Unrounded amount applied to the source transaction in the ledger currency | |
Applied Amount | APPLIED _ACCTD_ROUNDED_AMT | Rounded amount applied to the source transaction in the ledger currency |
APPLIED_USER_TRX_IDENTIFIER_NAME_1 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_2 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_3 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_4 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_5 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_6 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_7 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_8 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_9 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_NAME_10 | Applied transaction identifier name | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_1 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_2 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_3 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_4 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_5 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_6 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_7 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_8 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_9 | Applied transaction identifier value | |
APPLIED_USER_TRX_IDENTIFIER_VALUE_10 | Applied transaction identifier value |