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:
Oracle Quality Management Cloud Service - Version 11.13.18.05.0 and laterInformation in this document applies to any platform.
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
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 |