Search Results next_credit_review_date

Overview

The HZ_CREDIT_PROFILES_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, delivered under the Receivables (AR) product family. It presents a normalized, denormalized-friendly projection of credit profile records maintained by the Oracle Trading Community Architecture (TCA) and consumed by Credit Management functionality within Receivables. Its principal role is to expose credit profile definitions that apply either at the operating unit level or at the item category level, allowing external reports, concurrent programs, and integration layers to query a single consistent structure rather than navigating conditional logic in the base table.

The view is particularly relevant to searches involving next_credit_review_date, since that column is surfaced unchanged from the base table and supports credit review scheduling, aging analysis, and workflow-driven review reminders used by credit analysts.

Underlying Base Objects

The view is defined exclusively over the base table HZ_CREDIT_PROFILES, accessed through a synonym in the APPS schema. The view text is a UNION ALL of two SELECT statements:

• The first branch selects rows where ITEM_CATEGORY_ID IS NULL, labeling them with a literal PROFILE_TYPE of 'OPERATING_UNIT', exposing CP.ORGANIZATION_ID and a NULL ITEM_CATEGORY_ID.
• The second branch selects rows where ORGANIZATION_ID IS NULL, labeling them with a literal PROFILE_TYPE of 'ITEM_CATEGORY', exposing CP.ITEM_CATEGORY_ID and a NULL ORGANIZATION_ID.

This UNION effectively flattens two mutually exclusive credit profile scopes into a single result set with a discriminator column (PROFILE_TYPE), allowing consumers to filter by scope without writing scope-specific predicates against the base table.

Key Columns

• PROFILE_TYPE — Literal discriminator indicating whether the profile is scoped to an operating unit or an item category.
• CREDIT_PROFILE_ID — Primary identifier of the credit profile record from HZ_CREDIT_PROFILES.
• ORGANIZATION_ID — Operating unit identifier; populated only for operating unit profiles.
• ITEM_CATEGORY_ID — Item category identifier; populated only for item category profiles.
• ENABLE_FLAG — Indicates whether the credit profile is currently enabled.
• EFFECTIVE_DATE_FROM / EFFECTIVE_DATE_TO — Validity window governing when the profile applies.
• CREDIT_CHECKING — Flag controlling credit checking behavior for the profile.
• NEXT_CREDIT_REVIEW_DATE — Scheduled date on which the credit profile is due for review; central to credit review tracking.
• TOLERANCE — Tolerance percentage or amount applied to credit limits.
• CREDIT_HOLD — Indicates whether the profile places orders on credit hold.
• CREDIT_RATING — Credit rating assigned to the profile.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segments for extensible data capture.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID support auditing and concurrent program tracing.

Common Use Cases and Queries

Typical uses include credit review scheduling, profile scope reporting, and integration extracts. Because the view is read-only and stable across 12.1.1 and 12.2.2, it is safe to query directly.

Sample query returning operating unit profiles due for review:

SELECT CREDIT_PROFILE_ID,
       ORGANIZATION_ID,
       NEXT_CREDIT_REVIEW_DATE,
       CREDIT_CHECKING,
       CREDIT_HOLD,
       CREDIT_RATING
  FROM APPS.HZ_CREDIT_PROFILES_V
 WHERE PROFILE_TYPE = 'OPERATING_UNIT'
   AND ENABLE_FLAG = 'Y'
   AND NEXT_CREDIT_REVIEW_DATE IS NOT NULL
   AND NEXT_CREDIT_REVIEW_DATE <= SYSDATE
 ORDER BY NEXT_CREDIT_REVIEW_DATE;

Sample query listing item category profiles with their effective windows:

SELECT CREDIT_PROFILE_ID,
       ITEM_CATEGORY_ID,
       EFFECTIVE_DATE_FROM,
       EFFECTIVE_DATE_TO,
       NEXT_CREDIT_REVIEW_DATE
  FROM APPS.HZ_CREDIT_PROFILES_V
 WHERE PROFILE_TYPE = 'ITEM_CATEGORY'
 ORDER BY EFFECTIVE_DATE_FROM;

These patterns support credit dashboards, aging of overdue reviews, and automated notifications driven by NEXT_CREDIT_REVIEW_DATE.