Search Results csd_menu_restructure_mig8




Overview
Explore in AI Chat

Overview

CSD_MIGRATE_FROM_12X_PKG8 is a migration utility package in the Oracle E-Business Suite Advanced Product Catalog / Depot Repair (CSD) module. Its documented purpose is to restructure seeded menu definitions during an upgrade or patch migration from a 12.x source environment. Specifically, the package contains the procedure CSD_MENU_RESTRUCTURE_MIG8, which removes obsolete menu entries from three seeded CSD menus — CSD_DEPOT_MENU, CSD_SETUP_MENU, and CSD_OTHER_MENU — that were delivered by earlier releases but are no longer required in the target menu structure.

The package header comment states that the procedure updates the existing CSD_RO_SAVEDSEARCHES table to support the iSupport multiparty enhancement, defaulting the PARTY_ID of existing records to the party_id corresponding to the user_id. The procedure name and the cursor logic, however, focus on menu restructuring, indicating the package participates in both the saved-search data migration and the removal of superseded menu functions. It is one of a numbered series of migration packages (PKG1 through PKG8 and beyond) executed in sequence during the 12.1.1 to 12.2.2 upgrade path.

Key Procedures and Functions

  • CSD_MENU_RESTRUCTURE_MIG8 — The single documented procedure in this package. It identifies and deletes seeded menu entries that were installed by earlier releases and are no longer part of the delivered menu hierarchy. The procedure declares a cursor, C_GET_MENU_ENTRIES, that returns MENU_ID and ENTRY_SEQUENCE pairs for the affected menus, and collects results into an array of type MENU_ID_TBL. Entries are selected only when the LAST_UPDATED_BY value falls within the seeded IDs 120, 121, or 122, ensuring that customer-modified entries are preserved. The procedure also serves as part of the iSupport multiparty data migration by updating PARTY_ID defaults on CSD_RO_SAVEDSEARCHES records.

Tables Accessed

  • FND_MENUS — Read to resolve the seeded menu names CSD_DEPOT_MENU, CSD_SETUP_MENU, and CSD_OTHER_MENU to their MENU_ID values.
  • FND_MENU_ENTRIES — Read to obtain the ENTRY_SEQUENCE of each menu entry to be removed, and the primary target of the deletion operation.
  • FND_FORM_FUNCTIONS — Joined to filter menu entries to specific seeded function names such as CSDHVR, CSDSRRCL, MRPCHORG, CSDRTSET, and CSDDCSET, among others.
  • PLITBLM — The PL/SQL table used for bulk collection of menu entry identifiers prior to processing.

The cursor unions three queries, one per affected menu, restricting deletion to seeded functions delivered with the base product and never modified by the customer.

Usage Notes

CSD_MENU_RESTRUCTURE_MIG8 is a migration-only routine and is not intended for routine runtime execution. It is invoked during the upgrade or patch application process, typically as part of the standard AD patch driver sequence, and is not exposed through an application form or concurrent program. Because it deletes seeded menu entries, it should be run only in the context of the supported migration path and against environments where the seeded LAST_UPDATED_BY convention (120, 121, 122) is preserved. The package is referenced by zero other packages, confirming that its invocation is driven by the migration driver rather than by dependent application code. Administrators should apply it in coordination with the remaining CSD_MIGRATE_FROM_12X_PKG series and verify menu behavior afterward in the target 12.2.2 environment.