Spares Management Patch Fails with "ORA-01720 grant option does not exist for 'SYS.ALL_MVIEWS'" (Doc ID 2581908.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Goal

Error occurred while applying a Spares Management (CSP) patch:

AD Worker error:
The following ORACLE error:

ORA-01720: grant option does not exist for 'SYS.ALL_MVIEWS'

occurred while executing the SQL statement:

CREATE OR REPLACE FORCE VIEW APPS.CSP_SUP_DEM_PL_V ("INVENTORY_ITEM_ID",
"ITEM_NUMBER", "ITEM_DESCRIPTION", "PARTS_LOOP_ID", "PRIMARY_UOM_CODE",
"ONHAND_BAD", "ONHAND_GOOD", "INTRANSIT_MOVE_ORDERS", "PURCHASE_ORDERS",
"SALES_ORDERS", "WORK_ORDERS", "REQUISITIONS", "MOVE_ORDERS_IN",
"MOVE_ORDERS_OUT", "INTERORG_TRANSF_IN", "INTERORG_TRANSF_OUT",
"TRANSFER_IN", "TRANSFER_OUT", "CREATION_DATE") AS SELECT
csdpm.inventory_item_id, msibk.concatenated_segments, msibk.description,
csdpm.parts_loop_id, msibk.primary_uom_code, csdpm.onhand_bad,
csdpm.onhand_good, csdpm.intransit_move_orders, csdpm.purchase_orders,
csdpm.sales_orders, csdpm.work_orders, csdpm.requisitions,
csdpm.move_orders_in, csdpm.move_orders_out, csdpm.interorg_transf_in,
csdpm.interorg_transf_out, csdpm.move_orders_in+csdpm.interorg_transf_in
transfer_in, csdpm.move_orders_out+csdpm.interorg_transf_out transfer_out
, am.creation_date from csp_sup_dem_pl_mv csdpm, mtl_system_items_vl
msibk, (select last_refresh_date creation_date from all_mviews where
mview_name = 'CSP_SUP_DEM_PL_MV') am where csdpm.inventory_item_id =
msibk.inventory_item_id and csdpm.organization_id = msibk.organization_id

Solution

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