OTBI
Discussion List
-
How to report cancelled work relationship person details in OTBISummary How to report cancelled work relationship person details in OTBIContent Hi Team, We have cancelled work relationship for some employees we wrongly loaded in wron…Pol Reddy 223 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font … -
OTBI Dashboard Prompt with Presentation Variable - dependentSummary: Trying to create multiple prompts using presentation variable. goal is that prompt 2 will be dependent to filter values from prompt1 but using the variables. Is… -
Percent of total Responses from Workforce Management - Checklist Real TimeSummary: I am trying to get an OTBI Analysis to return the Count of Responses to the Response Answers to specific Checklist Questions. In the example shown below I would… -
Scheduling OTBI reports to roles /user groups- How does access work ?Summary: If we have a simple headcount report built using Assignment real time subject area, and it is scheduled to a role (meaning multiple users with the same role but…Swapna Govind 1 view 2 comments 0 points Most recent by Swapna Govind Reporting and Analytics for HCM
-
OTBI – Calculate Percentage of Responses per Question in Learning Evaluation SurveysHi everyone, I'm building an analysis in OTBI using the Workforce Learning – Learning Records Real Time subject area, and I’m looking to better understand how learners r… -
There are random end users that are unable to view the pdf when they print certificate?Summary: We have random end users that are unable to view the pdf when they print the certificate for a completed course; however, when they send the pdf link to other u… -
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …HCM_Dot 131 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
DFF deployed & processed correctly however entered data not showing in OTBISummary: Hi! DFF deployed & processed correctly however entered data not showing in OTBI. Does anyone know why data would not show up? We created new fields and the only…Jenny Truong-Scognamiglio 41 views 1 comment 0 points Most recent by Jenny Truong-Scognamiglio Learning -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 492 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to report on budget vs. actuals in OTBISummary: How to report on General Ledger budget vs. actuals in OTBI Content (required): How do I report on General Ledger Budget vs. actuals in General Ledger Balances R…
-
How to transfer location of Install based assets in maintenance to be same as financial fixed assetsSummary: we have requirment from the customer to mass change the location of fixed assets and as sequential this change should affect the maintenance assets Content (ple… -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 25D…Ramamurthy Shankarachetty-Oracle 17.9K views 54 comments 44 points Most recent by Kirk Li Reporting and Analytics for SCM
-
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…User_2025-02-05-22-11-22-331 1.1K views 6 comments 5 points Most recent by otavio.teixeira Reporting and Analytics for ERP -
New Joinee's are not being enrolled into the learning modules through initiativeSummary: We have observed that for the past four days, new joiners are not being enrolled into the learning modules through the assigned learning initiative. However, th…
-
Require report to verify the transaction against the supplierSummary: We need to identify the list of suppliers, For the purpose of cleansing and de activating the suppliers which does not have any transactions (PR/PO, Receipt, In…
-
Customizing Maintenance Dashboard – Infolet with Drill‑Through to OTBI Work OrdersHello Team, We have a requirement to enhance our Maintenance Dashboard with a custom OTBI infolet. The requirements are: 1.Team/Resource Work Order Status Tracking Displ…
-
Looking for a couple sample reports using the Subject - Learning Records Real TimeSummary: Hi there! All of our Learning Reports have been created using the Subject Learning Management Real Time. I understand this Subject will be going away at some po…NCourt 41 views 2 comments 3 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Learning -
Are there any sample obti analysis reports for assigning learning?Summary: I'm on the Reports and Analytics>HCM> I have looked at the HCM Reports sharing center and the Fusion OBTI HCM Analysis with no success cause filter doesn't work…Audra Edwards 71 views 5 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Learning
-
OTBI column formula help - change days to working daysIn my report I need the following column formula to calculate 5 working days (not 5 days as it does now) and leave out Saturdays and Sundays. Any help would be great. CA…
-
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…Marilyn O 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can we display different Infolet tiles based on each page?Summary: Is it possible to display difference Infolet tiles based on page (e.g., Me, My Team, My Client Info)? Can EL expressions solve this problem? If so, please provi…Nipon 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to know the Reservation quantity from which sub inventory and locatorSummary: Business use case is to know the reserved quantities that is in specific sub inventory and locator. Currently for any sales order reservation, sub inventory and… -
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat…
-
Assigning Learners Automatically Based on OTBI ReportSummary Looking for a way to have an OTBI report automatically assign new learners to Learning InitiativeContent Hello Team. I was curious if there was a way to have new…
-
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Column for reject/return reason for PO/ Requisition in OTBI Subject AreasSummary: Column for reject/return reason for PO/ Requisition in OTBI Subject Areas Content (please ensure you mask any confidential information): Hi Team, We are searchi…Nidhi Chhajed 1 view 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
Where can we find the columns in OTBI for Work Order Notes from new My Maintenance Work?Currently with the Dispatch List, our technicians enter the completion notes when completing an operation. These notes are reviewed at the end of the week by a superviso…