My Oracle Support Banner

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 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

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