Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
BICC extract PVO for FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO
Organization Name
Ricoh Europe PLC
Description
We are using data store "FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO" in BICC for the extraction and we have found duplicate data in primary key column "LOOKUPCODE, LOOKUPTYPE, SETID and VIEWAPPLICATIONID" in the data extraction file and also it is a must needed VO. We have raised SR on same issue with support team for the resolution and they suggested us to use BICC PVO instead of OTBI "FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO" PVO which we are using currently.
Below is the SR# for the reference
3-26379499141.
Kindly assist us to find either any alternate attribute or alternate BICC PVO where it should not contain any duplicate/null values in the primary key attribute.
Use Case and Business Need
This PVO "FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO" is used downstream applications.
Customer wants to use this PVO but we are facing duplicate value issues in the primary key attribute.
We are looking for any alternate key or alternate BICC PVO which should not contain any duplicate/null values in the primary key attribute.
Original Idea Number: 226cf61da1