Search Results next_review_date_compute

Overview

APPS.HZ_CUSTOMER_PROFILE_V2PUB is the public-API package in Oracle E-Business Suite that exposes the customer profile and customer profile amount business entities to external and internal callers. Within the Trading Community Architecture (HZ) product family, it is classified as a PUB API and is registered against the business entity HZ_CUSTOMER_ACCOUNT, with a lifecycle status of active. The package documentation header references the Oracle Trading Community Architecture Technical Implementation Guide (120hztig.pdf), positioning it as the supported programmatic entry point for creating, updating, and retrieving credit, collections, and statement-related profile data held against a customer account.

The central data structure associated with this package is the record type customer_profile_rec_type, which is the exact term used to search for this object. This record type consolidates the profile attributes into a single PL/SQL structure and is the medium through which profile rows are passed between caller code and the API layer.

The declared fields of customer_profile_rec_type span key identifiers (cust_account_profile_id, cust_account_id, profile_class_id, site_use_id), status and control flags (status, credit_checking, credit_hold, override_terms), credit and collections attributes (credit_rating, risk_code, percent_collectable, collector_id, credit_analyst_id), terms and dunning attributes, review and grace-period fields, and the twenty flexible attribute columns (attribute1 through attribute20) together with attribute_category.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

• CREATE_CUSTOMER_PROFILE — Inserts a new customer profile record for a customer account.
• UPDATE_CUSTOMER_PROFILE — Modifies an existing customer profile record.
• GET_CUSTOMER_PROFILE_REC — Retrieves a customer profile into the customer_profile_rec_type structure.
• CREATE_CUST_PROFILE_AMT — Creates a customer profile amount record.
• UPDATE_CUST_PROFILE_AMT — Updates an existing customer profile amount record.
• GET_CUST_PROFILE_AMT_REC — Retrieves a customer profile amount record.
• NEXT_REVIEW_DATE_COMPUTE — Computes the next credit review date for a profile.
• LAST_REVIEW_DATE_DEFAULT — Derives the default last review date used during profile maintenance.

Tables Accessed

The package operates against the following tables through APPS synonyms:

• HZ_CUSTOMER_PROFILES — Primary store for customer profile rows.
• HZ_CUST_ACCOUNTS — Supplies and validates the owning customer account.
• HZ_CUST_PROFILE_AMTS — Stores customer profile amounts maintained by the amount APIs.
• HZ_CUST_PROFILE_CLASSES — Provides profile class definitions referenced by profile_class_id.
• HZ_CUST_PROF_CLASS_AMTS — Provides class-level amount defaults.
• HZ_PARTIES — Supplies party-level context associated with the customer account.

Usage Notes

HZ_CUSTOMER_PROFILE_V2PUB is invoked from Oracle Receivables and TCA-related forms, from concurrent programs that maintain credit and collections profile data, and from custom PL/SQL integrations that require a supported, upgrade-safe interface rather than direct DML against the underlying HZ tables. It is referenced by 41 other packages within the EBS codebase, indicating that it functions as a shared dependency for higher-level credit management, collections, and customer maintenance flows. Callers should pass and receive the customer_profile_rec_type record structure for profile operations, and should rely on the GET/UPDATE pair to read-modify-write profile rows without disturbing unmodified attributes.