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