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:
Oracle Inventory Management - Version 12.2.3 and laterOracle Item Master - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
Oracle error 1720: ORA-01720: grant option does not exist for 'INV.MTL_CATEGORIES_B#
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |