B Oracle BRM XML GL Report

This appendix provides a sample Oracle Communications Billing and Revenue Management (Oracle BRM) General Ledger (GL) report.

Example B-1 is a sample of the Oracle BRM XML GL report:

Example B-1 Sample Oracle BRM GL report

- <GeneralLedgerReport targetNamespace="http://www.portal.com/schemas/GLSync" xmlns="http://www.portal.com/schemas/GLSync" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.portal.com/schemas/GLSync brm_gl_data.xsd">
   <SourceSystemID>202</SourceSystemID> 
   <ReportID>0.0.0.1-73988-6</ReportID> 
   <RevenueType>Unbilled earned</RevenueType> 
   <BRM_GL_Segment>.</BRM_GL_Segment>
-       <ReportCreatedTime>
   <Year>2007</Year>
   <Month>01</Month>
   <Day>02</Day>
   <Hours>4</Hours>
   <Minutes>14</Minutes>
   <Seconds>51</Seconds>
   </ReportCreatedTime>
-       <PeriodStartTime>
   <Year>2007</Year>
   <Month>01</Month>
   <Day>04</Day>
   <Hours>0</Hours>
   <Minutes>0</Minutes>
   <Seconds>0</Seconds>
   </PeriodStartTime>
-       <PeriodEndTime>
   <Year>2007</Year> 
   <Month>01</Month> 
   <Day>05</Day> 
   <Hours>0</Hours> 
   <Minutes>0</Minutes> 
   <Seconds>0</Seconds> 
   </PeriodEndTime>
-       <RevenueAmounts element="0">
   <ResourceId>84 0</ResourceId>
   <BRM_GL_ID>102</BRM_GL_ID>
-       <ARGrossAccount name="monthly.debit">
   <Credit>0</Credit>
   <Debit>0.32</Debit> </ARGrossAccount>
-       <ARDiscountAccount name="monthly.credit">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </ARDi scountAccount>
-       <ARNetAccount name="monthly.debit">
   <Credit>0</Credit>
   <Debit>0.32</Debit> 
   </ARNetAccount>
-       <ARTaxAccount name="-- N/A --">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </ARTaxAccount >
-       <OffsetGrossAccount name="monthly.credit">
   <Credit>0.32</Credit>
   <Debit>0</Debit>
   </OffsetGrossAccount>
-       <OffsetDiscountAccount name="monthly.debit">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </OffsetDiscountAccount>
-       <OffsetNetAccount name="monthly.credit">
   <Credit>0.32</Credit>
   <Debit>0</Debit>
   </OffsetNetAccount>
-       <OffsetTaxAccount name="-- N/A --">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </OffsetTaxAccount> 
   </RevenueAmounts>
   <RevenueAmounts element="1">
   <ResourceId>84 0</ResourceId>
   <BRM_GL_ID>104</BRM_GL_ID>
-       <ARGrossAccount name="dialup.debit">
   <Credit>0</Credit>
   <Debit>0.10</Debit> 
   </ARGrossAccount>
-       <ARDiscountAccount name="dialup.credit">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </ARDi scountAccount>
-       <ARNetAccount name="dialup.debit">
   <Credit>0</Credit>
   <Debit>0.10</Debit> 
   </ARNetAccount>
-       <ARTaxAccount name="-- N/A --">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </ARTaxAccount >
-       <OffsetGrossAccount name="dialup.credit">
   <Credit>0.10</Credit>
   <Debit>0</Debit>
   </OffsetGrossAccount>
-       <OffsetDiscountAccount name="dialup.debit">
   <Credit>0</Credit>
   <Debit>0</Debit>
   </OffsetDiscountAccount>
-       <OffsetNetAccount name="dialup.credit">
   <Credit>0.10</Credit>
   <Debit>0</Debit>
   </OffsetNetAccount>
   <OffsetTaxAccount name="-- N/A --"> 
   <Credit>0</Credit> 
   <Debit>0</Debit> 
   </OffsetTaxAccount> 
   </RevenueAmounts> 
   </GeneralLedgerReport>