JBO-27024: Failed to validate a row with key oracle.jbo.Key300000009043211 in OpportunityEOJBO-27014: Attribute XXX in OpportunityEO is required.JBO-27014: Attribute XXX in OpportunityEO is required (Doc ID 2224141.1)

Last updated on JANUARY 17, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

In Trigger Opportunity WS - create Opportunity() operation is called and error below is shown:


Error Message :
Exception in expression "MklLeadEO" trigger "LeadToOpportunityConversion_Update" : oracle.binding.expr.ServiceInvocationException Unexpected exception caught: oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException, msg=Client received SOAP Fault from server : JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key300000009043211 in OpportunityEOJBO-27014: Attribute OpportunityState_c in OpportunityEO is required.JBO-27014: Attribute OpportunityState_c in OpportunityEO is required.: Client received SOAP Fault from server : JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key300000009043211 in OpportunityEOJBO-27014: Attribute OpportunityState_c in OpportunityEO is required.JBO-27014: Attribute OpportunityState_c in OpportunityEO is required.
at "MklLeadEO" trigger "LeadToOpportunityConversion_Update" line 113

The field OpportunityState_c is a FCL that is in Opportunity Object with the following configuration:
1 - It is marked as required
2 - has Parent Constrain of another FCL called Opportunity Country

Behavior:

a ) Make OpportunityState_c not required and keep parent constrain - NO ERROR
b) Leave OpportunityState_c as required and remove parent constrain - NO ERROR

c) Leave OpportunityState_c as Required and keep Parent constrain - ERROR SHOWN


 

Solution

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