Search Results pos_profile_pkg




Overview
Explore in AI Chat

Overview

POS_PROFILE_PKG is a PL/SQL package in the APPS schema that supports supplier profile maintenance within Oracle E-Business Suite, specifically for the Oracle Procurement and iProcurement supplier-facing functionality. The package encapsulates business logic for creating and maintaining supplier records and their associated party, site, contact, and payment data. It operates as a low-level utility layer that other supplier profile routines call, rather than as a self-contained user-facing API. In ETRM documentation the object is classified as VALID with an API classification of OTHER, meaning it is not published as an officially supported public interface but is nonetheless a stable component relied upon internally. The package has both a specification and a body and depends on the SYS.STANDARD package. It is referenced by POS_PROFILE_CHANGE_REQUEST_PKG and by itself, confirming its role as a building block for supplier profile change-request processing.

Key Procedures and Functions

Four documented program units are exposed, all centered on supplier and address data handling:

  • BUYER_BOOT_STRAP — Initializes or seeds supplier-related profile data, providing the baseline setup required before subsequent supplier operations can proceed. It is typically the entry point that prepares working data for the buyer or supplier context.
  • GET_VENDOR_DATA — Retrieves supplier (vendor) information for use by callers, consolidating vendor attributes from the underlying supplier tables so that dependent processes can work from a single fetched result set.
  • BUYER_UPDATE_ADDRESS_DETAILS — Updates address information associated with a supplier or buyer-side supplier record, propagating changes to the relevant party site and location structures.
  • REMOVE_ADDRESS — Deletes or deactivates an address associated with a supplier, handling the necessary cleanup of related party, site, and contact point rows.

The parameter signatures for these units are not published in the available metadata; accordingly, only their functional intent is described here.

Tables Accessed

The package reads and writes a broad set of supplier, party, and payment tables through APPS synonyms:

These references confirm that the package coordinates supplier master data across both the Payables supplier model and the TCA model.

Usage Notes

POS_PROFILE_PKG is not intended for direct invocation by end users. It is called by other PL/SQL packages — chiefly POS_PROFILE_CHANGE_REQUEST_PKG — which drive supplier profile change requests. In practice, supplier profile updates initiated through Oracle iSupplier Portal, supplier management forms, or concurrent programs that process profile change requests will ultimately reach this package. Custom code that requires supplier address or vendor data may call these routines where the metadata-documented interface is stable, but because the classification is OTHER rather than a published API, developers should validate signatures against the specific release (12.1.1 or 12.2.2) before relying on them. The dependency on FND_USER indicates that audit or ownership context is captured during execution.