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