Search Results eds_fcet

Overview

AD_ZD_SEED is a helper package within the Oracle E-Business Suite Applications DBA (AD) product family that supports the Online Patching infrastructure introduced with EBS 12.2. Its header declares AUTHID CURRENT_USER, and its embedded comment line designates the first group of subprograms as "EDS Helper Functions," where EDS refers to the Editioning-based Data Seed or Editioning Deployment Support mechanism used to reconcile seed data and editioned database objects during the patching cycle. In the 12.1.1 and 12.2.2 context, the package operates alongside the AD Online Patching driver (ADZDPATCH, ADOP) to prepare editioned synonyms, views, triggers, row-level security (RLS) policies, and function-based indexes so that seed data and editioned objects behave consistently across the patch edition and the run edition. Practically, it lets the patching infrastructure upgrade or downgrade the seed-related database structures of a given table, prepare patch events, perform a cutover, and clean up or abort as needed.

Key Procedures and Functions

• EDS_COLUMN, EDS_TRIGGER, EDS_POLICY, EDS_FUNCTION, EDS_FCET — EDS helper functions. EDS_COLUMN returns the column definition used in the editioning/EDS model. EDS_TRIGGER and EDS_POLICY generate the trigger and RLS policy definitions applied to an editioned table. EDS_FUNCTION and EDS_FCET return function-based index expressions (FCET = Function-Based Column Expression Type), used to rebuild indexes correctly for a table.
• UPGRADE — DB preparation API that converts a table's seed-related objects to the 12.2 editioning model, accepting an optional mode parameter (defaulting to 'CURRENT').
• DOWNGRADE — The inverse of UPGRADE; reverts a table's EDS/editioning objects to the pre-upgrade form.
• PATCH — Patch event API invoked per table (owner and name) to apply seed changes during a patch cycle.
• PREPARE — Prepares a table for the patch event, staging objects for the upcoming edition switch.
• CUTOVER — Switches the patch edition to the run edition, making the prepared objects live.
• CLEANUP — Removes residual seed objects after cutover; the table name is optional (nullable), allowing a full clean.
• ABORT — Aborts the in-progress patch event and rolls back staged changes.

Tables Accessed

The package inspects the data dictionary exclusively, via APPS synonyms, to derive object definitions dynamically. It reads DBA_OBJECTS_AE and DBA_SOURCE (object types and source text), DBA_TAB_COLUMNS and DBA_CONS_COLUMNS (columns and constraint columns), DBA_CONSTRAINTS (constraint definitions), DBA_INDEXES and DBA_IND_COLUMNS (index and index column metadata), DBA_TRIGGERS (trigger definitions), DBA_POLICIES (RLS policies), and DBA_SYNONYMS (object resolution). It utilizes DBMS_METADATA to extract DDL, DBMS_LOB for large object handling, DBMS_RLS for policy management, DBMS_LOCK and DBMS_UTILITY for serialization and utility operations.

Usage Notes

AD_ZD_SEED is not an end-user API. It is invoked internally by the AD Online Patching infrastructure during ADOP patch and cutover cycles, and is referenced by 19 other packages within the AD/EDS framework. Custom code and standard concurrent programs do not call it directly; instead, the patching driver sequences UPGRADE, PREPARE, PATCH, CUTOVER, and CLEANUP (or ABORT) to migrate seed data and editioned objects. In the context of the user search term "eds_function," the EDS_FUNCTION subprogram is the relevant entry point, returning the function-based index expression for a given table so the patching engine can regenerate the associated index definition during upgrade, patch, or downgrade. Because it performs definition-level DDL generation against editioned objects, AD_ZD_SEED should be regarded strictly as an internal, patch-cycle-bound utility in both 12.1.1 and 12.2.2 environments.