Results for “icx_panel_relation_type_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view ICX_PANEL_RELATION_TYPE_V is an Oracle E-Business Suite database object belonging to the ICX product family, which covers Oracle iProcurement and related self-service procurement functionality. In the documented ETRM metadata for Release 12.2.2, the view carries the description "Obsolete" and is explicitly flagged as "Not implemented in this database." This designation means that in a standard, fully patched 12.1.1 or 12.2.2 installation the object does not exist as a callable runtime view, and any application code, concurrent program, or personalization that references it will fail unless the object was manually created or carried forward from an earlier release during an upgrade.
Historically, the view served as a lightweight aggregation helper that summarized active customer relationships. Its role was to provide a per-customer count of reciprocal relationships, supporting iProcurement and customer-facing logic that needed to determine whether a trading partner had an authorized two-way relationship before exposing catalog or ordering functionality. The column name appearing in the user's search, CUSTOMER_RECIPROCAL_FLAG, is the key filter within its defining query and is the reason the view remains of interest to developers investigating relationship validation logic.
Underlying Base Objects
The view is defined over a single base table: RA_CUSTOMER_RELATIONSHIPS, a core Oracle Receivables table that stores relationship records between customers. Although the ETRM metadata lists no formally documented base objects, the embedded view text makes the dependency unambiguous. The defining statement is:
SELECT CUSTOMER_ID, COUNT(*) FROM RA_CUSTOMER_RELATIONSHIPS WHERE STATUS = 'A' AND CUSTOMER_RECIPROCAL_FLAG = 'Y' GROUP BY CUSTOMER_ID
No joins, subqueries, or database links are involved. Because the object is obsolete and not implemented, no view synonym, grant structure, or dependency chain is maintained in current releases. Administrators should treat any dependency on this view as a customization risk and redirect it toward the base table.
Key Columns
The view exposes two columns, derived entirely from RA_CUSTOMER_RELATIONSHIPS:
- CUSTOMER_ID — The Receivables customer identifier. This is the grouping key; one row is returned per distinct customer holding qualifying relationships.
- TOT_NUM_RECIPROCAL_REL_SHIPS — The aggregate count of relationship rows for that customer where
STATUS = 'A'(active) andCUSTOMER_RECIPROCAL_FLAG = 'Y'(reciprocal). This value represents the number of active reciprocal relationships in which the customer participates.
The filter on CUSTOMER_RECIPROCAL_FLAG is central: it isolates relationships where reciprocity has been affirmatively established, as opposed to one-directional associations.
Common Use Cases and Queries
The view was intended for simple qualification checks, such as determining whether a customer had at least one active reciprocal relationship. A representative query follows:
SELECT customer_id, tot_num_reciprocal_rel_ships FROM icx_panel_relation_type_v WHERE tot_num_reciprocal_rel_ships > 0;SELECT c.customer_name, r.tot_num_reciprocal_rel_ships FROM icx_panel_relation_type_v r, ra_customers c WHERE r.customer_id = c.customer_id;
Because the view is obsolete and absent from supported 12.1.1 and 12.2.2 instances, the equivalent query should be issued directly against RA_CUSTOMER_RELATIONSHIPS:
SELECT customer_id, COUNT(*) FROM ra_customer_relationships WHERE status = 'A' AND customer_reciprocal_flag = 'Y' GROUP BY customer_id;
Any legacy iProcurement report, OAF page, or integration interface still referencing ICX_PANEL_RELATION_TYPE_V should be remediated to query the base table, ensuring continued operation across supported releases and avoiding failures on environments where the obsolete object is not deployed.
-
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2