OTBI report for FND LOOKUPS
Summary: I need to create an OTBI analysis for FND LOOKUPs. Through OTBI Lineage document I found there is a View object for fnd lookup. "FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO". How do I use this view to create my OTBI Analysis?
I have used an option to create Analysis from Option "Create analysis from Simple Logical SQL" and tried with below query.
select Meaning, Description, lookupcode
from
FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO
but I get below error:
Invalid SQL Identifier: FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO.
Issued SQL: select Meaning, Description, lookupcode from FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO .
Please let me know how to create OTBI for lookups.
Content (please ensure you mask any confidential information):