Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
I need Item_Number with Item_Class and Item_Category in my BIP report
User_IQZBR
Rank 2 - Community Beginner
I need Item_Number with Item_Class and Item_Category in my BIP report,
How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ?
Tagged:
0
Best Answer
-
@User_IQZBR - Please refer the below documentation for table details and it's primary keys which can be used to join to achieve your requirement.
Please post this question in OTBI community for better responses as the query is related to Fusion application tables.
0
Answers
-
Hello @User_IQZBR,
Is this requirement at the Fusion BIP report end or FDI OAC integrated BIP report end?
Thanks and Regards
Ashish
0 -
Fusion BIP report
0
