How can I create a report that tells me how many times an opportunity close date was updated?

You can use the Sales - CRM Historical Pipeline subject area in Oracle Transactional Business Intelligence to track close date updates. You can use this subject area to track revenue and opportunity transitions.

You must run a scheduled process to collect the data. See the Sales - CRM Historical Pipeline subject area documentation for details.

Here's a sample report:

SELECT

  "Sales - CRM Historical Pipeline"."Historical Opportunity"."Effective Date" s_1,

  "Sales - CRM Historical Pipeline"."Opportunity"."Effective Date" s_2,

  "Sales - CRM Historical Pipeline"."Opportunity"."Opportunity Name" s_3,

  "Sales - CRM Historical Pipeline"."Opportunity"."Opportunity Number" s_4,

  "Sales - CRM Historical Pipeline"."Pipeline Snapshot Date"."Pipeline Snapshot Date" s_5,

  "Sales - CRM Historical Pipeline"."Historical Pipeline Facts"."# of Opportunities" s_7,

FROM "Sales - CRM Historical Pipeline"

WHERE ("Opportunity"."Effective Date" <> "Historical Opportunity"."Effective Date")