While Compiling Key Flexfield (KFF), Getting Error 'grant option does not exist for INV.MTL_GENERIC_DISPOSITIONS#'
(Doc ID 2870478.1)
Last updated on MAY 23, 2022
Applies to:
Oracle Inventory Management - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
While compiling key flexfield (KFF), getting error 'grant option does not exist for INV.MTL_GENERIC_DISPOSITIONS#'.
Steps
1. Go to Application Developer responsibility.
2. Navigate to Flexfield -> Key -> Segments
3. Query the required flexfield (e.g. Account Aliases Under Flexfield title )
4. Click on 'Freeze Flexfield Definition' checkbox. (i.e. uncheck it).
5. Make required changes.
6. Again click on 'Freeze Flexfield Definition' checkbox. (i.e. Check it).
7. Save the changes.
8. The system will start compiling. A concurrent program "Flexfield View Generator" will be launched in the background.
9. Once program completes, observe that it is not successful with error mentioned below.
Error
Following is the full text of error which is seen in the log of the concurrent program "Flexfield View Generator" (Launched in step#8 above) :
(ROW_ID, DISPOSITION_ID, ORGANIZATION_ID,
CONCATENATED_SEGMENTS,
PADDED_CONCATENATED_SEGMENTS,
END_DATE_ACTIVE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, DESCRIPTION, DISABLE_DATE, EFFECTIVE_DATE, DISTRIBUTION_ACCOUNT, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE)
AS SELECT ROWID, DISPOSITION_ID, ORGANIZATION_ID,
SEGMENT1 || '.' || SEGMENT2,
RPAD(NVL(SEGMENT1, ' '), 3) || '.' || RPAD(NVL(SEGMENT2, ' '), 50),
END_DATE_ACTIVE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, DESCRIPTION, DISABLE_DATE, EFFECTIVE_DATE, DISTRIBUTION_ACCOUNT, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE
FROM MTL_GENERIC_DISPOSITIONS
Oracle error 1720: ORA-01720: grant option does not exist for 'INV.MTL_GENERIC_DISPOSITIONS#'
ORA-06512: at "APPS.AD_DDL", line 210
ORA-06512: at "APPS.AD_DDL", line 402
ORA-06512: at "APPS.AD_DDL", line 1117
ORA-06512: at "APPS.AD_APPS_PRIVATE", line 260
OR has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, INV, 2, $statement$, MTL_GENERIC_DISPOSITIONS_KFV): private_do_ddl(APPS, APPLSYS, INV, 2, $statement$, MTL_GENERIC_DISPOSITIONS_KFV): do_cd_view(1, APPS, 2, MTL_GENERIC_DISPOSITIONS_KFV, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW MTL_GENERIC_DISPOSITIONS_KFV
(ROW_ID, DISPOSITION_ID, ORGANIZATION_ID,
CONCATENATED_SEGMENTS,
PADDED_CONCATENATED_SEGMENTS,
END_DATE_ACTIVE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, A'
CREATE OR REPLACE VIEW MTL_GENERIC_DISPOSITIONS_KFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL
Changes
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 |
| Changes |
| Cause |
| Solution |