Search Results hz_cust_profiles




Overview
Explore in AI Chat

Overview

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB is a public TCA (Trading Community Architecture) API package in Oracle E-Business Suite 12.1.1 and 12.2.2 that manages the site layer of the customer model. It provides the programmatic interface for creating, updating, and querying customer account sites (HZ_CUST_ACCT_SITES and its _ALL counterpart) and customer site uses (HZ_CUST_SITE_USES and HZ_CUST_SITE_USES_ALL). A site represents a specific location belonging to a customer account, while a site use identifies the business purpose assigned to that location — for example ship-to, bill-to, or statement-to. The package therefore underpins the operational address and purpose data used by Order Management, Receivables, Advanced Pricing, and Shipping.

In addition to the core entity maintenance calls, the package orchestrates dependent processing. The private routine do_create_cust_site_use accepts a record of type HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE, allowing a customer profile to be created alongside the site use. This integration is the reason the package appears in searches related to HZ_CUST_PROFILES and HZ_CUST_PROFILE_AMTS, the tables that hold profile and profile amount detail.

Key Procedures and Functions

  • CREATE_CUST_ACCT_SITE — Creates a new customer account site record for a given customer account, establishing the location and account-site association.
  • UPDATE_CUST_ACCT_SITE — Modifies an existing customer account site and returns an updated object version number for optimistic locking control.
  • GET_CUST_ACCT_SITE_REC — Retrieves the attributes of a customer account site into the API's record structure for inquiry or subsequent modification.
  • CREATE_CUST_SITE_USE — Creates a site use for an existing account site, assigning a business purpose; optionally creates the associated customer profile and profile amount data through interaction with HZ_CUSTOMER_PROFILE_V2PUB.
  • UPDATE_CUST_SITE_USE — Updates an existing site use record and returns a new object version number.
  • GET_CUST_SITE_USE_REC — Fetches current site use attributes for a specified record.

Internally, private procedures such as do_create_cust_acct_site, do_create_cust_site_use, denormalize_site_use_flag, do_unset_prim_cust_site_use, and check_obsolete_columns enforce denormalization, primary-use exclusivity, and validation rules. A standard return-status convention (FND_API.G_RET_STS_SUCCESS and related values) is used to signal outcome, and a debug counter supports diagnostic tracing.

Tables Accessed

  • HZ_CUST_ACCOUNTS — Validates the parent customer account that owns the site.
  • HZ_CUST_ACCT_SITES / HZ_CUST_ACCT_SITES_ALL — Stores the account-site header records that are created and updated.
  • HZ_CUST_SITE_USES / HZ_CUST_SITE_USES_ALL — Stores site use rows (ship-to, bill-to, etc.) maintained by the create and update site-use calls.
  • HZ_CUSTOMER_PROFILES / HZ_CUST_PROFILE_AMTS — Hold customer profile and profile amount data written when profile creation is requested during site-use creation.
  • HZ_LOCATIONS — Supplies the address details referenced by the site.
  • HZ_PARTY_SITES / HZ_PARTY_SITE_USES — Link the party-level site and its uses to the customer account site layer.
  • FND_NEW_MESSAGES — Supports message lookup for error and validation reporting.

Usage Notes

The package is a server-side API and is not intended for direct table manipulation. It is commonly invoked from Oracle Forms (customer and site maintenance screens), from concurrent programs that bulk-load or migrate customer site data, and from custom PL/SQL integrations such as order import or interface programs that must register delivery or billing locations. Because 26 other packages reference it, the API acts as a shared building block across Receivables, Order Management, and TCA-adjacent modules. Callers must supply the API record structures, check x_return_status after every call, and propagate object version numbers on updates to avoid concurrent-update conflicts. Profile-related processing requires the companion package HZ_CUSTOMER_PROFILE_V2PUB, whose record type is passed into the creation routine.