My Oracle Support Banner

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

Last updated on APRIL 02, 2019

Applies to:

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


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.  

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.