Custom Role Not Working Properly For Opportunity Object (Doc ID 1908042.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

On : 11.1.8.0.0 version, Other Issues

Custom Role not fully working properly for Opportunity Object

Created a Custom role EXP Account Role with a Custom duty for Opportunity Sales Representative Duty named as 'Opportunity Sales Representative Duty', and have removed the Delete Opportunity in this duty.
Users can not delete an Opportunity using the custom role But in summary Opportunity UI the red cross icon is not greyed.

So when attempting to delete an opportunity from Opportunity summary UI the following error occurs.

ERROR
-----------------------
Get an incident
By checking Readme log of incident see :
java.lang.Exception: An application error occurred. See the incident log for more
  information.
at oracle.apps.fnd.applcore.messages.ExceptionHandlerUtil.processExceptionWithResourceBundle(ExceptionHandlerUtil.java:128)
......
Caused by: javax.el.ELException: oracle.jbo.RemoveRowPrivilegeException: JBO-24004: Rows cannot be removed from entity Opportunity.
at com.sun.el.parser.AstValue.invoke(AstValue.java:191)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodExpression


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A)
> search for crm Authorization polcies
> starting by EXP

See 3 authorization policies

EXP Account Rep
EXP Sales party Management Duty
EXP Opportunity Sales representative Duty

> Open EXP Opportunity Sales representative Duty

1. Functional Policies tab
> Delete Opportunities had been removed (ythis by Comparing with standard Opportunity Sales representative Duty)
> Delete revenue Lines too had been removed (ythis by Comparing with standard Opportunity Sales representative Duty)

2. Data Security tab
All policies including Delete had been removed

B) Log with a salesrep having custom role : EXP Opportunity Sales representative Duty
plus EXP Account Rep

Navigator > Opportunity Summary UI > highlight an Opportunity > Red Cross is available and not greyed
> Click on red cross > get a SalesApp incident error
> Readme.txt provides log as above


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot delete opportunities but still see the red cross active

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