Search Results load_party_intf




Overview
Explore in AI Chat

Overview

APPS.POS_BULKLOAD_ENTITIES is a public PL/SQL package that provides the server-side engine for Oracle E-Business Suite bulk data loading in the Procurement and Supplier Lifecycle Management (formerly iSupplier / Supplier Network) product family. It is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the package owner, a design choice typical of batch-oriented utilities that must respect the caller's responsibility and data security context. The package coordinates the staged import of entity records, including supplier, supplier site, party, and user-attribute data, from interface tables into their destination base tables, and it manages the diagnostic infrastructure that supports those long-running loads.

A search for load_party_intf resolves directly to the LOAD_PARTY_INTF procedure, which is the party entity counterpart of the broader supplier bulk-load flow. This indicates the user is investigating how party records are staged and promoted into the TCA (Trading Community Architecture) registry through the bulk-load framework.

Key Procedures and Functions

  • SETUP_BULKLOAD_INTF — prepares the bulk-load environment for a given result-format usage, returning status buffers and an error file handle; the entry point for initializing a load run.
  • LOAD_PARTY_INTF — loads party records into the interface tables, accepting a batch identifier, party origin system and reference, insert/update indicator, party type, and name components for organizations and persons. This is the procedure referenced by the search term.
  • LOAD_USERATTR_INTF — loads user-defined attribute data tied to a result-format usage and data set, scoped by entity name and batch identifier.
  • PROCESS_USER_ATTRS_DATA — processes staged user-attribute rows for a data set, with an option to purge successfully processed lines.
  • BULKLOADENTITIES — the master orchestration procedure that drives entity loading for a batch, capturing user, language, responsibility, and application context for audit and security purposes.
  • OPEN_DEBUG_SESSION / OPEN_DEBUG_SESSION_INTERNAL — initialize debugging/tracing for a run.
  • DEVELOPER_DEBUG — emits developer-level debug messages.
  • CLOSE_DEBUG_SESSION — terminates the debug session.
  • WRITE_CONCLOG — writes messages to the concurrent log.

Tables Accessed

The package references these objects via APPS synonyms: AP_SUPPLIERS, AP_SUPPLIERS_INT, and AP_SUPPLIER_SITES_ALL for supplier and supplier-site loading; HZ_IMP_PARTIES_INT and HZ_PARTY_SITES for party and party-site staging and promotion; POS_SUPP_PROF_EXT_INTF for supplier profile extension data; EGO_BULKLOAD_INTF and EGO_RESULTS_FMT_USAGES for the generic bulk-load framework and result-format configuration; FND_USER for user context; and DBMS_SQL, PLITBLM, and V$PARAMETER for dynamic SQL, PL/SQL table management, and parameter inspection.

Usage Notes

This package is invoked primarily from concurrent programs and administrative concurrent flows associated with supplier and party bulk import, and it may be called from custom code that submits the same loaders. Because it is AUTHID CURRENT_USER, callers must ensure the executing user has appropriate grants on the interface tables. The documented metadata lists one dependent package referencing it. Oracle ETRM classifies the package API as OTHER rather than a public-supported interface, so direct invocation should be treated cautiously; the supported path is generally through the delivered bulk-load concurrent programs driven by SETUP_BULKLOAD_INTF and BULKLOADENTITIES.