OTBI Subject Area Attribute Required To Show "WHO" approved a Contract (Doc ID 2160702.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

Customer plans on writing a custom query (using BIP Data Model) to pull contract approval history information, since using the OOTB subject area does not answer the "WHO" (as in, what employee) approved the contract.
Service Contracts are the contracts being reported on.  


QUESTION
--------------------
What table in the underlying database schema holds the APPROVER information (as in, what employee/userID approved) on each Contract approval?
The Subject Area "Enterprise Contracts - Contracts Real Time" is currently being used to get everything else, including WHEN the approvals took place, but they are missing the WHO.


The dimension "Time - Contract Approved Date" shows WHEN it was approved, but they also need to add "WHO" approved at the given times.
Customer has 3 levels of approvals for the contracts they are using. Customer needs the name of the individual who approved the contract at each level.

Customer is already aware that they can view approval history for each contract individually in the UI, but the requirement is for a report showing all contracts' approval history, including who made the approvals and when.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms