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
Hi Experts, We are trying to create a report using OTBI to extract the PO line amount - Do we have the column which extracts the PO line amount out of the box available under subject area: Procurement-Purchasing Real Time or do we need to calculate it using the formula - PO Line Amount = Ordered Quantity × Unit Price Any…
Under the Workforce - Absence Management subject area, the Total Duration of Absence (Days) field does not return data for Life Leave and Annual Leave Half Pay. As an alternative, I used the Absence Duration field, which successfully captures all leave types. However, it does not correctly retrieve leave records that span…
Hello Experts, I am having issue while working with HCM - Workforce Core in which I am using Person Number and Department Name. The value getting is not in line with the data in my fusion environment. Please guide what I am missing. 26C.
Team, I heard we can use the AI assistance for generating the Start model in the SME. So how to enable this feature as our instances are already in 26.R2 version. Using this blog for reference: Guided Star Schema Generation: Bringing AI-Assisted Design to Semantic Model Customization | analytics Regards, Guru
Hi everyone, I'm a functional consultant. Looking to learn about Fusion Data Intelligence. Where can I start with? I want t learn everything about it. Would be grateful if someone could guide me. Thanks. Regards, Fasahat Ali
