Invalid Objects After Upgrade From 11.5.10.2 To 12.1.1: Key Flexfield Generation (FDFVGN) Raises Signal 11: Missing Grant on SYS.COL$ (Doc ID 2272500.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Invalid objects after upgrade from 11.5.10.2 to 12.1.1.

Examples of invalids:

OBJECT_NAME:

MTL_CATEGORIES_PKG, AHL_PRD_MTLTXN_PVT, AHL_PRD_MTLTXN_PVT_W, MTL_CATEGORIES_V, MTL_ITEM_FLEXFIELDS, MTL_SYSTEM_ITEMS_VL, BOM_BILL_OF_MTLS_QF_V, MTL_CUSTOMER_ITEM_XREFS_V, MTL_TRANSACTIONS_TEMP_ALL_V, MTL_DEMAND_V, MTL_MATERIAL_TXNS_VAL_V, MTL_SUMMARY_TEMP_V, MTL_ONHAND_LOT_V, MTL_ONHAND_LOCATOR_LOT_V, MTL_ONHAND_LOCATOR_V, MTL_ONHAND_SUB_V, MTL_ONHAND_REV_V, MTL_ONHAND_ITEMS_V, MTL_RESERVATIONS_V, MTL_CATEGORY_ACCOUNTS_V, MTL_ITEM_CATEGORIES_VIEW, MTL_CROSS_REFERENCES_V, MTL_CATEGORY_SET_VALID_CATS_V, MTL_ITEM_CATEGORIES_V, MTL_DEMAND_HISTORY_V, MTL_DEMAND_HISTORY_ITEMS_V, CST_MTL_RCV_TXN_V, ICX_MTL_ONHAND_SUB_V, ICX_MTL_DEMAND_SUMMARY_V, ICX_MTL_DEMAND_ITEM_SUM_V, ICX_MTL_ONHAND_ITEMS_KFV, ICX_MTL_ONHAND_LOCATOR_KFV, ICX_MTL_ONHAND_LOT_KFV, ICX_MTL_ONHAND_REV_KFV, ICX_MTL_ONHAND_SERIAL_KFV, ICX_MTL_ONHAND_SUB_KFV, MTL_SHORT_SUMMARY_V, AHL_MTL_ITEMS_OU_V, MTL_ONHAND_SERIAL_V, MTL_CONSUMPTION_DEFINITION_V, MTL_EAM_ASSET_ACTIVITIES_V, MTL_EAM_ASSET_NUMBERS_ALL_V, MTL_EAM_ASSET_NUMBERS_V, MTL_EAM_ASSET_REBUILDS_DTLS_V, MTL_EAM_ASSET_REBUILDS_V, MTL_EAM_ASSET_ACTIVITIES_WB_V, MTL_EAM_NETWORK_ASSETS_V, MTL_ONHAND_TOTAL_V, MTL_ONHAND_LPN_V, MTL_ONHAND_LPN_MWB_V, MTL_ONHAND_SERIAL_MWB_V, MTL_ONHAND_TOTAL_MWB_V, MTL_ONHAND_NEW_LPN_MWB_V, MTL_ONHAND_NEW_LPN_V, JTM_MTL_SYSTEM_ITEMS_V, POS_MTL_ONHAND_ITEMS_KFV, POS_MTL_ONHAND_LOCATOR_KFV, POS_MTL_ONHAND_LOT_KFV, POS_MTL_ONHAND_REV_KFV, POS_MTL_ONHAND_SERIAL_KFV, POS_MTL_ONHAND_SUB_KFV, CZ_EXV_MTL_SYSTEM_ITEMS, AHL_MTL_ITEMS_NON_OU_V, AHL_MTL_ITEMS_EAM_V, AHL_MTL_RET_DISPOSITIONS_V, CSL_MTL_EXPENSE_LABOR_ITEMS_V, MTL_SYSTEM_ITEMS_ER1_V, MTL_SYSTEM_ITEMS_ER2_V, MTL_SYSTEM_ITEMS_ER3_V, MTL_TRANSACTION_FLOW_HEADERS_V, MTL_EAM_ITEMS_V, MTL_SERIAL_NUMBER_GEN_V, MTL_RCV_MWB_ONHAND_V, MTL_RCV_SERIAL_OH_V, AHL_PRD_MTLTXN_PVT, AHL_PRD_MTLTXN_PVT_W, CSP_PC_FORM_MTLTXNS, WIP_MTLTEMPPROC_PRIV, EAM_MTL_TXN_PROCESS, MTL_CATEGORY_SETS_PKG, MTL_CATEGORIES_PKG, AHL_PRD_DISP_MTL_TXN_PVT, MTL_GRADE_CHANGE_ERV, MTL_MATERIAL_STATUS_HIST_ERV, MTL_ITEM_LOT_UOM_CONV_ERV, MTL_LOT_NUMBERS_ERV, MTL_LOT_ONHAND_SUM_V, MTL_RCV_MWB_NEW_OH_V, MTL_RCV_SERIAL_MWB_OH_V, MTL_MFG_COMPONENTS_V, MTL_MFG_PRODUCTS_V, MTL_WORK_ORDER_HEADER_V, MTL_MFG_GENEALOGY_LOTATTR_V, MTL_LOT_UOM_CONV_PVT

STEPS
1. Upgrade from r11i to R12.1.
2. Review invalids.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.