Search Results update_ib

Overview

XDP_INSTALL_BASE is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its documented purpose is to provide an API that integrates Service Fulfillment Manager (SFM) with the Install Base (IB). The package was originally delivered during the 11.5 development cycle, as indicated by the header revision "120.1" dated June 8, 2005, and remains present in the 12.1.1 and 12.2.2 code lines. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute against the invoking user's schema and privileges rather than the definer's, and it is classified as "Private," indicating it is not intended as a public, customer-facing integration API.

From a business standpoint, XDP_INSTALL_BASE supports the fulfillment lifecycle: when an order line representing a serviceable product or service reaches the point where it must be registered in the Install Base, the package performs the work necessary to create or update the corresponding item instance records. This bridges the fulfillment data captured by SFM in the XDP tables with the customer asset data held in the CSI (Customer Service/Installed Base) tables.

Key Procedures and Functions

The package exposes a single documented procedure, UPDATE_IB. The ETRM metadata documents the following parameters:

• p_order_id (NUMBER, IN, required) — the identifier of the order whose line is to be processed.
• p_line_id (NUMBER, IN, required) — the identifier of the specific line within that order.
• p_error_code (NUMBER, IN OUT NOCOPY) — the numeric code of any error encountered during processing.
• p_error_description (VARCHAR2, OUT NOCOPY) — the textual description associated with an encountered error.

UPDATE_IB drives the creation or synchronization of an Install Base record for the given order line. The NOCOPY hints on the error parameters indicate that values are passed by reference for efficiency, and callers must inspect these outputs after the call to determine whether the operation succeeded. No other procedures or functions are documented for this package.

Tables Accessed

Via APPS synonyms, the package reads and writes the following documented tables:

• CSI_ITEM_INSTANCES — the core Install Base instance table; INSERT and UPDATE operations register or modify the customer asset created from the order line.
• CSI_IEA_VALUES — stores Install Base extended attribute values associated with instances.
• CSI_T_TXN_LINE_DETAILS — transactional line detail records linking Install Base transactions to fulfillment lines.
• MTL_SYSTEM_ITEMS_B — the item master, used to validate the item and derive item attributes for the instance.
• XDP_FULFILL_WORKLIST, XDP_WORKLIST_DETAILS, XDP_ORDER_LINE_ITEMS, XDP_LINE_RELATIONSHIPS — SFM fulfillment work-list and order line structures that provide the source data driving the update.

PLITBLM is also referenced, consistent with the standard PL/SQL table type usage within the Oracle Forms-based XDP stack.

Usage Notes

As a private package, XDP_INSTALL_BASE is not documented for direct customer invocation. It is referenced by three other packages, which are the actual entry points that trigger the Install Base update, typically during fulfillment processing or order-line completion. Customers and consultants investigating the "xdp_install_base" object are usually tracing how an SFM order line generates an Install Base instance, or diagnosing why an instance was not created. When the package raises an error, the resulting p_error_code and p_error_description are surfaced through the calling package and recorded in the fulfillment work-list or concurrent program log. Because the package operates under the caller's privileges (AUTHID CURRENT_USER), any custom code invoking it must ensure the caller has the necessary CSI and XDP object privileges.