Are you sure that only a EO is involved in doing CRUD on that table? Because if it is happening by other means as well like through a PL/SQL api etc then you will miss those operations.
Also, assuming you have only EO then what exactly you are trying to do with that information? In functional terms, what do you want to do with that data?
Do you need just who created and who finally updated a record or you want to track it every time someone updates a record?
To track completely I would think using DB triggers to track the changes on the table.
Yes i am.
I know we can use DB triggers but then I wanted to create a business event where i can publish this(who updated/modified data) information on webservice,using which i can get XML data to generate my reports on it.
I wasn't aware of Which Jdev Version would be compatible to Fusion Appltn.? but then i got access to https://blogs.oracle.com/fadevrel/entry/jdeveloper_and_fusion_applications_explained which helped me to start.
I am stuck at ,now i am not able to add a business event for which i have created a separate post pls. help over(Unable to customize LedgerSetEO of Fusion Apps) and we can close this thread.
Thanks for the reply.