Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 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
Need 'UOM Conversion details' in Subject area
Dan.C
Rank 1 - Community Starter
OTBI dashboard is being developed for CSRs to view the availability of items in different UOMs with their conversion factors
UOM conversions exist in the application, however unable to view inter/intraclass conversion details in OTBI Subject area.
Need to know is there any subject area available to view UOM Conversion between UOMs or any custom query available for this.
Thanks
0
Answers
-
- There is no out-of-the-box OTBI subject area that includes UOM conversion details.
- OTBI primarily focuses on transactional and operational data, not setup/config tables like UOM conversions.
You can try to get it from following tables:
EGO_UOM_CONVERSIONS_B: Holds conversion rates between UOMs.EGO_UOM_CLASSES_B: UOM class info (weight, volume, etc.).EGO_UOM_CLASS_CONVERSIONS_B: Class-level conversions.0
