Search Results pay_seed_soe_pkg




Overview
Explore in AI Chat

Overview

The APPS.PAY_SEED_SOE_PKG package is a Payroll (PAY) module database object that belongs to the Oracle E-Business Suite seed data framework. Its name reflects its role: "SOE" denotes the Seed/Setup Object Extractor pattern used by Oracle Payroll to manage seeded legislative and statutory configuration data, and "SEED" indicates that it operates against the seeded, Oracle-delivered configuration rather than customer transaction data. The package is classified as an OTHER API in the ETRM metadata for release 12.2.2, meaning it is not published as a public, supported integration interface; it is an internal utility invoked by Oracle's own setup and upgrade machinery.

The package header carries the revision identifier paysesoe.pkh 120.0 with a 2005 timestamp, indicating it is a long-standing, stable component of the Payroll seed data infrastructure. It consists of a single documented entry point, UPDATE_PROFILE, whose purpose is to refresh or synchronise profile-level configuration associated with seeded legislative fields. The package header itself contains no standalone declarations other than this procedure.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure on this package: UPDATE_PROFILE.

  • UPDATE_PROFILE — Declared as a public procedure in the package specification. Its parameter signature includes standard concurrent-program return values (errbuf and retcode), a business group identifier supplied as a varchar2, and an action parameter supplied as a varchar2. The errbuf/retcode pair is the conventional Oracle EBS concurrent program calling convention, which establishes that UPDATE_PROFILE is designed to be invoked as, or from, a concurrent program. The p_business_group_id parameter scopes the operation to a specific business group, and p_action provides a control verb that determines the nature of the profile update to be performed against that business group's seeded legislative field setup. No further procedures or functions are exposed in the documented package metadata.

Tables Accessed

The package accesses tables through APPS synonyms. The documented references are:

  • PAY_LEGISLATIVE_FIELD_INFO — The principal data table. This Payroll table stores definitions of legislative fields and their associated metadata, including the information that drives profile-level configuration for a business group. UPDATE_PROFILE reads and/or writes rows in this table to apply the requested profile changes.
  • DUAL — The standard Oracle single-row dummy table, typically used for control-flow checks, validation queries, or simple expression evaluation within the procedure logic.

The narrow table footprint — a single substantive Payroll configuration table plus DUAL — is consistent with a targeted maintenance utility rather than a broad data-loading program.

Usage Notes

PAY_SEED_SOE_PKG is not referenced by any other documented package, confirming that it sits at the edge of the dependency graph and is invoked directly rather than as a shared library. Its UPDATE_PROFILE procedure is invoked in the following contexts:

  • Concurrent programs — The presence of errbuf and retcode strongly indicates the procedure is registered as a concurrent program executable, allowing administrators to submit it from the Standard Request Submission (SRS) window.
  • Oracle seed and upgrade routines — As a seed-oriented (SOE) package, it is called by Oracle's own setup and patch/upgrade processes to realign legislative field profile configuration after patches, legislative data group changes, or business group refreshes.
  • Custom code — Customers may call UPDATE_PROFILE from custom PL/SQL where a controlled, business-group-scoped profile update is required, though as an OTHER-classified API it carries no support guarantee.

Because the package modifies seeded Payroll configuration, it should be executed only after backup of the affected business group setup and with awareness of the action code being passed.