My Oracle Support Banner

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 later
Information 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


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