Search Results customer_products

Overview

CS_INSTALLEDBASE_PUB is the public PL/SQL API for Oracle E-Business Suite's Installed Base (Customer Products) functionality, owned by the APPS schema. It provides a programmatic, transaction-safe interface for creating and maintaining records in the customer products (installed base) repository, which tracks the products and services a customer has deployed, including their configurations, revisions, contacts, and associated pricing attributes. In Oracle EBS 12.1.1 and 12.2.2, Installed Base serves as the foundation for service contracts, field service, depot repair, and tele-service operations; this package exposes the procedures required to register, update, and query those records without direct DML against the underlying tables.

The package is classified as a Public (PUB) API, signalling that it is supported for invocation by external and custom code. The header, cspibs.pls 120.1, defines the DFF_Rec_Type, OrderInfo_Rec_Type, and PRICE_ATT_Rec_Type records, which support descriptive flexfields, order-line linkage, and pricing attributes respectively.

Key Procedures and Functions

The documented procedures cover the full lifecycle of an installed base product instance:

• CREATE_BASE_PRODUCT — creates a new customer product record, the primary entry point for registering a deployed item.
• RECORD_SHIPMENT_INFO — captures shipment details associated with a product instance.
• REPLACE_PRODUCT — substitutes one product instance for another while preserving installed base history.
• UPDATE_PRODUCT — modifies attributes of an existing instance.
• CREATE_REVISION / UPDATE_REVISION — manage revision-level information for a product instance.
• SPECIFY_CONTACT / UPDATE_CONTACT / DELETE_CONTACT — maintain contact assignments linked to an instance.
• SPLIT_PRODUCT — divides a product instance into multiple instances.
• CREATE_PRODUCT_PARAMETERS / UPDATE_PRODUCT_PARAMETERS / DELETE_PRODUCT_PARAMETERS — maintain the attribute/value parameters that describe configuration details.

Three read-only functions support retrieval and integration:

• GET_CP_ID — returns the unique identifier of a customer product.
• GET_REFERENCE_NUMBER — returns the instance's reference number for external referencing.
• GET_CONFIGURATION / GET_PRODUCTINFO — return configuration and product details for an instance.

Tables Accessed

No explicit table list is provided in the ETRM metadata; the package operates through APPS synonyms against the CS (Customer Service/Installed Base) schema's base tables — principally CS_INSTALLED_BASE and its related revision, contact, and parameter tables. All access is mediated by the API to ensure validation, concurrency handling, and integrity of installed base records.

Usage Notes

CS_INSTALLEDBASE_PUB is invoked by other Oracle EBS modules and by custom extensions. The metadata notes it is referenced by six other packages, confirming its role as a shared service-layer API. Typical callers include service contract and order management flows that register installed base records during order fulfilment. Custom code can call the procedures directly to bulk-register products or synchronise external asset data; the read functions are commonly used to resolve a customer product identifier from a reference number or to retrieve configuration detail. Because this is a PUB API, it should be preferred over direct DML on the CS tables. Callers should populate the DFF_Rec_Type and PRICE_ATT_Rec_Type records where descriptive flexfields or pricing attributes apply.