Go to main content
1/10
Contents
Title and Copyright Information
Preface
Audience
Downloading Oracle Communications Documentation
Documentation Accessibility
Document Revision History
1
About Collecting General Ledger Data
About General Ledger (G/L) Data
How BRM Collects G/L Data
About A/R and Offset Accounts
About Setting Up G/L Reporting
How BRM Stores General Ledger Reports
About G/L IDs
How G/L IDs Affect Storage and Reporting of G/L Data
Planning Your G/L IDs
About Collecting G/L Data for Brands or Selected Accounts
Using Multiple pin_glid Files for Multiple Segments
How Customer Accounts are Assigned to Segments
Creating Nested Segments
Setting up G/L IDs for Brands
About the Chart of Accounts
About Running G/L Reports
About Revenue Recognition
About Reversing G/L Entries
About Immediate Revenue Recognition
About Billed and Unbilled Revenue
Billed and Unbilled Usage Fees
Billed and Unbilled Purchase and Cancellation Fees
Billed Cycle Arrears Fees
Billed and Unbilled Cycle Forward Arrears Fees
Billed and Unbilled Nonrated Events
Billed and Unbilled Cycle Forward Fees
About Unbilled Cycle Forward Fees
About Accrual–Based Revenue Recognition
About Earned and Unearned Cycle Forward Arrears Fees
About Unbilled/Unearned Cycle Forward Fees
About Previously Billed Earned Revenue
About Adjustments and G/L Reporting
About Rounding and G/L Reports
Rounding G/L Report Data After Billing
Rounding G/L Report Data Prior to Billing
How BRM Records the Difference Between Rounded and Unrounded Items
G/L Report Example
2
How BRM Calculates Earned and Unearned Revenue
Understanding the Fields and Values Used to Calculate G/L
About Calculating Earned Revenue
Calculating Billed Earned Revenue
Calculating Previously Billed Earned Revenue
About Calculating Unearned Revenue
3
G/L Reporting Case Studies
About G/L Case Studies
Case Study 1
Case Study 2
Case Study 3
Case Study 4
Case Study 5
Case Study 6
4
Creating General Ledger Reports
About Running G/L Reports
About Exporting G/L Reports to XML Files
About the pin_ledger_report Utility
Controlling the Destination of pin_ledger_report Output
Generating a G/L Report
Creating an Index for the POID_TYPE Column of the ITEM_T Table
Running Reports with the pin_ledger_report Utility
Posting G/L Reports
Example: Posting a Previously Run G/L Report
Example: Unposting a G/L report
Listing Previously-Posted G/L Reports
Example: Listing G/L Reports for a Specified Time Period
Example: Listing G/L Reports for a Specific Segment or Brand
Listing G/L Reports for Specific Types of Revenue
Exporting G/L Reports to XML files
Setting the Number of A/R Accounts per G/L Report
Segregating Unbilled Revenue by G/L Cycle within a Billing Cycle
Setting Up G/L Calendar Configuration
Exporting G/L Information
5
Loading General Ledger Configuration Data
Creating a Chart of Accounts
Creating General Ledger IDs
Changing the Default G/L Segment
Assigning G/L IDs to Nonrated Events
Assigning G/L IDs to Prerated Events
Customizing G/L Data
Enabling Custom Updates to G/L Data
Customizing the PCM_OP_GL_POL_PRE_UPDATE_JOURNAL Policy Opcode
Disabling /journal Objects for Non-Currency Resources
Generating General Ledger Reports Based on the Actual Billing Date
Disabling General Ledger Collection in BRM
6
Exporting General Ledger Reports to XML Files
About Exporting G/L Reports
About Configuring G/L Reports for Export
About Incremental Reports and Cumulative Revenue
About G/L Segments and Cumulative Revenue
About Regenerating and Re-Exporting G/L Reports
How BRM Exports G/L Reports
About Exported G/L Report Files
Sample Output XML File
Configuring G/L Reports for Export
Sample G/L Report Configuration File
Editing the G/L Export Configuration File
Setting Up G/L Reporting Schedules
Filtering Noncurrency Resources
Exporting G/L Reports
Example: Exporting G/L Reports for a Specific G/L Segment
Example: Exporting G/L Reports in Parallel
Example: Regenerating G/L Reports
Example: Re-Exporting G/L Reports
Example: Restarting a Failed Export Operation
Retrieving Audit Data for Exported G/L Reports
Customizing G/L Reports for Export
Customizing G/L Export Report Contents
Mapping BRM G/L Account Names to Third-Party Account Names
Mapping BRM Resource IDs to Third-Party Resource IDs
Customizing the G/L Report XML File Names
Validating and Troubleshooting Exported G/L Reports
Purging G/L Export Data
7
General Ledger Utilities
load_pin_config_export_gl
load_pin_glchartaccts
load_pin_glid
pin_ledger_report
Scripting on this page enhances content navigation, but does not change the content in any way.