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 APRIL 16, 2018

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

Changes

 

Cause

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