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:
Oracle Human Resources - Version 12.2.5 and laterInformation 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 |