EGRC Access Sync Errors With "C$_0TMP_FND_MENU_ENTRIES_TL"."C5_PROMPT" (actual: 63, maximum: 60)

(Doc ID 2042466.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 to 8.6.5 [Release 8]
Information in this document applies to any platform.


On : version, Application Access Contr. Gov.

In Oracle Application Access Controls Governor (AACG), models and controls define conflicts among duties that can be assigned in a company’s applications, and identify users who have access to those conflicting duties.
AACG can also implement “preventive analysis” — it can evaluate controls as duties are assigned to users of the company’s applications, preventing them from gaining risky access.

When attempting to run Access ETL,
the following error occurs.

ERROR in grc.log
ODI-1226: Step LoadFndMenuEntriesTL fails after 1 attempt(s).
Caused by: ODI-1240: Flow LoadFndMenuEntriesTL fails while performing a Loading operation. This flow loads target table TMP_FND_MENU_ENTRIES_TL.
Caused by: ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection physical_schema_tgt.
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "GRC"."C$_0TMP_FND_MENU_ENTRIES_TL"."C5_PROMPT" (actual: 63, maximum: 60)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(

The issue can be reproduced at will with the following steps:
1. Define the datasource for R12 EBS.
2. Submit the Access Synch.
3. Monitor the Job and check log files.

The issue has the following business impact:
Due to this issue, users cannot run Access ETL/Synch.


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