How to retrieve full update history for a specific Opportunity via OTBI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to retrieve full update history for a specific Opportunity via OTBI

edited Aug 26, 2025 2:04AM in Reporting & Analytics for Sales 5 comments

The business requirement is to retrieve all records/updates (audit history) related to a specific Opportunity in Oracle Sales Cloud, using OTBI.

Required fields to be retrieved:

  • OPTY_ID
  • LAST_UPDATE_DATE
  • PRTAPPROVALSTAGE_C
  • PRT_OPPTYBUSINESSTYPE_C
  • CURR_STG_ID

Business Need:
We need to analyze and report on the full modification history of an Opportunity without relying on Support to provide the backend logs. Currently, we are unable to retrieve the entire update history directly via OTBI.

Request for Guidance:

  • Is there a subject area in OTBI that provides access to Opportunity audit/log information (changes made over time)?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!