Search Results create_cust_acct_site

Overview

IBE_CUSTOMER_ACCT_PVT is a private PL/SQL API package in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the APPS schema and classified as a PVT (private) API within Oracle iStore (IBE). Its primary business function is to manage customer account and account site data for the iStore application, particularly in the context of self-service registration, customer account creation, and the association of customers to sites and site uses.

The package encapsulates the creation and retrieval of customer accounts, account sites, site uses, party sites, and customer account roles. It is designed as an internal, private API — the "PVT" suffix indicates that it is intended for internal use by other iStore packages rather than as a public, directly invokable interface. The header comment references an intermittent Ship-To error during RMA creation (Bug 14763493) and a validation question regarding HZ_CUST_SITE_USES.STATUS='I' (Bug 4922991), illustrating that this package handles edge cases in site use validation and party site selection.

Key Procedures and Functions

The package body documents eight procedures/functions:

• GETPARTYSITEID — Retrieves the party site identifier for a given party and site use type. It uses an internal cursor (C_address) that queries HZ_PARTY_SITES_V and HR_ORGANIZATION_INFORMATION, ordering results by site use type match and primary_per_type flag, filtering on status 'A' and active end dates.
• CREATE_PARTY_SITE_USE — Creates a party site use record, associating a party site with a specific site use type.
• CREATE_CUST_ACCOUNT_ROLE — Creates a customer account role entry, linking a party to a customer account with a defined role.
• CREATE_CUST_ACCT_SITE — Creates a customer account site, the core operation for associating a customer account with a physical site.
• CREATE_CUST_ACCT_SITE_USE — Creates a customer account site use, defining how a customer account site is used (e.g., ship-to, bill-to).
• GET_CUST_ACCOUNT_SITE_USE — Retrieves existing customer account site use records.
• GET_CUST_ACCT_ROLE — Retrieves customer account role records.
• GETCUSTOMERACCTDATA — Retrieves customer account data, likely aggregating account, site, and role information for a given customer.

Tables Accessed

The package reads and writes the following tables (via APPS synonyms):

• HZ_CUST_ACCOUNTS — Core customer account records.
• HZ_CUST_ACCT_SITES / HZ_CUST_ACCT_SITES_ALL — Customer account site associations (org-specific and all-org views).
• HZ_CUST_SITE_USES / HZ_CUST_SITE_USES_ALL — Site use definitions for customer account sites.
• HZ_PARTIES — Party master records.
• HZ_PARTY_SITES — Party site associations.
• HZ_PARTY_SITE_USES — Party site use definitions.
• HZ_CUST_ACCOUNT_ROLES — Customer account role assignments.
• HZ_CONTACT_POINTS — Contact point (phone, email, etc.) records.
• HZ_LOCATIONS — Address/location data.
• HZ_RELATIONSHIPS — Party relationships.
• HZ_ROLE_RESPONSIBILITY — Role responsibility definitions.
• HR_ORGANIZATION_INFORMATION — Organization information, used in GETPARTYSITEID to match country context.

Usage Notes

IBE_CUSTOMER_ACCT_PVT is a private API invoked internally by other iStore packages — the metadata indicates it is referenced by one other package. It is typically called during self-service customer registration, account creation workflows, and RMA processing where Ship-To site resolution is required. Developers extending iStore functionality may call these procedures from custom PL/SQL, but should be aware that the package is not a public API and its interface may change between releases. The GETPARTYSITEID logic in particular reflects historical bug fixes and should be treated as a reference implementation for party site selection rather than a generalized utility.