My Oracle Support Banner

FA: SCM: OM: Publish Extensible Flexfield Attributes ESS process Fails With: Value XXXXXX for field EffContextCode exceeds the maximum length allowed. (Doc ID 2304426.1)

Last updated on FEBRUARY 09, 2021

Applies to:

Oracle Fusion Order Management Cloud Service - Version and later
Oracle Fusion Distributed Order Orchestration - Version and later
Information in this document applies to any platform.
***KM Review - Aug 2017 - Checked for Relevance***


An Order Management Extensible Flexfield (EFF) context has been created where the Context code or name exceeds 30 characters.

The issue can be reproduced by executing the following steps:

1. Amend an Order Management Extensible Flexfield adding a context where the context code or name exceeds 30 characters
2. Deploy the EFF - no errors are reported
3. Schedule New Process - Publish Extensible Flexfield Attributes
4. The process fails
5. Support has checked the ESS process log files and this shows an error:

<Aug 23, 2017, 3:29:31,572 PM UTC> <Error> <> <ESS-07004> <Execution error for request 29925. Reason: ESS-07033 Job logic indicated a system error occurred while executing an asynchronous java job for request 29925. Job error is: <env:Body xmlns:env="">
 <orafault:Fault xmlns:orafault="">
   <faultstring>JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000001854980 ] in ObjectAttributeEOJBO-27040: Value DiagnosticLabsAdditionalInformation for field EffContextCode exceeds the maximum length allowed.</faultstring>
     <tns:ServiceErrorMessage xmlns:tns="" xmlns:xsi="">
       <tns:message>JBO-27023: Failed to validate all rows in a transaction.</tns:message>
       <tns:detail xsi:type="tns:ServiceRowValErrorMessage">
         <tns:message>JBO-27024: Failed to validate a row with key oracle.>




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.