My Oracle Support Banner

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 FEBRUARY 18, 2019

Applies to:

Oracle Human Resources - Version 12.2.5 and later
Information in this document applies to any platform.

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

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


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