Skip to content

The Oracle CC&B Data Model: How Customer Care and Billing Is Structured

AvanSaber Research 4 min read

Most Oracle Customer Care and Billing problems that look like configuration problems are actually data model problems. A rate that will not apply, a bill that splits when it should not, a move-in that leaves stranded consumption: trace each one back and it usually ends at an entity that was modelled wrong before anyone touched a rate schedule.

This is the core chain, what each entity is really for, and where implementations tend to go wrong.

Key takeaways

The five entities

Person. The party: an individual, a business, sometimes a government body. A person holds identifying details and can be related to several accounts. Keeping identity separate from billing is what allows one business to hold many accounts without duplicating the party record on each.

Account. What gets billed. An account carries the financial relationship: balance, payment history, credit and collections status, billing cycle. Several people can be related to one account with different roles, which is how joint occupancy and business signatories are represented.

Premise. The physical location, usually an address. Premises are durable in a way accounts are not. Occupants move in and out; the building stays. Modelling the premise separately is what makes a change of occupant a change to the account and the service agreement rather than to the infrastructure record.

Service point. Where a specific commodity is delivered at a premise. This is the entity people underestimate. A single premise can hold an electric service point and a water service point, each metered separately, each with its own agreement. A combination utility that collapsed this into the premise would be unable to bill the two commodities on their own terms.

Service agreement. The contract that ties an account to a service point. It carries the rate schedule, the effective dates, and the billing terms. It is the entity that answers “who is paying, for what delivery, at what rate, over what period.”

How a bill actually resolves

The chain matters because billing walks it rather than reading a single record.

  1. The billing run starts from the account.
  2. It finds the service agreements attached to that account.
  3. Each agreement points at a service point, where consumption has been recorded.
  4. The rate schedule on the agreement is applied to that consumption.
  5. The results assemble into one bill for the account, covering every service.

Which is why a combination utility can put electric and water on a single bill without merging the two services: the separation lives at the service point and the agreement, and the merge happens at the account.

Where implementations go wrong

Premises that are really service points. The most common structural error. Somebody models each metered service as its own premise, and now a single building appears as several addresses. Move-ins become inconsistent, service orders route oddly, and any report grouped by location double-counts.

Accounts used as parties. Where the party record is skipped and everything hangs off the account, a customer with three accounts becomes three customers. Collections treat them separately, service history fragments, and nobody can answer how much this business owes in total.

Service agreements without clean effective dating. A rate change or a move-out that is not dated correctly leaves consumption stranded between agreements. It usually surfaces as an unbillable period that nobody notices until a month-end reconciliation refuses to close.

Migration that preserves the errors. A conversion from a legacy system that maps old records straight across carries every one of these problems into the new platform, and now they are expensive. Data quality assessment belongs before configuration, not next to it.

Coming from SAP IS-U

The concepts map, the names do not. Anyone moving between the two platforms should expect the ideas to transfer and the specifics not to.

Oracle CC&BSAP IS-UWhat it is
PersonBusiness partnerThe party
AccountContract accountThe billing relationship
PremiseConnection objectThe physical location
Service pointPoint of deliveryWhere a commodity is delivered
Service agreementContractThe terms binding payer to delivery

The boundaries differ in detail, so a mapping exercise between the two is a real piece of work rather than a rename. Our SAP CIS overview covers the IS-U side, and the SAP, Oracle, and Cayenta comparison sets the platforms side by side.

The verdict

The CC&B data model is not complicated, but it is precise, and the precision is load-bearing. Five entities, each answering one question: who is the party, who pays, where is it, what is delivered there, and under what terms. Implementations that get those five right spend their configuration budget on rates. Implementations that do not spend it on rework.

If you want a second read on a data model before configuration starts, the AvanSaber team does this work on utility CIS programmes case by case.

Frequently asked questions

What is the core entity chain in the CC&B data model?

Person, account, premise, service point, and service agreement. A person is the party, an account is what gets billed, a premise is the physical location, a service point is where a specific commodity is delivered at that premise, and a service agreement is the contract that links an account to a service point. Billing resolves along that chain rather than against a single customer record.

Why does CC&B separate person from account?

Because the party and the payer are not always the same, and neither is stable over time. A landlord may hold the account for a premise a tenant occupies, a business may have one person of record and many accounts, and an account may change hands while the premise and service point stay put. Keeping them separate means a change of occupant does not disturb the physical infrastructure records.

What is the difference between a premise and a service point?

A premise is the location, typically an address. A service point is where a particular commodity is delivered at that location. One premise can hold several service points, for example electric and water, each with its own metering and its own service agreement. Modelling them separately is what lets a combination utility bill several commodities to one account without duplicating the address.

How does a service agreement relate to billing?

The service agreement is the contract layer. It ties an account to a service point, carries the rate schedule that applies, and defines the billing period. When a bill runs, the system walks from account to its service agreements, reads the consumption recorded at each linked service point, applies the rate on the agreement, and assembles the result into one bill for the account.

Why does the data model matter for an implementation?

Because most CC&B implementation overruns are data problems wearing a configuration costume. If premises and service points are wrong in the source system, every downstream rate, bill, and report inherits that error, and the fix costs more the later it is found. Data model alignment is worth doing before configuration, not alongside it.

Is the CC&B data model similar to SAP IS-U?

The concepts map closely, since both model a utility's meter-to-cash chain, but the names and the boundaries differ. SAP IS-U uses business partner, contract account, connection object, point of delivery, and contract for roughly the same roles. Anyone moving between the two should expect the ideas to transfer and the specifics not to.

Related reading