OTBI
Discussion List
-
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 233 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 33 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 23 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… -
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.…Chris Diltz-Oracle 11 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
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 71 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 13 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 36 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 32 views 3 comments 0 points Most recent by Madhuri Cheruku-Support-Oracle Reporting & Analytics for Sales -
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model… -
Table used for Project Financial ManagementSummary: Can i please know the table we are storing Project Management details in. Content (please ensure you mask any confidential information): Navigator > Project Man…Priyansha Singh 1 view 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont… -
How to extract ship to customer and ship to site name?Hi, How to extract ship to customer and ship to site in a receivables table? We only found id. Thanks, Regards -
Model Profile vs Person Profile Competency Gap AnalysisContent Hi All, Wondering if anyone had a great analysis comparing the competency minimum proficiency level identified in a model profile to the assessed competency prof…Lauren Owen 143 views 3 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM