Results for “hz_billing_preferences_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AR.HZ_BILLING_PREFERENCES table is a transactional table within the Oracle E-Business Suite Receivables (AR) schema that stores the invoice format and delivery media preferences requested by a customer account or a specific customer account site. It allows an organization to record, at a granular level, how a particular customer wishes to receive its billing documents. A representative scenario documented by Oracle is that a Latin American subsidiary based in Florida, United States, may request that all invoices be produced in Spanish and delivered to the subsidiary on CD-ROM, even though the parent operation is domestic. In this way the table decouples the physical location of a customer from the language, media, and presentation format applied when billing is generated.

The object is owned by the AR schema and carries the FND design data reference AR.HZ_BILLING_PREFERENCES, with a status of VALID in Oracle EBS 12.1.1 and 12.2.2. Its primary key is BILLING_PREFERENCES_ID. When considered through a data vault modeling lens, the heuristic classification of this object is that of a link, since it primarily associates a customer account (and optionally a site use) with a set of billing presentation attributes rather than acting as a standalone hub or a pure descriptive satellite.

Key Information Stored

The documented physical schema contains twenty columns, of which the following are the most operationally significant:

• BILLING_PREFERENCES_ID — the system-generated surrogate primary key and unique identifier for each billing preference record. This column is also the business-key candidate exposed by the unique index HZ_BILLING_PREFERENCES_U1 on the APPS_TS_TX_IDX tablespace.
• CUST_ACCOUNT_ID — the customer account identifier, a foreign key to HZ_CUST_ACCOUNTS, and the column indexed by the non-unique index HZ_BILLING_PREFERENCES_N1.
• SITE_USE_ID — a foreign key to HZ_CUST_SITE_USES_ALL, allowing preferences to be defined at the site-use level rather than only for the whole account.
• BILL_LANGUAGE — the language in which the bill is printed, such as English or Spanish, with a foreign key to FND_LANGUAGES.
• BILL_TYPE — indicates whether the bill is presented as a detail or summary document.
• BILL_ROUND_NUMBER — describes the rounding method applied to amounts on the bill to a specified limit.
• MEDIA_TYPE — the medium of presentation, for example printed, electronic transmission, or electromagnetic formats such as tape and diskette.
• MEDIA_FORMAT — the specific format or identifier for the media, such as tape, CD, or diskette, on which the bill is copied for distribution.
• NUMBER_OF_COPIES — the number of printed copies or copies of the media to be produced at print time.
• CURRENCY_CODE — the ISO code for the currency in which the billing is expressed.
• Standard WHO and audit columns including CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and WH_UPDATE_DATE.

Common Use Cases and Queries

Because billing preferences drive invoice routing and formatting, the table is frequently queried in reporting and integration scenarios. Typical uses include identifying all customers who require a non-default billing language, listing accounts that receive electronic rather than printed invoices, and reconciling the number of copies requested per site.

A simple lookup by account illustrates the primary join path:

SELECT bp.billing_preferences_id, bp.cust_account_id, bp.site_use_id,
      bp.bill_language, bp.bill_type, bp.media_type,
      bp.media_format, bp.number_of_copies
 FROM ar.hz_billing_preferences bp
 WHERE bp.cust_account_id = :p_cust_account_id;

A reporting query joining to the customer account and language tables demonstrates a common analytical pattern:

SELECT ca.account_number, bp.bill_language, bp.media_type, bp.media_format
 FROM ar.hz_billing_preferences bp, ar.hz_cust_accounts ca
 WHERE bp.cust_account_id = ca.cust_account_id
 AND   bp.bill_language IS NOT NULL;

Because of the unique index HZ_BILLING_PREFERENCES_U1, queries filtering on BILLING_PREFERENCES_ID return at most one row, making the column the preferred access path for point lookups, while queries filtering on CUST_ACCOUNT_ID benefit from the non-unique HZ_BILLING_PREFERENCES_N1 index.

Related Objects

The following objects are the most significant in terms of reference and dependency:

• HZ_CUST_ACCOUNTS — referenced by CUST_ACCOUNT_ID; the parent customer account entity.
• HZ_CUST_SITE_USES_ALL — referenced by SITE_USE_ID; defines the site-use context for the preference.
• FND_LANGUAGES — referenced by BILL_LANGUAGE, providing valid language values.
• HZ_BILLING_PREFERENCES_U1 — the unique index supporting the primary key and business-key access.
• HZ_BILLING_PREFERENCES_N1 — the non-unique index on CUST_ACCOUNT_ID supporting account-level queries.
• AR.HZ_BILLING_PREFERENCES — the FND design data registration enabling the table within the Application Object Library.
• Related customer-model tables and public APIs that consume billing preferences when generating invoices and statements.

Together these objects support the end-to-end linkage from customer account to billing presentation behavior.