Application Composer: How To Get The Old And The New Field Value Inside A Server Script Trigger (Doc ID 2523734.1)

Last updated on MARCH 22, 2021

Applies to:

Goal

On : 11.13.19.01.0 version, Quality Issue and Action Management

Application Composer: How to get the old and the new field value inside a Server Script Trigger

My scope is to set the Description field value of a Quality Issue
 - with "Issue Name was just updated" value when the Quality Issue Name was just manually changed
 - or with "Issue Name was updated in the past" value when the Quality Issue Name still the same (during a Quality Issue update)

To do it, I went to Application Composer -> application “ERP and SCM Cloud” -> Standard Objects -> Quality Issue -> Server Scripts -> Triggers -> Object Triggers > Add a New Trigger:
Trigger: BeforeUpdate
Trigger Name: BeforeUpdate_Description

In Trigger Definition I have to check if the old value of Quality Issue Name is different from the new value of Quality Issue Name. Is it a way to do it?
(for example in Oracle EBS there is the "before update" db trigger, and I can use "new.Name" and "old.Name" to get the old and the new value of a field)
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.