GL Accounting Summary - CI_GLACSM
Parameters
|
Parameter |
Parameter Code |
Description |
|
Accounting Period |
P_ACCT_PERIOD |
Defines the accounting period used for the report. A valid fiscal year and accounting period for a valid accounting calendar must be provided. |
|
Account Type Characteristic |
P_CHAR_TYPE |
Defines a Characteristic Type for a characteristic linked to the Distribution Code to define an Account Type. The account types for the GL accounts are used for grouping the output to the report. |
Report Description
This is a financial audit report used to check the financial details in Oracle Utilities Customer Care and Billing for an accounting period against the GL system. The report summarizes all financial transaction (FT) information for a given accounting period according to the different operating and GL divisions and according to various levels of the account GL information.
Performance Consideration. If your implementation chooses to use this report, you may consider adding an index to the CI_FT table on ACCOUNTING_DT to aid in performance. When making this decision, carefully weigh the benefit of improving report performance against the possible degradation to the performance of day-to-day processing as a result of defining a new index. In addition, many companies opt to create a reporting database that is a shadow of production to ensure that indexes defined to benefit reports may be created without any affect on the production environment.