-
How do I report the total contractual working hours for a group of staff over a period of time
Hello all, I have been asked to report on the total number of contractual hours (working Hours) for a group of staff (based on Job Role type) in a department over a period between two dates. Can anyone give me any clues as to; Is this possible in OTBI? If so which subject area? Does anyone have any examples of something…
-
Parameters field not populated in the bursting output excel file
There is a custom report with two different datasets, with Excel template, client requested with to schedule the custom report daily to show the parameters(which we are passing while running) in output file. this working as expected when I am running the report online(manually) but when I am scheduling the report with…
-
Person Costing Details Export Using OTBI Subject Area
Hi Experts, We have a requirement to extract employment and costing details for a person. We have used the following subject areas: Worker Assignment Real Time and Payroll Costing Setup Details Real Time, but they are not returning the correct data. Are these the correct subject areas to extract costing information for a…
-
"Manage Map Data" For OTBI Dashboards and Analyses
How to visualize the OTBI analysis output in "Map" view? After following the steps from https://docs.oracle.com/en/cloud/saas/otbi/otbi-admin/set-maps-dashboards-and-analyses.html , we have first configured the Maps and then created a sample OTBI analysis using “Supplier - Supplier Real Time” Subject area. The result of…
-
In the AOR Subject Area, why is my Last Update Date and Last Updated By values being overwritten?
I am unsure as to why the Last Update Date and Last Updated By values are being overwritten in my OTBI report. My AORs are still assigned correct, it just appears that all AORs updated previous to 08/19/2023 have been overwritten with the values shown below: Last Update Date: 08/19/2023 Last Updated By:…
-
Password Protect Scheduled OTBI Excel Analysis
Summary Question on whether it's possible to add a password to OTBI output Content Hi, I'm looking to add a password to the output produced by OTBI Analysis (excel format) where we use an agent to run the report and deliver to recipients email inboxes. I'm unsure if this is possible / if so how to do it - does anyone know?…
-
Report on Application Prescreen and Disqualification Questions
Is it possible to report out on Prescreen and Disqualification Questions? Anything as simple as the count of applicants who answered a question with 'yes' and how many answered a question with 'no' for a particular question. I believe we can run a report on free text questions using OTBI, but not sure on questions that…
-
I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.
So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query: SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ase_app_role_role_mbr' However when I try to query the table SELECT * FROM ase_app_role_role_mbr I get an error: ORA-00942: table or view does not exist This is my…
-
Oracle Fusion - OTBI Pivot Table - Display as a Percentage
Hi, Looking for some guidance on an OTBI Report using a Data Model sql where the report layout is a Pivot Table and displaying Percentages. Oracle Fusion - Report and Analytics I have created a Data Model sql to analyse Payables Invoice Payments to determine whether they have been paid within N business days from a date.…
-
How can we report on click tracking for all emails sent as part of a recruitment campaign?
Problem Description: Our recruitment campaign includes two emails: Email A: Contains buttons such as "Option A" and "Option B," linked to campaign goals. The goal response labels (e.g., "Option A") are reportable via the “Goal ID” column. Email B: Contains buttons such as "Option X," "Option Y," and "Option Z," but these…
-
Talent Review in OTBI
Good morning, we are fancing an issue in a OTBI report based on the SA "Workforce Talent Review - Talent Review Meeting Real Time" in the Dashboard standard: we're able to view the information regarding the names of meeting but we can't see any information in the Matrix: as for the Succession Plan - SA "Workforce…
-
How to get the list of all custom reports in OTBI
Hello, Would like to know if there is a way to get all the custom reports created in Fusion or possible there is a query to get the list? Thanks!
-
Can we delete and recreate the 'Custom' folder under 'Shared Folders' in OTBI?
We want to clean up the Custom folder contents in Dev environment and recreate it from the production archive. Are there any restrictions or impacts to deleting the 'Custom' folder under 'Shared Folders' in OTBI?
-
Guidance on OTBI Report for Transaction Summary by Region
Hello Experts, We have a requirement to extract transaction summary details by region using an OTBI report. We are utilizing the Human Capital Management - Transaction Administration Real-Time subject area. However, we are unable to retrieve the Region or Country columns. When we attempt to pull the Country column from the…
-
OTBI Usage tracking issue
I am getting issue in OTBI Usage Tracking wherein I had used the above Subject areas - OTBI Usage Tracking , however for some reason its not showing the data for recent weeks. Is their any job or setting that we need to enable for the same ?
-
Migration of FR reports
Hi, I want to use How To Move FR Reports Between Environments (Doc ID 2024010.1) process to migrate FRS reports between environments but I have two doubts I need confirmation on from anyome who has used this. the report details how to migrate reports under /shared folders/custom/financials - my question is if you had a…
-
Configuring Custom Skin & Style in OTBI
Hi, I was wondering if it’s possible to create a custom style based on a specific customer layout? Is there any guideline or documentation available for this? Best regards Lobo
-
Issue with OTBI agents
Hello Oracle Community, A client has been encountering an issue with their OTBI agents, which have been running smoothly for the past few years. Recently, the agents no longer run automatically unless they are logged in. When they open OTBI and manually trigger the agent, it runs perfectly, but unless they are logged in…
-
how to enable dff in otbi report?
Summary: I am trying to enable dff in otbi anlaysis. even though i run the schedule on Import Oracle Fusion Data Extensions for Transactional Business Intelligence dff's didn't enabled? Please let us know the solution for that.. Content (required): Version (include the version you are using, if applicable): Code Snippet…
-
OTBI report built using cross subject area not pulling the data for custom subject area column
Hi, There is an OTBI report built using crm sales standard subject area and the column named "Customer Driver" in the same subject area is pulling incorrect data as the column is using custom object to pull the data . As suggested by oracle we created custom subject area using the custom object columns and most of the…
-
update on subtemplate
Summary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like FusionHistoryRegion and FusionActionLinks . how i call and update on subtemplate FusionHistoryRegion and FusionActionLinks ? Content (required): Version…
-
Monitoring and analyzing HCM workflow email bounces
--Please advise if this post belongs in a different forum-- Summary: Need to monitor and analyze email bounces from HCM OTBI agents & BIP bursting reports. Content (please ensure you mask any confidential information): As we know, bursting emails is possible in BIP, and OTBI provides bursting via agents. Recipients receive…
-
Multiple section parameter on OTBI Dashboard
Hi Team, We have three different sections on one dashboard page and two of section have prompts. We had requirement to add prompt to third section. However after adding the prompt to third section it is not filtering the data of 3rd section but affecting data of second section. Can someone please help me here. Regards Nidhi
-
Logic to show Manager and Employee Comments of Overall Section in Peformance in single row
Currently using Workforce Performan - Performance Rating Real Time Subject area to pull Manager and Employee Comments from Overall Section , its showing in two rows, one row manager comments and another row employee comments. Any hint on the Logic to show Manager and Employee Comments of Overall Section in Peformance in…
-
Fractal Analysis for Public Safety
We recently packaged OAC with our Public Safety SaaS in the LGGIU. Deploying first responders generates large amounts of transactional and geospatial data. We've been receiving requirements in RFPs for Fractal Analysis capabilities. I'm familiar with fractals, but not through practical analytics. Most research I've found…
-
Is it possible to report on Grade Step Progression History?
Hello! We're running into a challenge identifying a field that accurately displays the Grade Step associated with each historical salary change. Subject areas used for this historical report have been "Salary History Details Real Time" and "Workforce Assignment Salary History Real Time". The Grade Step and Grade Ladder…
-
SQL query to get SO Details
Can someone please provide SQL query to get SO, Customer, ship_to, bill_to, delivery_id, invoice_number, payment_terms and other details
-
OTBI Dashboard Action Link Report Caching
Hi all, We have created an OTBI dashboard with multiple performance tiles. These performance tiles contain action links to detail reports that return ~30 columns of specific information. Is there any way to cache the results after the detail report has been generated, so that if you exit back to the dashboard and click the…
-
Is it possible to send the report output as a attachment on email via API? can you please guide us?
Is it possible to send the report output as a attachment on email via API? can you please guide us?
-
Custom Report - It is possible to translate Layout name i an RTF type report
Hello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord and run it, Layout name is display as an tabs. We use Xliff file translation to translate the content of the report and also caption managent export and…
