7 Content Manager Reports

This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support Content Manager, an optional component you use to bill customers for purchased content. See "Understanding Content Manager" in BRM Content Manager.

Important:

Content Manager is an optional component, not part of base BRM.

For general information on how to run reports, see "Running BRM Reports".

Billing Provider Report

Note:

You must upload the BillingProvider.source file that is in the StoredProcedures folder to the database after the Content Manager reports are installed. For more information about loading stored procedures, see "Loading Stored Procedures".

The Billing Provider report (BillingProvider.rtf) shows customer content usage by category, charges incurred for content usage, and amount to remit to content providers for content purchased by their customers.

Caution:

Do not run this report in a multischema environment. If you do, it might be inaccurate. For more information, see "Creating Content Manager Reports" in BRM Content Manager.

When the Account Details parameter is set to NO, the BillingProvider report shows data only for states or countries, but not for individual accounts.

No charts are available for this report.

For each content provider, the report shows the following information:

  • Content Category: Any type of information distributed through the Internet or other electronic media.

  • Quantity: Depending on the type of content, this could be the number of sessions or units of service.

  • Charged Amount: Charges incurred by customers for purchased content.

  • Remittance Info: The amount you need to remit to the content provider for content purchased by their customers.

The information in this report is grouped by content provider.

You can find the SQL query for this report in the following file:

Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Content_Manager_Reports\StoredProcedures\BillingProvider.source

BillingProvider Parameters

You can change the following parameters to modify the output of the BillingProvider report:

  • Content Provider

  • State Details

  • Account Details

  • Account Number

  • Country

  • State

  • Start Date

  • End Date

If your BRM system does not contain state data, see "When to Modify Formulas for New Values".

For information on parameters not described in Table 7-1, see "Understanding the Standard Parameters".

Table 7-1 BillingProvider Parameters

Parameter Description Valid Values Default Value

Content Provider

The supplier of a session or service.

Select ALL, or enter the name of any valid content provider. To check the spelling of a content provider name, see the CONTPROVIDER field in the EVENT_ACT_CONTENT_T table.

ALL

Content Provider Report

Note:

You must upload the ContentProvider.source file that is in the StoredProcedures folder to the database after the Content Manager reports are installed. For more information about loading stored procedures, see "Loading Stored Procedures".

The Content Provider report (ContentProvider.rtf) shows content usage by category and the amount to remit to the content provider. This report is a statement for your content providers that shows purchased content and amount to remit.

Caution:

Do not run this report in a multischema environment. If you do, it might be inaccurate. For more information, see "Creating Content Manager Reports" in BRM Content Manager.

When the Session Details parameter is set to NO, the ContentProvider report shows only the total quantity of the content category.

No charts are available for this report.

When you generate the ContentProvider report, the first section of the report always shows the total amount to remit to all content providers, whether you select ALL or enter the name of a content provider.

The second section lists details about each content provider. Each provider's information starts on a new page. You can use the pages of this section as statements to send to your content providers.

For each content provider, the report shows the following information:

  • Content Category: Any type of information distributed through the Internet or other electronic media.

  • Quantity: Depending on the type of content, this could be the number of sessions or units of service.

  • Remittance Info: The amount you need to remit to the content provider for the content purchased by their customers.

You can find the SQL query for this report in the following file:

Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Content_Manager_Reports\StoredProcedures\ContentProvider.source

ContentProvider Parameters

You can change the following parameters to modify the output of the ContentProvider report:

  • Content Provider

  • Session Details

  • Start Date

  • End Date

If your BRM system does not contain state data, see "When to Modify Formulas for New Values".

For information on parameters not described in Table 7-2, see "Understanding the Standard Parameters".

Table 7-2 ContentProvider Parameters

Parameter Description Valid Values Default Value

Content Provider

The supplier of a session or service.

Select ALL, or enter the name of any valid content provider. To check the spelling of a content provider name, see the CONTPROVIDER field in the EVENT_ACT_CONTENT_T table.

ALL

Session Details

The session date, session time, user ID, and quantity of each session. Select YES to display this information.

YES or NO

NO