Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Consider contract status Active instead of current version for OTBI Subject Area

User_3E0PF
Rank 1 - Community Starter
Currently by design Project Billing - Funding Real Time subject area will have data pjb_cntrct_proj_links.version_type is 'C' indicates Current version. The Funding metrics is using version_type as ‘C’ only irrespective of status, ideally funding metrics should look for Active contracts and not version type. Due to this we are getting the amount for contracts which are under amendment instead of Active contracts
1
Comments
-
I think this idea should be directed to the OTBI forum. https://community.oracle.com/products/oracleanalytics/categories/otbi
0