How To Capture Update Event And Identify Old Value And New Value Of An Attribute.
(Doc ID 1995151.1)
Last updated on APRIL 22, 2019
Applies to:Oracle Fusion Application Toolkit - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Developers must capture an update event (multiple fields) , call an external web service and pass old and new values of these attributes as parameters.
For example , developers are subscribing to "Update" business event for an "Organization" record. The SOA composite is invoked. The SOA composite gets "Organization" Id as the payload. Using the Organization Id , developers can query the service and get all the fields of Organization.
However, apart from the updated data, users want to have access to the "old value" of all the fields of the updated record. Something like E-Business Suite's HZ_PARAM_TAB table. This is needed for business logic based on which field has changed.
Users have the following questions.
1. After receiving Fusion Application's update" event in SOA, what interfaces are provided by Fusion applications for SOA to query oldvalue/newvalue for that updated record?
2. In the absence of 1. above, what is Oracle recommendation to customize Fusion Applications (using composer) to find oldvalue/newvalue of updated records and call a SOA service with oldvalue/newvalue as parameters?
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