Restrict Triggers On Opportunity Revenue On An Update Of Opportunity (Doc ID 2268351.1)

Last updated on JULY 05, 2017

Applies to:

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

Goal

Currently, Opportunity Revenue triggers also fires on an update to opportunity. How do we restrict that ?

We have the below code:

The following code in Before Insert triggers also on update.

if ( ( isAttributeChanged('Quantity') || isAttributeChanged('ProdGroupId') ) && ( getPrimaryRowState().isNew()) )
{
RevenueIntegrationPreCheck( "Insert" );
}

But we have to consider more fields in the isAtttibuteChanged condition and that causes the issue to happen again. Introducing the below code brings back the issue

if ( ( isAttributeChanged('Quantity') || isAttributeChanged('ProdGroupId') || isAttributeChanged('UnitPrice') || isAttributeChanged('UnitPrice')) && ( getPrimaryRowState().isNew()) )
{
RevenueIntegrationPreCheck( "Insert" );
}
 

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