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 03, 2022

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.

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.>

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
References

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