Understanding Menu Tree Mapping and the Parent

5.1.4.4 Understanding Menu Tree Mapping and the Parent–Child Menu Structure

The menu hierarchy is defined in the AAI_MENU_TREE table using parent–child relationships.

Each row contains the following columns:

V_PACK_NAME – Pack or product (for example, OFS_LLFP_PACK)
V_APP_ID – Application or module (for example, OFS_LLFP)
V_PARENT_MENU_ID – Parent menu ID
V_CHILD_MENU_ID – Child menu ID
N_DISPLAY_ORDER – Display order under the parent

The columns in the AAI_MENU_TREE table represent the following:

OFS_LLFP_PACK – Identifies the pack or product
OFS_LLFP – Identifies the application or module
Third column – V_PARENT_MENU_ID, representing the parent menu
Fourth column – V_CHILD_MENU_ID, representing the child menu
Fifth column – N_DISPLAY_ORDER, representing the display sequence under the parent menu

Example:

OFS_LLFP_PACK | OFS_LLFP | OFS_LLFP_COM | AAI_DMM_DMM | 1

The menu hierarchy is implemented as a tree using the parent–child relationships defined in the AAI_MENU_TREE table.

The following structure illustrates how menus are logically organized and must be seeded in the sandbox:

OFS_LLFP_COM
 ├─ OFS_LLFP_COM (self, order 1)
 ├─ AAI_DMM_DMM (order 1)
 │   └─ AAI_DMM_DMM_DMMAINTENANCE (order 1)
 ├─ AAI_OA (order 2)
 │   ├─ AAI_OA_OS (order 1)
 │   │   ├─ AAI_OA_OS_BATCH_EXEC_RIGHT (1)
 │   │   ├─ AAI_OA_UTIL_SAVE_MD (2)
 │   │   ├─ AAI_OA_UTIL_MD_AUTH (3)
 │   │   ├─ AAI_OA_UTIL_MD_DIFF (4)
 │   │   └─ AAI_OA_OS_MD_SEG_MAP (5)
 │   └─ AAI_OA_OM (order 2)
 │       ├─ AAI_OA_OM_AM (1)
 │       └─ AAI_OA_OM_RM (2)
 ├─ AAI_DMF (order 3)
 │   ├─ OFS_LLFP_DATAINT (1)
 │   │   ├─ AAI_DMF_DMT_SRC_2102 (1)
 │   │   ├─ AAI_DMF_DMT_DM_2104 (2)
 │   │   ├─ AAI_DMF_DMT_PLC_2107 (3)
 │   │   └─ AAI_DMF_DMT_SCD (4)
 │   └─ AAI_DMF_DQF (2)
 │       ├─ AAI_DMF_DQF_DQRULE_2108 (1)
 │       └─ AAI_DMF_DQF_DQGROUP_2109 (2)
 ├─ AAI_DMF_DEFQ (order 4)
 │   ├─ AAI_DMF_DEFQ_FORMSDESIGNER (1)
 │   ├─ AAI_DMF_DEFQ_FORMSAUTH (2)
 │   ├─ AAI_DMF_DEFQ_DATAENTRY (3)
 │   ├─ AAI_DMF_DEFQ_ATOMICXLUPLOAD (4)
 │   └─ OFS_IFRS_SQL_RULE (5)
 ├─ AAI_UAM_DM (order 5)
 │   ├─ AAI_UAM_DM_ATTR (1)
 │   ├─ AAI_UAM_DM_MEM (2)
 │   └─ AAI_UAM_DM_HM (3)
 ├─ OFS_LLFP_BMM (order 6)
 │   ├─ AAI_UAM_DER_ENT (1)
 │   ├─ AAI_UAM_ALIAS (2)
 │   ├─ AAI_UAM_DS_4 (3)
 │   ├─ AAI_UAM_MSR_1 (4)
 │   ├─ AAI_UAM_DM_BH_3 (5)
 │   ├─ AAI_UAM_BP_59 (6)
 │   └─ AAI_UAM_MAP_MAIN (7)
 ├─ AAI_OPER (order 7)
 │   ├─ AAI_OPER_BATCH_MAIN (1)
 │   ├─ AAI_OPER_BATCH_EXEC (2)
 │   ├─ AAI_OPER_BATCH_MONITOR (3)
 │   └─ AAI_OPER_BATCH_CANCEL (4)

OFS_LLFP_MGMT
 ├─ OFS_LLFP_MGMT (self, order 1)
 ├─ OFS_LLFP_MAINT (order 2)
 │   ├─ OFS_LLFP_EIR_PREF (1)
 │   ├─ OFS_LLFP_MULTIPLE_RATING (2)
 │   └─ OFS_LLFP_CUR (3)
 ├─ OFS_LLFP_RUN_MANAG (order 3)
 │   ├─ AAI_RRF_RULE_501_502 (1)
 │   └─ AAI_RRF_RUN_701 (3)
 ├─ OFS_LLFP_STAGE_MKR_REASSIGN (4)
 ├─ OFS_LLFP_STAGE_CKR_REASSIGN (5)
 ├─ OFS_LLFP_MODELLING (6)
 │   ├─ OFS_LLFP_TRANSMATRIX (1)
 │   ├─ OFS_LLFP_PDECOSCENARIO (2)
 │   ├─ OFS_LLFP_PDMODELPROC (3)
 │   └─ OFS_LLFP_SURVIVAL_MODEL (4)
 ├─ OFS_LLFP_VINTAGE_MODEL (7)
 ├─ OFS_LLFP_LGD_MODEL (8)
 ├─ OFS_LLFP_RESERVE_DEFINE (9)
 ├─ OFS_LLFP_RESERVE_MAP (10)
 ├─ OFS_LLFP_AAAI (10)   -- duplicate display order (validate)
 │   ├─ OFS_AAAI_TECHREGISTER (1)
 │   ├─ OFS_AAAI_SBCREATION (2)
 │   ├─ OFS_AAAI_SBMAINTAIN (3)
 │   ├─ OFS_AAAI_VARDEF (4)
 │   └─ OFS_AAAI_MDLEXECUTION (5)
 │       ├─ OFS_AAAI_REQMDLEXECUTION (1)
 │       └─ OFS_AAAI_MDLOUTPUTS (2)
 ├─ AAI_MDB (12)
 ├─ OFS_LLFP_ANALYTICS (13)
 ├─ OFS_SUBLEDGER_ACCT_ATTR (14)
 ├─ OFS_SUBLEDGER_DEF (15)
 └─ OFS_SUBLEDGER_MAN_ADJ (16)

OFS_IIA_INBOX
 └─ OFS_IIA_INBOX (self, order 2)