Search Results per_ose_bus




Overview
Explore in AI Chat

Overview

PER_OSE_BUS is the business (validation and persistence) layer of the Oracle EBS Organization Structure Elements (OSE) module, resident in the APPS schema. It operates alongside PER_OSE_SHD (shadow/interface staging) and PER_OSE_DEL (deletion handling), forming a triad of packages that manage the definition, maintenance, and removal of organization structure elements. In the Oracle E-Business Suite 12.1.1 and 12.2.2 architectures, PER_OSE_BUS is responsible for enforcing business rules during element creation, update, and deletion while applying the correct security group and legislation context. Because it is a PACKAGE BODY only, it is not called directly by end users but rather through the public package specification and via internal callers such as PER_OSE_SHD and PER_OSE_DEL. The ETRM record lists the object as VALID and classified as "OTHER" in the API taxonomy, meaning it is an internal business service rather than a published public API.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within the package body:

  • SET_SECURITY_GROUP_ID — Establishes the security group identifier within the session context so that subsequent organization structure element operations are restricted to the correct business group and security profile.
  • RETURN_LEGISLATION_CODE — A function that returns the legislation code applicable to the organization structure being processed, ensuring the correct statutory rules are applied.
  • INSERT_VALIDATE — Performs validation prior to inserting a new organization structure element, verifying that the element meets structural and referential integrity requirements.
  • UPDATE_VALIDATE — Validates an update to an existing organization structure element, ensuring the modified attributes remain consistent with the surrounding hierarchy and security context.
  • DELETE_VALIDATE — Validates whether an organization structure element may be safely deleted, preventing removal of records still referenced by dependent structures or security profiles.

Tables Accessed

The package works against the core HR organization model through APPS synonyms:

It also references PER_BUSINESS_GROUPS, DUAL, HR_API, HR_GENERAL, HR_UTILITY, PA_ORG, FND_MESSAGE, and the sibling packages PER_OSE_SHD, PER_OSE_DEL, and itself for internal delegation.

Usage Notes

PER_OSE_BUS is not referenced by any database object according to the ETRM dependency report, yet is referenced by three other packages, confirming its role as a supporting business service. Typical invocation occurs indirectly: organization structure maintenance is driven from Oracle HRMS forms and from concurrent programs that manage organization hierarchies, and those callers delegate to PER_OSE_SHD or PER_OSE_DEL, which in turn invoke the validation routines in PER_OSE_BUS. Custom extensions should not call PER_OSE_BUS directly; instead, invoke the published HR organization APIs, which internally route through this business layer. Because the procedures are validation-oriented, they should be treated as pre-commit gates rather than processing logic. Any changes to security group or legislation context should be made through SET_SECURITY_GROUP_ID before validation calls to avoid incorrect data being persisted.