After Applying Patch Get Oracle Error 1720: Grant Option Does Not Exist for 'INV.MTL_CATEGORIES_B# (Doc ID 2206137.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

On : 12.2.3 version, Patch Application Issues

Invalid views and packages

Oracle error 1720: ORA-01720: grant option does not exist for 'INV.MTL_CATEGORIES_B#'

Inventory Invalids
INV_MGD_MVT_UTILS_PKG INVUINTB.pls 120.16 BODY INVALID
Errors for PACKAGE BODY INV_MGD_MVT_UTILS_PKG

PL/SQL: ORA-00904: "MKV"."CATEGORY_ID": invalid identifier
PL/SQL: SQL Statement ignored
INV_MINMAX_PVT INVVMMXB.pls 120.17.12020000.13 BODY INVALID

Errors for PACKAGE BODY INV_MINMAX_PVT

PL/SQL: ORA-00904: "STRUCTURE_ID": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00341: declaration of cursor 'C_CATG_DISP' is incomplete or malformed
PL/SQL: Item ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: SQL Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored

INV_STANDALONE_SYNC_PUB INVSLSPB.pls 120.1 BODY INVALID

Errors for PACKAGE BODY INV_STANDALONE_SYNC_PUB

PLS-00905: object APPS.MTL_ADJUSTMENT_TXN_SYNC_V is invalid
PL/SQL: Item ignored
PL/SQL: ORA-04063: view "APPS.RCV_RECEIPT_CONFIRMATION_V" has errors
PL/SQL: SQL Statement ignored
PLS-00597: expression 'L_TXN_DETAIL' in the INTO list is of wrong type
PL/SQL: SQL Statement ignored
PLS-00487: Invalid reference to variable 'MTL_ADJUSTMENT_TXN_SYNC_V%ROWTYPE'
PL/SQL: Statement ignored

FDFVGN: Flexfield View Generator FROM MTL_CATEGORIES_B

Oracle error 1720: ORA-01720: grant option does not exist for 'INV.MTL_CATEGORIES_B#'
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, INV, 2, $statement$, MTL_CATEGORIES_B_KFV): private_do_ddl(APPS, APPLSYS, INV, 2, $statement$, MTL_CATEGORIES_B_KFV): do_cd_view(1, APPS, 2, MTL_CATEGORIES_B_KFV, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW MTL_CATEGORIES_B_KFV
 (ROW_ID, CATEGORY_ID, STRUCTURE_ID,
 CONCATENATED_SEGMENTS,
 PADDED_CONCATENATED_SEGMENTS,
 SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_A'
CREATE OR REPLACE VIEW MTL_CATEGORIES_B_KFV
 AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
 FROM SYS.DUAL

Cause

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