How To Capture Update Event And Identify Old Value And New Value Of An Attribute. (Doc ID 1995151.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

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?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms