Search Results hz_billing_preferences




Overview
Explore in AI Chat

Overview

HZ_BILLING_PREFERENCES is a Receivables (AR) module table that stores customer-level invoicing format preferences. It is owned by the AR schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2. The table defines how invoices and billing documents are rendered, transmitted, and processed for a given customer account or customer site use, capturing attributes such as billing language, media type, media format, rounding rules, and copy counts.

Under the heuristic Data Vault classification derived from the foreign key structure, HZ_BILLING_PREFERENCES maps most naturally to a link entity. It associates a customer account (via CUST_ACCOUNT_ID) with a specific site use (via SITE_USE_ID) and carries descriptive billing preference attributes, positioning it as a relationship table between the trading party (HZ_CUST_ACCOUNTS) and the location/usage context (HZ_CUST_SITE_USES_ALL). This modeling suggestion reflects how billing preferences exist only in the context of an established customer-to-site relationship.

Key Information Stored

The table contains 20 documented columns. The most significant are the following:

  • BILLING_PREFERENCES_ID — Surrogate primary key, enforced by the HZ_BILLING_PREFERENCES_PK constraint and reinforced by the unique index HZ_BILLING_PREFERENCES_U1. This is the definitive row identifier.
  • CUST_ACCOUNT_ID — Foreign key to HZ_CUST_ACCOUNTS; identifies the customer account the preference applies to.
  • SITE_USE_ID — Foreign key to HZ_CUST_SITE_USES_ALL; identifies the specific site use context for the preference.
  • BILL_TYPE — Classifies the billing type associated with the preference.
  • BILL_LANGUAGE — Language used when generating the invoice or billing document.
  • BILL_ROUND_NUMBER — Rounding rule applied to billing amounts.
  • MEDIA_TYPE — The delivery medium (for example, print, EDI, or e-mail) for the billing output.
  • MEDIA_FORMAT — The formatting convention applied to the media output.
  • NUMBER_OF_COPIES — Number of copies to produce for the billing document.
  • CURRENCY_CODE — Currency in which the billing preference amounts are expressed.
  • WH_UPDATE_DATE — Warehouse update timestamp used to support incremental data extraction and reporting refresh cycles.

Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) are also present. The business-key candidate is BILLING_PREFERENCES_ID; no alternate composite business key is documented.

Common Use Cases and Queries

Billing preferences are typically queried when generating customer invoices to determine language, currency, rounding, media type, and copy count. A common reporting pattern joins billing preferences to the customer account and site use to produce a consolidated billing profile:

SELECT bp.billing_preferences_id, ca.account_number, csu.site_use_code, bp.bill_language, bp.media_type, bp.media_format, bp.number_of_copies, bp.currency_code FROM hz_billing_preferences bp, hz_cust_accounts ca, hz_cust_site_uses_all csu WHERE bp.cust_account_id = ca.cust_account_id AND bp.site_use_id = csu.site_use_id;

Typical scenarios include auditing which customers receive electronic versus printed invoices, identifying accounts with non-default currency or rounding rules, and reconciling invoice output volume using NUMBER_OF_COPIES. Incremental extract jobs frequently filter on WH_UPDATE_DATE to pull only newly changed preference rows.

Related Objects

The following objects are most significant in relation to HZ_BILLING_PREFERENCES:

  • HZ_CUST_ACCOUNTS — joined via CUST_ACCOUNT_ID; provides the customer account master record.
  • HZ_CUST_SITE_USES_ALL — joined via SITE_USE_ID; provides the site use context for the preference.
  • HZ_CUST_ACCT_SITES_ALL — related through the site use hierarchy; supplies address and site information used on billing documents.
  • AR_INVOICE_API_PUB — the public API that reads billing preferences when creating invoices.
  • HZ_CUSTOMER_PROFILE — the customer profile view that surfaces billing-related attributes.
  • RA_CUSTOMER_TRX_ALL — the invoice transaction table that consumes billing preference output at invoicing time.