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 SEPTEMBER 05, 2017

Applies to:

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

Symptoms

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> <oracle.as.ess> <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="http://schemas.xmlsoap.org/soap/envelope/">
 <orafault:Fault xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0">
   <faultcode>env:Server</faultcode>
   <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>
   <detail>
     <tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
       <tns:code>27023</tns:code>
       <tns:message>JBO-27023: Failed to validate all rows in a transaction.</tns:message>
       <tns:severity>SEVERITY_ERROR</tns:severity>
       <tns:detail xsi:type="tns:ServiceRowValErrorMessage">
         <tns:code>27024</tns:code>
         <tns:message>JBO-27024: Failed to validate a row with key oracle.>

Cause

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