How To Capture Update Event And Identify Old Value And New Value Of An Attribute.
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion Application Toolkit - Version 184.108.40.206.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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms