OptyReasonWonLostCdSetId Error Thrown When Closing Opportunities With Associated Competitors

(Doc ID 2114015.1)

Last updated on MARCH 23, 2016

Applies to:

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


You are getting the following error when closing Opportunities after a competitor is associated.

  "Attribute OptyReasonWonLostCdSetId in view object _LOCAL_VIEW_USAGE_oracle_apps_sales_opptyMgmt_opportunities_opportunityService_view_OpportunityVO_OpportuntyCompetitorVO1 cannot be set" 

Steps to reproduce it:

1. Create Opportunity with a Revenue Line.
2. Associate a Primary Competitor to the Opportunity.
3. Set the Opportunity to 'WON'. Click 'Save and Close'.
4. Error is thrown


Because there is a need to use Standard lookups values from the older version a custom filed was created for storing WinLostReason values used. Also the custom field is used as out of the box one is only visible once an Opportunity has been set to a Closed state

The following code is setting OptyReasonWonLostCd values



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