OTBI
Discussion List
-
OTBI report for FND LOOKUPSSummary: I need to create an OTBI analysis for FND LOOKUPs. Through OTBI Lineage document I found there is a View object for fnd lookup. "FscmTopModelAM.AnalyticsService… -
Issue getting most recent/max date for "Offer Extended" Recruiting EventSummary I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows retu…User_2025-02-04-23-22-13-274 113 views 9 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM -
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal…stusc 54 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Alternative to Oracle BI Mobile appSummary: Earlier oracle provided the ability to scale the report output to fit the screen size of the device using the Oracle BI Mobile app. However, the app is now in d…Hitesh Khandelwal 11 views 2 comments 0 points Most recent by Hitesh Khandelwal Reporting and Analytics for ERP
-
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
Setting some dashboard analytics to a date in a hidden dashboard prompt (e.g. 'Previous Year')Content This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM …Julian Challenger-Oracle 115 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Positions report with no open requisitions or current incumbentsHello, Currently we are looking for a report regarding Position details where there is no Open requisition linked or no current incumbents mapped. Many thanks,Bala Krishna B 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not getting correct count in the termination count column.Summary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…Shreya Datir 61 views 13 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Schedule a report with a hardcoded parameter for a parameterized report.Summary: I have a report with a parameter for start and end dates. Now, the user wants to have a scheduled report with hardcoded values, like April 1, 2024, as the start…
-
OTBI Caclulation Issue [nQSError: 22025] Function Cast is called with an incompatible type. (HY000)Summary: Hi everyone, I'm finding troubles when summing 2 columns in OTBI. Content (please ensure you mask any confidential information): Hi everyone, I'm finding troubl…Vasco 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 35 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Number of active/Inactive users in Oracle HCMSummary: Hi All, Do we have any standard report to see the number of active/inactive users in the system? If someone has this report please share. Thank you.Saher 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Report on approval workflow conditions and actionsSummary: Requiring to report on requisition and PO approval workflow rules setup (conditions and actions) Content (required): Is there a delivered or would anyone be wil…Bernadette Dorris 46 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM
-
Security access to view data in Learn custom reportsSummary: Hi Experts, We created a learn custom role and secured it using person security AoR with scope as Legal Employer. When the user with this role, tries to run the… -
report that lists reportSummary: is there a way to create a report that lists all of the names of OTBI reports in the catalog? Content (please ensure you mask any confidential information): Ver…
-
OTBI Presentation Variable Date Prompt no Longer Functions ProperlySummary: Recently all our absence reports within our Production environment that use a Date Presentation variable as a prompt have stopped producing the required results…Kevin Robertson 52 views 15 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "Summary Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "All Prompts" selectedContent Hi , I am facing a issue. I have …User_MC37Q 125 views 13 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
How to display month names instead of numeric values in OTBI analysisSummary: I have created a graph through OTBI analysis. But month is coming as numeric values. How to show month name ? Content (please ensure you mask any confidential i…Shreya Datir 42 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to add Two Subject Areas in one Analysis in OTBISummary: How to add Two Subject Areas in one Analysis in OTBI Content (required): How to add Two Subject Areas in one Analysis in OTBI Version (include the version you a…Srinivasa Rao Pavuluri 42 views 5 comments 0 points Most recent by Faizhan.Tanvir Product Master Data Management
-
Inability to Retrieve "Available to Transact" Quantities from Table/ViewSummary: The inability to directly retrieve the "Available to Transact" quantity from our database tables or views significantly hampers our reporting capabilities. Accu…mohamed essa 11 views 1 comment 0 points Most recent by Bogdan Barbulescu-Oracle Inventory Management -
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …JDCal 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 41 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management
-
Enable to get the output from the "Person Profile Real Time” subject areaSummary: Enable to get the output from the "Person Profile Real Time” subject area Content (please ensure you mask any confidential information): Hi experts, we want to … -
Is it possible to show/identify the job family for the Line Manager in OTBI Analysis ReportAs per business requirement I am creating a OTBI Analysis report to identify/highlight job family (Thru Conditional Formatting) for direct manager. For example, if a Dir… -
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 274 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
Overdue count for 'Not Passed' courses is '0' in OTBISummary: Hi, The overdue count for Not passed courses is 0 in OTBI. When selecting learners that have an overdue date for course completion and have not passed the cours…
-
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…