How to retrieve full update history for a specific Opportunity via OTBI
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)?
0