My Oracle Support Banner

GRC 8.6.x : ETL Sync Failed Errored "ORA-12899: value too large for column "<SCHEMA_NAME>"."<TABLE_NAME>"."<COLUMN_NAME>" (actual: 63, maximum: 60)" (Doc ID 2460824.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle Application Access Controls Governor - Version 8.6.6 and later
Information in this document applies to any platform.

Symptoms

During ETL Sync Access:

ORA-12899: value too large for column "<SCHEMA_NAME>"."<TABLE_NAME>"."<COLUMN_NAME>" (actual: 63, maximum: 60)

Please see in attached log file the error:

2018-07-23 11:00:02,383 DEBUG [SimpleAsyncTaskExecutor-1] GrcLogPrintStream:73 STDOUT (oracle.core.ojdl.logging.ConsoleHandler:118) ODI-1217: Session LOADACCESSDATACORE (82154) fails with return code 12899.
Caused by: 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.SnpSession.treatSession(SnpSession.java:2320)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

--------------------------------

The table in EBS instance FND_MENU_ENTRIES_TL is only 60 characters long.

 


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.