OTBI
Discussion List
-
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 714 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Busting OTBI Myths - NOT INContent Myth: OTBI can't give me a list of workers without goals (or absences or ...) There are a few ways to perform a "NOT IN" query. The easiest and most performant i…Julian Challenger-Oracle 103 views 1 comment 2 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Filter - AnalysisSummary Filter - Leads created in the current weekContent Hi all, Do you know how to add a filter to an analysis (OTBI) so that it only brings the Leads created in the c…Hernan Imas 18 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Procurement Master Content DocumentSummary This document will allow you to find Oracle Procurement cloud-related KM notes which are not only distributed throughout the document from flow basis but also ar…ROHIT.R-Support-Oracle 174 views 5 comments 3 points Most recent by Saravanan Subbaiya Self Service Procurement -
How to know total inventory consumption during the period along with quantity, unit cost and amount.Summary How to know the total consumption during the period Item wise or Inventory Org wise along with quantity, unit cost and consumption amount.Content Hi Team We want…
-
How can i get DFF field in the Formula based Depreciation Methods?Summary How can i get DFF field in the Formula based Depreciation Methods?Content Hi Experts, I am trying to derive the depreciation rate based on the Descriptive Flexfi…User_2025-02-06-12-01-21-534 51 views 2 comments 0 points Most recent by Saipriya Vaidyanaathan-Oracle Assets -
Use of Variable prompt in OTBIContent Hi Experts, Greetings of the day!! Can someone please let me know the use of variable prompts in OTBI analysis. Regards, Divya Version 21ADivya Kollipara 47 views 2 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Is it possible to use bold characters and underlined text in a burst notification?Content Hi, We have a requirement to send out a burst report to all our PO owners about how much of it is invoiced, funds remained on POs etc. The Procurement team gave …
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …User_2025-02-05-06-55-02-399 175 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re…Mohit Gupta-45440 346 views 26 comments 1 point Most recent by User_2025-02-11-15-16-39-434 Reporting and Analytics for HCM -
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…User_2025-02-06-09-29-18-902 179 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo…
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 41 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
R13-SQL Supplier informationSummary R13-SQL Supplier informationContent Hello : I was wondering if you can share with me any SQL to get the Supplier information. I have the following one but it is …gabriel kinovisques-163562 46 views 3 comments 2 points Most recent by gabriel kinovisques-163562 Payables, Payments & Cash Management
-
OTBI Custom Dashboard Not Populating CorrectlySummary Admin and User views are completely differentContent Good morning everyone! I wanted to reach out and see if anyone has experienced issues with viewing data in a…User_2025-02-10-17-54-21-557 45 views 4 comments 1 point Most recent by User_2025-02-10-17-54-21-557 Expenses
-
Report: Project Number is '000000' for most of projects in report.Summary Report: Project Number is '000000' for most of projects in report.Content Hi All, Report: Project Number is '000000' for most of the projects in the report. Vers…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…tiffnyc 65 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Inventory Transactions short cut keysSummary which short cut keys can be used to accelerate the data entryContent Dear, I am looking for a shortcut key on the inventory transaction screen, for example, whil… -
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Round a summed total?Summary Round a summed total?Content I have an OTBI analysis and on a column it does the aggregate sum - so summing each value based on how I have it grouped in the resu…Cathy 23 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Date prompt from and to dateContent Hi Team, I am using a date prompt between from and to date. Issue is that during negative testing - user is trying to check if the system gives error for From da…Shikha Agarwal 32 views 4 comments 2 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Termination analysis does not bring all records when dynamic dates are usedSummary When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically…User_2025-02-10-17-54-52-878 47 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. …Arti P 30 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 95 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM