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 ?
@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.
https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24b/oedsc/egpitemclassesb-28547.html
Please post this question in OTBI community for better responses as the query is related to Fusion application tables.
https://community.oracle.com/products/oracleanalytics/categories/otbi
Hello @User_IQZBR,
Is this requirement at the Fusion BIP report end or FDI OAC integrated BIP report end?
Thanks and Regards
Ashish
Fusion BIP report
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
I'm building a dashboard for HR to show the responses from our Employee Exit Questionnaire. For the open-ended questions, rather than just a table list of responses, I'd like to show some kind of AI-generated summary. I'm quite new to using FDI. From my research, it seems like it should be possible, but I've not been able…
In FDI, most of the Hierarchy folder wont populating any data. This is one of the most required data from HR. Can anyone assist me how can I get that data in FDI.
We want a better grasp on what is considered custom data so we can plan ahead and scale properly before we get too big. Fortunately we are no where near the 50gb limit as found using the subject area for custom data but it doesn't tell us other than 'System' where the custom data is coming from. I found documentation here:…
Is there a way to refresh our development environments in OAC with production data? There a lot of developments that didn't make the cut into production and/or was only used for testing and we would like to clean up dashboards, datasets, data flows, etc… Possibly similar to how receive environment refreshes in our Oracle…
Hello Oracle Team, Many organizations currently rely on both Oracle Transactional Business Intelligence (OTBI) and Oracle Fusion Data Intelligence (FDI) for reporting and analytics. While FDI continues to expand its subject area coverage, there are still several OTBI subject areas that are not yet available in FDI. Could…
