Search Results pos_create_organization

Overview

APPS.POS_PARTY_MANAGEMENT_PKG is a PL/SQL package within the Oracle E-Business Suite Advanced Procurement / Sourcing family that provides a programmatic interface for creating and classifying trading community entities—organizations and users—directly through the TCA (Trading Community Architecture) model. Its primary responsibility is to bridge the Sourcing and iProcurement modules with the underlying HZ_PARTIES registry, allowing callers to register new organizational parties, assign classification codes, and bootstrap user records without directly inserting into the TCA tables.

The package header (POSPMNGS.pls, version 120.4, dated 2005) indicates it originated in the 11.5.10 code line and was retained into Release 12. In Release 12 the package comments explicitly warn that pos_create_user is no longer intended for supplier user creation and should instead be used to bootstrap enterprise users for Sourcing. This reflects the impact of the R12 TCA Supplier project, which realigned supplier and party data responsibilities.

Key Procedures and Functions

• POS_CREATE_ORGANIZATION — Creates an organization party in the TCA registry. Accepts an organization name and optional attributes such as DUNS number, corporate headquarters flag, and SIC code. Returns the new party ID, party number, a profile ID, an exception message, and a status code. This is the procedure most commonly referenced by callers searching for "pos_create_organization".
• CLASSIFY_PARTY (two overloads) — Assigns a classification code (category and code) to an existing party, optionally marking it as primary. One overload additionally returns the generated code assignment ID.
• POS_CREATE_USER — Creates an FND_USER record linked to a party. Documented in Release 12 for bootstrapping enterprise users for Sourcing rather than supplier users.
• CHECK_FOR_VENDOR_USER — Determines whether a given username corresponds to a vendor (supplier) user.
• CHECK_FOR_ENTERPRISE_USER — Determines whether a username corresponds to an enterprise user.
• GET_EMP_OR_CTGT_WRKR_PTY_ID — Returns the party ID associated with an employee or contingent worker, given a user ID.
• GET_JOB_TITLE_FOR_USER — Resolves the job title for a user; the source comments note that the implementation is 11.5.10-centric and may change under R12.
• IS_USER_EMPLOYEE_CONT_WORKER — Classifies whether a user is an employee or a contingent worker.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• HZ_PARTIES — the master TCA party registry, where organizations and persons are created and queried.
• HZ_CODE_ASSIGNMENTS — stores classification code assignments produced by classify_party.
• HZ_CONTACT_POINTS, HZ_RELATIONSHIPS — supporting contact and relationship data for created parties.
• FND_USER, FND_PROFILE_OPTION_VALUES — user identity and profile option resolution.
• PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_PERIODS_OF_PLACEMENT — HR tables used to determine employee and contingent worker status and job titles.

Usage Notes

POS_PARTY_MANAGEMENT_PKG is an internal API invoked by other Oracle Sourcing and iProcurement packages rather than by end users directly. ETRM metadata records that it is referenced by four other packages. It is typically called from Sourcing registration flows, when enterprise users and their associated organization parties must be provisioned programmatically. Custom extensions may invoke pos_create_organization to register organizations in a TCA-compliant manner rather than inserting into HZ_PARTIES directly, preserving registry integrity. Callers should rely on the returned x_status and x_exception_msg out parameters for error handling, and be aware that R12 changed the intended scope of pos_create_user away from supplier user creation.