R12: AP: When Attempting To Run Flexfield View Generator Gets Error 'Oracle error 1720: ORA-01720: grant option does not exist for 'IBY.IBY_BEPKEYS#''
(Doc ID 3042799.1)
Last updated on NOVEMBER 21, 2024
Applies to:
Oracle Payables - Version 12.0.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to Run Flexfield View Generator,
the following error occurs.
ERROR
-----------------------
Oracle error 1720: ORA-01720: grant option does not exist for 'IBY.IBY_BEPKEYS#'
ORA-06512: at "APPS.AD_DDL", line 210
ORA-06512: at "APPS.AD_DDL", line 402
ORA-06512: at "APPS.AD_DDL", line 1117
ORA-06512: at "APPS.AD_APPS_PRIVATE", line 260
ORA-06512: at " has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, IBY, 2, $statement$, IBY_BEPKEYS_DFV): private_do_ddl(APPS, APPLSYS, IBY, 2, $statement$, IBY_BEPKEYS_DFV): do_cd_view(1, APPS, 2,
IBY_BEPKEYS_DFV, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW IBY_BEPKEYS_DFV
(ROW_ID, "CONTEXT_VALUE", MESSAGE_ID, INIT_PARTY_NAME, ORGANISATION_ID, SCHEME_CODE, SERVICE_LEVEL_CODE, CATEGORY_PURPOSE_CODE,
CLEARING_SYS_CODE, BNK_GIRO_MEMB_ID_CODE, VALUE_DAYS, BBAN_SCHME_NAME, GIRO_SCHME_NAM'
CREATE OR REPLACE VIEW IBY_BEPKEYS_DFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL
Changes
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 |
Changes |
Cause |
Solution |