OTBI
Discussion List
-
Diversity Report - multiple linesSummary How to report on the latest entry?Content Hi, The report attached works for me apart from 8 employees that are appearing with multiple lines of data. I've spoken…User_2025-02-05-22-44-35-842 125 views 28 comments 1 point Most recent by Cindy Hager Reporting and Analytics for HCM -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S… -
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
Need to know Table names to get the offerings/Learning Initiative details from Learning Module in OrContent Hello All, I am developing a Report from Learning Module in Oracle Fusion HCM. I want to know the below details ,Please guide : 1) In OTBI Report: - i am using W…kanchana venkatasubramanian 1.6K views 3 comments 0 points Most recent by Kiran-HCM-Oracle Taleo Learn
-
Total row should have same color according to the stage respectivelySummary: Total row should have same color based on the stage. Kindly check the screenshot. Content (please ensure you mask any confidential information): Version (includ…Nalsoft Pvt Ltd 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
-
Forecast line additional information doesn't appear in analysisSummary: I have specified some additional information to the Forecast line , and all are BI enabled the issue is that none of them appears in the OTBI analysis meanwhile…
-
-
Need Expense table that stores the itemization detailsContent I am trying to create a BIP report that shows the Itemization data for accommodation expense type like Hotel Room Rate , Hotel Room Tax etc where the daily room …
-
Query to find the email recipients of the scheduled BI ReportsSummary: Hi, Is there any Query to find the recipients of the BI Scheduled Report using Job. If I knew the Report name, I can get this details by Jobs History -> Edit . …Faqir 266 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Keri N 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
Anyone having issues post 24A upgrade with OTBI analysis using the Payables Invoice subject area?We have several reports using the Payables Invoices - Transactions Real Time subject area that are not working as they did before the 24A upgrade. As soon as a filter is…Kristina P - National Heritage Academies 161 views 7 comments 1 point Most recent by Kristina P - National Heritage Academies Payables, Payments & Cash Management -
How to build a OTBI report to track changes across order revisions for a certain attribute?Summary: How to build a OTBI report to track changes across order revisions for a certain attribute? Content (please ensure you mask any confidential information): Versi… -
Need to see BPM Approval Flow in OTBISummary: I am trying to create an OTBI report and would like to see the BPM approval flow from OTBI report. When trying to figure out who approved the requisition, since…mohamed_shahud 51 views 3 comments 0 points Most recent by Logan - HCG Reporting and Analytics for SCM
-
Darrin N 1 view 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I create multiple records in a single payload from Postman?Hi, I can create them one by one as follows, but I get the following error when creating more than one record in a single payload. Can you correct my mistake? Thanks { "…Cansel Karasoy 11 views 2 comments 0 points Most recent by Bianca Culea-Oracle Reporting and Analytics for HCM -
All Active employees that receives no pay or $0 gross pay for any pay periodSummary: There is a requirement where client need a report having list employees receiving no pay or 0$ Gross pay based on previous 26 pay periods. We have a bi-weekly P…Rahul Saini 33 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
PDH: Schedule Product Upload JobSummary: Hi Friends, I want to Inactivate Product Hub item when suppliers associated with those items are inactive. I have created BI report extracting such Item and sta…
-
Oracle fusion database table for Context based DFF segment API namesWe need to extract API names of context based serial numbers DFF attributes from database table. However, we can't figure the appropriate table which holds these details…
-
Is Data numbers on graphs with different colours possible?Can two different colours be applied for value and count in the below graph? Like, Total Number of Opportunities data number should be in one colour and Total Value of O…Nalsoft Pvt Ltd 41 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to make one prompt for two viewsI have created an analysis in which a table and graph are reflecting the same results but in different views, I want to use one prompt to work for both at the same time.…Mohamed Abdelbar 11 views 1 comment 0 points Most recent by Adrian Paun - Oracle-Oracle Project Management
-
unable to access data from Compensation- Salary Details Real time with custom roleWe have created an OTBI report using Compensation - Salary Details Real Time. We have created a custom Role for Human Resource Analyst. With this role we are unable to a…
-
SARTHAK GOSWAMI 11 views 1 comment 0 points Most recent by RakeshOracle-Oracle Supply Chain Planning and Collaboration
-
Query that fetch Calendar Events and LocationSummary: I need a query to link Locations and Calendar Events, but I couldn't figure how to do it. Anyone have any query like these? So far I've accomplish this one but …Matheus Roberto 336 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.Mohammad Borghol 83 views 3 comments 0 points Most recent by Muhammad Asif R Reporting & Analytics for Fusion Service
-
Parag Hiremath 1 view 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…Parag Hiremath 31 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Unable to see active business classification lookups in the OTBISummary: We need to see all our active supplier business classification lookups in the OTBI, But we were able to see few of them, When i check in the metalink found the …