My Oracle Support Banner

Trigger Is Not Working As Expected (Doc ID 2670758.1)

Last updated on MAY 15, 2020

Applies to:

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

Goal

On : 11.13.20.01.0 version, Accounts, Contacts, Households

Trigger is not working as expected

There are 2 object - Assortment Plan and Assortment Line. Both are related object and Assortment Line is added as subtab in Assortment Line.
There are 2 ways to add line items, one go and create record manually in Assortment Line or Add all line items in Product Group and attach Product Group to Assortment Plan. Once user saves record after adding PRoduct Group, all items available in Product Group automatically gets added to Assortment Line.
Our Trigger is :
In Assortment Line, we have Product DCL. In assortment Line and PRoduct both, we have a custom attribute 'Sequence'. What trigger does is, when we create record in Assortment Line and select Product, it Update Sequence from Product to Assortment line.
The above trigger works when we create record manually in Assortment Line. But when record is added through Product Group Sequence is not getting updated in line items.
 

Solution

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