Search Results ipa_object_version_number




Overview
Explore in AI Chat

Overview

CSI_CP_FORM_ADDRESS_V is an Oracle E-Business Suite internal view owned by the APPS schema, registered under FND Design Data as CSI.CSI_CP_FORM_ADDRESS_V, and marked VALID. It exists to support the Customer Products (CSI) forms and concurrent programs that must present customer product records alongside the associated party and address information used in the Install Base and TCA (Trading Community Architecture) models. The view consolidates ship-to and install-to party and location details with the surrounding customer product instance identifiers in a single denormalized row, which is the shape required by form blocks that display address context next to an installed item. Oracle documents this object as Internal Use Only and explicitly warns that access to applications data through it is unsupported except from standard Oracle Applications programs. The column IP_OBJECT_VERSION_NUMBER, the term most frequently searched against this view, belongs to the installation party record and is the optimistic-locking token that forms use to detect concurrent updates to the IP party row backing a given customer product instance.

Underlying Base Objects

The view is defined over the following documented base objects, referenced through APPS synonyms: CSI_INSTALL_PARAMETERS, CSI_IPA_RELATION_TYPES, CSI_IP_ACCOUNTS, CSI_ITEM_INSTANCES, CSI_I_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTIES, and HZ_PARTY_SITES. CSI_ITEM_INSTANCES supplies the installed instance (customer product) row, including CUSTOMER_PRODUCT_ID and CP_OBJECT_VERSION_NUMBER. CSI_I_PARTIES and CSI_IPA_RELATION_TYPES link instances to parties and role types, and CSI_IP_ACCOUNTS supplies account context. The HZ tables—HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL—are the TCA sources for party names, party types, person names, site names, and the address components that populate the SHIP_TO_* and INSTALL_TO_* columns. CSI_INSTALL_PARAMETERS contributes installation-level attributes. The view therefore joins CSI instance data to TCA party and location data, and the *OBJECT_VERSION_NUMBER columns are carried forward from the respective CSI source rows rather than derived.

Key Columns

The leading identifiers are ROW_ID, CUSTOMER_PRODUCT_ID, and three version tokens: CP_OBJECT_VERSION_NUMBER (customer product instance), IP_OBJECT_VERSION_NUMBER (installation party, CSI_I_PARTIES), and IPA_OBJECT_VERSION_NUMBER (installation party account). INSTANCE_PARTY_ID, IP_ACCOUNT_ID, SHIP_TO_SITE_USE_ID, and BILL_TO_SITE_USE_ID anchor the party and site-use relationships. The SHIP_TO_* group exposes SHIP_TO_PARTY_SITE_NAME, SHIP_TO_PARTY_ID, SHIP_TO_PARTY_NAME, SHIP_TO_PARTY_TYPE, SHIP_TO_PARTY_LAST_NAME, SHIP_TO_PARTY_FIRST_NAME, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION_DESC, SHIP_TO_ADDRESS1 through ADDRESS4, SHIP_TO_MAILSTOP, SHIP_TO_CITY, SHIP_TO_POSTAL_CODE, SHIP_TO_STATE, SHIP_TO_PROVINCE, SHIP_TO_COUNTY, and SHIP_TO_COUNTRY. The INSTALL_TO_* group mirrors this set with INSTALL_TO_PARTY_SITE_NAME, INSTALL_TO_PARTY_ID, INSTALL_TO_PARTY_NAME, INSTALL_TO_PARTY_TYPE, INSTALL_TO_PARTY_LAST_NAME, INSTALL_TO_PARTY_FIRST_NAME, INSTALL_TO_LOCATION_ID, INSTALL_TO_LOCATION_DESC, INSTALL_TO_ADDRESS1 through ADDRESS4, INSTALL_TO_MAILSTOP, INSTALL_TO_CITY, INSTALL_TO_POSTAL_CODE, INSTALL_TO_STATE, INSTALL_TO_PROVINCE, and INSTALL_TO_COUNTY. IP_OBJECT_VERSION_NUMBER is the value compared on update to confirm the installation party row has not changed since the form queried it.

Common Use Cases and Queries

Typical use is diagnostic or form-support reporting on installed items and their address context, particularly when validating who owns an installation party and how the ship-to and install-to sites resolve in TCA. Because the object is internal, production integrations should treat results as read-only and expect no support commitment. A representative query retrieving the installation party version token for a customer product is:

  • SELECT customer_product_id, ip_object_version_number, instance_party_id, ip_account_id
  • FROM apps.csi_cp_form_address_v
  • WHERE customer_product_id = :p_customer_product_id;

To review ship-to and install-to address resolution for a set of instances:

  • SELECT customer_product_id, ship_to_party_name, ship_to_city, ship_to_country,
  • install_to_party_name, install_to_address1, install_to_city, install_to_postal_code
  • FROM apps.csi_cp_form_address_v
  • WHERE install_to_party_id = :p_party_id;

Searches for ip_object_version_number commonly arise during debugging of stale-form or concurrent-update conditions: comparing the version token returned by the view against the current value in CSI_I_PARTIES determines whether the displayed installation party information is still current. All such queries should be issued with awareness that the view is Oracle Internal Use Only and intended to be consumed by standard Applications code.