OTBI
Discussion List
-
Analytics / Dashboards to measure efficiencies from ERPSummary Tracking KPIs using Oracle Analytics to measure efficiencies from ERPContent Are you using any Oracle seeded reports / analytics / dashboards to measure KPIs / e…User_QZ639 54 views 2 comments 0 points Most recent by Sophie RUDENT Reporting and Analytics for ERP -
PO_RELEASES table equivalent in Cloud 20A?Summary Looking for the equivalent table.Content Hi. A coworker needs the table that replaces the Oracle 10g PO_RELEASES in Cloud 20A. Looked the Supply Chain mapping an…User_2025-02-07-06-48-26-537 22 views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
Fiscal year TransactionsSummary Fiscal year TransactionsContent Hi Experts, I am creating OTBI report for one of the columns I need to display Actual cost year wise Ex: Actual cost prior year ,… -
Restricting Access to OTBI Dashboards / Reports not Working as ExpectedSummary Restricting Access to OTBI Dashboards / Reports not Working as ExpectedContent Hi, We use Custom Roles and have configured the following: - Employee Role: No Acc…Karen Waddell 123 views 26 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Cannot show more than one field in Analytics.Summary If I try to use more than one field the data is not displayed. With admin privileged it worked.Content Hi. Recently I just got a proper personal account in our p…User_2025-02-07-06-48-26-537 28 views 7 comments 1 point Most recent by Ahmed Mousa Reporting and Analytics for ERP -
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue …SantoshKumarBhairi 55 views 19 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Role for enabling and editing infoletsSummary Unable to find security role that will allow users to customize, manage, and create new InfoletsContent Hello. What role is needed in BI or in Fusion to allow ac…User_2025-02-04-16-34-29-464 89 views 2 comments 1 point Most recent by User_2025-02-04-16-34-29-464 Product Master Data Management -
Getting the Counts of Learners based on Manager Hierarchy in OTBI AnalysisContent Requirement: When the managers runs the analysis, they should only see their direct reports and counts of the Learners under their Direct Reports. When they dril…User_2025-02-05-22-01-45-942 35 views 4 comments 0 points Most recent by User_2025-02-05-22-01-45-942 Taleo Learn -
OTBI Report how to only have the last valueSummary I have a report for asset that have cost and Net book value, but i have all the different net book value instead of only having the last net book valueContent He…Francis Thériault 59 views 5 comments 0 points Most recent by Muhammad Hamza Hanif Reporting and Analytics for ERP -
Changed username and now user cannot login to OTBISummary Changed username and now user cannot login to OTBIContent Hello, We had to change the username for an existing user and now the user is unable to login to OTBI. …User_2025-02-04-15-06-22-759 157 views 8 comments 2 points Most recent by Robert Fighiroae-Oracle Reporting and Analytics for HCM -
Prompt - put conditions on promptSummary I use Display Name and want to filter only employeesContent Hi, I need to limit the prompt on "Display name" to active employees only. I added a SQL statement bu…Nicola Petri 47 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM -
Creating OTBI View Only Role for Porcurement Subject AreasSummary Document with steps to create custom role that grants access to Procurement OTBI with out havig to setup users as Procurement Agents and assign data accessConten… -
Create Infolet through BI analysis to get PO count created for the daySummary Need to create an analysis to get today's PO created count based on userContent I created a analysis to get the buyer wise PO count. But it gives the as at date … -
Data security policies to access project data in Procurement OTBISummary what are the minimum data security policies and privileges needed to view project data in Procurement OTBIContent Created custom role as per attached and users c… -
Capturing Item Images in OTBISummary Capturing Item Images in OTBIContent Hello, We would like to capture the item images on OTBI report. We tried using Product Management - Source System Item Real …Anand Dhinakaran 33 views 8 comments 0 points Most recent by Anand Dhinakaran Product Master Data Management -
Automatic Association of Meter to an AssetSummary Automatic Association of Meter to an AssetContent Hi Is there any REST/FBDI loader to associate a meter to an Asset ? We are implementing Meter based strategies … -
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…User_2025-02-05-22-44-35-842 30 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Find parent value in CoA hierarchy for balancing segment in OTBIContent As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracl…MaartenDIF 143 views 8 comments 1 point Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Nice look and feel outcome when NO result in OTBISummary How to display a nice page in case of NO result in OTBIContent Hi, do you know if there is some way to display a courtesy page if no result in a OTBI analysis? T…Nicola Petri 45 views 4 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…Clifford Trett 87 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
OTBI CapabilitiesSummary OTBI CapabilitiesContent Hi Experts, I hope some of you will agree that although OTBI has advanced features and capabilities still some consultants prefer to use…AshishERPCloud 317 views 5 comments 4 points Most recent by Kalyani Koylada Reporting and Analytics for HCM -
Awaiting BillingSummary Order stuck in Awaiting BillingContent Hello All, I have one order stuck in Awaiting Billing and upon running : Import Autoinvoice, this error is generated :Revi…User_2025-02-05-12-20-44-163 42 views 3 comments 0 points Most recent by Shyam Patel Order Management -
Need to display Transferred CIP cost, Asset Placed in service cost in OTBI reportSummary But I could see only Rounded Transferred CIP cost or Unrounded Transferred CIP cost onlyContent Hi Can anyone help me with my question? Need to display Transferr… -
Question: In Demand Management, How to use Moving_Total Function to exclude past one month while perSummary Question: In Demand Management, How to use Moving_Total Function to exclude past one month while performing summationContent Hi Team, We have an requirement to d…Ramesh Choudhary 31 views 1 comment 0 points Most recent by Nagappan Periakaruppan Supply Chain Planning and Collaboration -
New Hires in last 90 daysSummary New Hres reportContent Hi, I've found some examples of new hires report where the TIMESTAMP formula is -1 to show hire in the last year. How do I modify it to sh…User_2025-02-05-22-44-35-842 55 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 54 views 8 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for HCM