OTBI
Discussion List
-
Scheduled OTBI reports- What happens when person who scheduled reports gets terminatedMy team has been scheduling reports for end users using their IDs (instead of a generic/master account). I was wondering what happens to the scheduler agents when the pe… -
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge… -
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 776 views 12 comments 11 points Most recent by Melissa Goodrich Reporting and Analytics for ERP -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 149 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM -
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
How to get the Pick Slip Number associated with Sales Order in Oracle Fusion?Hi, I have a requirement to write a query to get the Pick Slip Number associated with the Sales order. Is there any table in Oracle Fusion which stores the association o…
-
Generate candidate list for incomplete submissionsSummary: how do i generate a list of candidates that did not complete their application? Content (required): Hi we are in process of migrating from Taleo to ORC 22A and …MarkHodges 41 views 3 comments 0 points Most recent by Harika.Viswanatham Reporting and Analytics for HCM -
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI Analysis to get a value from the latest budget versionI have created an OTBI analysis that shows values from the original budget version , but I want to compare it with the same values of the latest budget version, but when…
-
How to schedule an OTBI report to run for a subset of the full OTBI report?Summary: I have an OTBI report I created that lists all active Projects, the assigned project managers and total budgeted amount. The full report with all project manger… -
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Approval Date of the Approved Absence in Workforce Management - Absence Real TimeI'm currently creating a dashboard for Absence Management. Why there are Approved Absence, but the Approval Date is Null?Welsey 11 views 2 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for HCM -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Termination ReportSummary: We are new to Oracle and looking to build a simple termination report that returns all terminated workers. Current problem we have is that it's returning termin…Darrin N 271 views 14 comments 0 points Most recent by Manmohan Mohapatra-Oracle Reporting and Analytics for HCM
-
How to enter a Column Group in a OTBI reportSummary: How to enter a Column Group in a OTBI report Content (please ensure you mask any confidential information): Hi, we would like to create a new OTBI report, which…Barile Alberto 196 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI AP invoice report for approver, approval action date, payment dateSummary: We tried to build one, but the payment date is coming in incorrectly where it says it was paid before the invoice was even created. Anyone successfully build su…Alex Glose 1 view 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
SCROM ReportSummary: Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. We are trying to create a report to take out the …Teja Arepalle 31 views 2 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
-
BPM Notification audit informationHi Team We have a requirement to get the audit log for BPM notifications. If anybody worked on similar requirement, please share the solution/document. Thanks Umang SainiSaini 21 views 3 comments 0 points Most recent by Parag Hiremath Payables, Payments & Cash Management
-
Not able to fetch Recommended Courses in the Both OTBI & BI ReportsSummary: Hi Everyone, We have created reports in the BI and OTBI to fetch all the assigned courses of Required, recommended, and Voluntary. However, we are not able to s… -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 232 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Number of Analyses in one Learning Initiative?Summary: I have two OTBI reports that I need to add to a course as an initiative. My question is, can I add both reports within a single initiative? The system seems to … -
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w…G. Class-Peters 31 views 6 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…User_2025-02-12-02-03-48-970 41 views 9 comments 0 points Most recent by User_ZKDAR Reporting and Analytics for HCM -
Logic to know the Insert/Update/Delete as Audit Action in Audit Salary Report for HCMWe want to build an HCM audit report in OTBI. HRDirect needs an audit report to see when a salary change was added, updated or removed an individual. Filters: Employee I…Mukesh Bulla 51 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM