Error In Compiling People Group Flexfield - ORA-01720: grant option does not exist for 'HR.PAY_PEOPLE_GROUPS#'
Last updated on APRIL 16, 2018
Applies to:Oracle Human Resources - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Flexfield Issues, Compilation Issues
When attempting to compile People Group Flexfield structure,
the following error occurs.
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,
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms