How can I create a report on account change history?

While there's no Oracle Transactional Business Intelligence (OTBI) subject area for creating reports on changes to account data and other Oracle Fusion application objects, you can track changes using the Audit feature.

  1. In the Setup and Maintenance work area, search for and open the Manage Audit Policies task.
  2. On the Manage Audit Policies page, go to the Oracle Fusion Applications section and click Configure Business Object Attributes.
  3. On the Configure Business Object Attributes page, click Product and select the product area that you want to audit. To audit accounts, select the Common CRM object.
  4. Open the Customer section in the left pane to view the categories of attributes related to accounts and select the ones you want to audit.If no attribute is listed for the category, use the Add (plus sign) icon to add attributes from the Select and Add Audit Attributes pane.
  5. After you select all the required objects and their attributes, click Save and Close. You return to the Manage Audit Policies page.
  6. In the Oracle Fusion Applications section, click the Audit Level list and select Auditing. This setting turns on the auditing functionality.
  7. Click Save and Close.

You can view audit reports by clicking on Navigator > Tools > Audit Reports.

For details see the topic View Audit Reports in the Using Common Features guide.