Application Guide for Oracle Self-Service E-Billing (Business Edition) > Analytic Reports >

Reporting on the Billing Hierarchy

The Oracle Self-Service E-Billing has three levels with the following node types:

• A single company node
• One-to-many billing accounts
• One-to-many service agreements for a single billing account

Figure 1 shows the relationships in a billing reporting hierarchy.

Figure 1. Relationships in a Billing Reporting Hierarchy

Administrator Privileges

Administrators can only be associated with the company node to which they have full access control.

Administrators can assign managers to billing accounts and service agreements. If a manager is assigned to both an account and service agreement within the same node, the manager is represented only at the billing account; this is referred to as being promoted.

Administrators can assign subscribers to service agreements at either of the following locations:

• The Company Setting page. If an administrator assigns a user to either a billing account or service agreement on the Company Setting page, it grants the user the privilege to access that information on the Company Settings page and within the billing hierarchy.
• A Hierarchy page. If an administrator adds a user to a billing account or a service agreement using the hierarchy functionality, this grants the privilege to view this information here only (and not on the Company Settings page).

Administrators can choose any location within the hierarchy to perform analytic reporting; this location is referred to as the hierarchy report context. Using the hierarchy example shown in Figure 1, choosing reports would yield the following report content:

• If an administrator chooses the default company node from that hierarchy report context, the selected report would include information from the following accounts:
  • Account A, service agreements 1-4
  • Account B, service agreements 5-7

    Only administrators can view these reports in shared mode.

• If an administrator chooses billing account node A from that hierarchy report context, the selected report would include information from account A, service agreements 1-4. Only the administrator and manager 1 would be able to view these reports in shared mode.
• If an administrator chooses service agreement S.1 from that hierarchy report context, the selected report would include information from service agreement S.1. The administrator, manager 1, and subscriber S.1 would be able to view these reports in shared mode.

Manager Privileges

You can associate managers with billing accounts only. A manager can access hierarchy billing information from that point only.

Managers can assign subscribers to service agreements that have been previously enrolled by an administrator at the following pages:

• The Company Setting page. If an administrator assigns a user to a service agreement on the Company Setting page, it grants the user the privilege to access that information on the Company Settings page and within the billing hierarchy.
• A Hierarchy page. If an administrator adds a user to a service agreement using the hierarchy functionality, this grants the privilege to view this information here only (and not on the Company Settings page).

Managers can also select a service agreement for analytic reporting. Using the hierarchy example shown in Figure 1, choosing reports would yield the following report content:

• If a manager chooses the billing account node A from that hierarchy report context, the selected report would include information from account A, service agreements 1-4. The administrator and manager 1 can view these reports in shared mode.
• If a manager chooses service agreement S1 from that hierarchy report context, the report would include information from service agreement 1. The administrator, manager 1, and subscriber S.1 can view these reports in shared mode.

Subscriber Privileges

Subscribers can only be associated with a service agreement, and their access control is from that point only.

Subscribers are assigned to a service agreement by either a manager or administrator, and they must have been previously enrolled by an administrator. A limited number of analytic billing report types are available to subscribers.