OTBI
Discussion List
-
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 281 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 223 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 -
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 22 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 231 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 -
Deeps links for payable invoicei want to create a payable report when i click on invoice number open a new windows have the invoice deatils i want a deeps link for the payable infoices -
OTBI excluding the requisitions that are in any other phase other than "Open"I am creating a report using "Recruiting Real Time". The report works fine when i run with the basic attributes like Requisition number, name etc. But as soon as i inclu…Girish Bhatia 21 views 5 comments 1 point Most recent by Alice Gouzy Reporting and Analytics for HCM -
Compensation Business Process Dashboard Access ControlSummary: Business requirment is to restrict access to the seeded Compensation Business Process Dashboard for Line Managers. Identified that Workforce Transaction Analysi…SaiGayatri Chevooru 31 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Role for OTBI reportSummary: Role for OTBI report Content (please ensure you mask any confidential information): Hello experts, we have created a custom role (BI-Abstract) that allows users…Oriana L. 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we get the UCM file download link in BIPHI All, I'd like to build a report with UCM file name and download link. SQL can extract file name and file id. But how can I get the file download link? Thanks in advan… -
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 84 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Need to fetch the amount( Debit - Credit) from XLA tablesSummary: Need to fetch the amount( Debit - Credit) from XLA tables Content (please ensure you mask any confidential information): We developed the query to fetch the amo… -
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the … -
Which are the tables or views behind Quality Action Rules?Summary: Hi Team, We need to know the table/view which are storing the data for Quality Action Rules that are being created from UI. Content (please ensure you mask any … -
what is the BICC VO for Position EFF?Summary: I am trying to find the PVO for extracting Position EFF data and it is not available in the datastores. I could find the Assignment and Job EFF but not Position…Veena Pindiganti 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management -
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 34 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Can we create an OTBI Audit report for work definitionSummary Audit policies setup was enabled for work definition but we didn't find any audit subject area for work definition so can you please confirm whether we can devel…Balamurugan Kulandhaivel 11 views 7 comments 0 points Most recent by Balamurugan Kulandhaivel Manufacturing -
Table for main contact in CRMDear all, Please help, I need to identify the table that brings me the main contact of the CRM module in Oracle Fusion Cloud. Thank you.Jhonattan Diaz 31 views 3 comments 0 points Most recent by Madhuri Cheruku-Support-Oracle Reporting & Analytics for Sales