Error In Compiling People Group Flexfield - ORA-01720: grant option does not exist for 'HR.PAY_PEOPLE_GROUPS#' (Doc ID 2378409.1)

Last updated on NOVEMBER 02, 2023

Applies to:

Symptoms

On : 12.2.5 version, Flexfield Issues, Compilation Issues

When attempting to compile People Group Flexfield structure,
the following error occurs.

ERROR
-----------------------
Oracle error 1720: ORA-01720: grant option does not exist for 'HR.PAY_PEOPLE_GROUPS#'
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, PAY, 2, $statement$, PAY_PEOPLE_GROUPS_KFV): private_do_ddl(APPS, APPLSYS, HR, 2, $statement$, PAY_PEOPLE_GROUPS_KFV): do_cd_view(0, APPS, 2, PAY_PEOPLE_GROUPS_KFV, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW PAY_PEOPLE_GROUPS_KFV
 (ROW_ID, PEOPLE_GROUP_ID, ID_FLEX_NUM,
 CONCATENATED_SEGMENTS,
 PADDED_CONCATENATED_SEGMENTS,
 END_DATE_ACTIVE, START_DATE_ACTIVE, ENABLED_FLAG, SUMMARY_FLAG, GROUP_NAME, CREATION_DATE, CREATED_BY, LAST_'
CREATE OR REPLACE VIEW PAY_PEOPLE_GROUPS_KFV
 AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
 FROM SYS.DUAL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Freeze People Group Flexfield definition
2. Compile to see the error in 'Flexfield View Generator' program

Cause

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