Search Results menu_id_tbl




Overview
Explore in AI Chat

Overview

APPS.CSD_MIGRATE_FROM_12X_PKG8 is a migration utility package in the Oracle E-Business Suite Applications (APPS) schema, classified under the ETRM as an OTHER-type API. Its name and the single documented routine identify it as one in a series of sequential migration packages — the "PKG8" suffix indicates this is the eighth member of a numbered family — used to migrate Oracle EBS 12.x menu and function metadata between releases and patch levels. Specifically, the package supports the conversion from the 12.x menu structure to the restructured menu hierarchy introduced for later 12.1.1 / 12.2.2 environments. In EBS, HTML-based navigation replaced the legacy Java applet menu tree, and the underlying FND_MENUS / FND_MENU_ENTRIES data had to be reorganized so that the new navigation components resolved the correct menu hierarchy. This package performs that restructure step during the upgrade or migration cycle. It is documented as Status: VALID in the APPS schema and is Oracle Proprietary, Confidential Information.

Key Procedures and Functions

  • CSD_MENU_RESTRUCTURE_MIG8 — The single documented procedure in this package. As its name implies, it carries out the eighth segment of the menu restructure migration: it reorganizes menu entries and the associated function references within the FND foundation tables so the menu tree conforms to the target release's expected structure. It is intended to be executed as part of an ordered migration sequence rather than in isolation, since earlier packages in the CSD_MIGRATE_FROM_12X series prepare data that this routine expects. Parameter lists are not documented in the available ETRM metadata and are therefore not reproduced here.

Tables Accessed

The package references the following tables through APPS synonyms:

  • FND_MENUS — the foundation table holding menu definitions. The restructure routine reads and updates menu rows so the target hierarchy is registered under the correct menu definitions.
  • FND_MENU_ENTRIES — the child table that links functions and submenus to their parent menus. The procedure rewrites entries here to rebuild the menu tree structure.
  • FND_FORM_FUNCTIONS — the function registry that defines callable forms, runnable requests, and web functions. It supplies the function identifiers that menu entries point to, and may be updated to align with the restructured menus.
  • PLITBLM — a PL/SQL internal support table (a standard structure used by Oracle's PL/SQL toolkit, commonly encountered in EBS dictionary/migration programs) used as a transient working area during processing rather than as a persistent application data store.

Usage Notes

CSD_MIGRATE_FROM_12X_PKG8 is not a runtime application API. It is an upgrade-path utility, invoked during the migration of menu and function metadata when moving to or applying maintenance on EBS 12.1.1 / 12.2.2, typically from an Oracle-supplied upgrade or patch driver script that calls the CSD_MIGRATE_FROM_12X packages in sequence. The ETRM lists no other packages as referencing it, which indicates it is driven by external scripts rather than by application code. It is not exposed through a standard form or concurrent program, and it should never be called manually or from custom code, since doing so against an already-migrated instance can corrupt the FND menu hierarchy. Direct invocation is restricted to controlled migration windows; administrators should rely on the packaged migration drivers and take a full backup of the FND menu tables beforehand. Given the minimal documented interface, the package should be treated as an internal Oracle tool with no supported customer-facing entry point.