OTBI
Discussion List
-
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 22 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can Anyone Please help me on Mapping between two subject areasSummary: Hi Team, I'm building a report on OTBI using below subject areas in Oracle Learning Cloud: Workforce Learning - Learning Management Real Time Workforce Learning…
-
Creating a My Reporting tab in HCMSummary: Anyone created a My Reporting tab in HCM with links to dashboards? Content (required): I was recently on a demo using the Vision environment and spotted that a …
-
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 52 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Extract Asset Reporting Data process for tasks from Assets workarea and from Scheduled ProcessesSummary: Auto Submit process "Extract Asset Reporting Data" for tasks from Assets workarea and from Scheduled Processes ESS jobs. Content (required): On following note E…
-
In OTBI Report,we are used Worker assignement Event Real time but "State" column not available ?Summary: Hi Team, In OTBI Report, we are used most of the employee address columns from ( Worker assignement Event Real time) subject area but "State" column not availab…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Union Query - R12 - Career StatementsSummary Report working in R11 but union no longer working in R12Content Hello I have an analysis in R11 that we use to identify the % of staff who have a career statemen…Andrew Braid 99 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Career Development ReportSummary: Trying to create an OTBI report using subject area "Workforce Career Development - Development Goal Overview Real Time". I have no issues adding fields from Dev…
-
How to identify slow moving items in Oracle fusion inventorySummary: Hi All, How to identify slow moving items in Oracle fusion inventory. Is there any report available for slow moving items ? Content (required): Version (include…Mangesh Shastri 472 views 5 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
Enhance Integrations of Deleted Entities Using Configured Reports -22C new featureSummary: Enhance Integrations of Deleted Entities Using Configured Reports- can you let us know based on which table in OAC,? Content (required): Enhance Integrations of…Adarsh Pai 41 views 1 comment 0 points Most recent by Shyam Lakshman-Oracle Product Master Data Management
-
Data Security in BIP ReportTeam, Which is the best way to apply the data security in BIP Report. Example: User belongs to the business unit "BU-A" should be able to see the data of "BU-A" We have …
-
BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ tableSummary: BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ table Content (required): Hi - I am looking for PVO to BICC sync table PJF_PROJECTS_ALL_B_ table. Please help. Version (… -
OTBI Emergency Contact by EmployeeSummary: Dear Community, How can i produce an OTBI report to generate an emergency contact? Can anyone share sample Data Model? We need to use this for Incident Response… -
Scheduled OTBI Report to provide output as on previous dateSummary: Want to schedule OTBI report which triggers output as on previous date as effective date Content (required): When OTBI report is scheduled, we have a requiremen…
-
Drill Down OTBI bar chart report is not working correctly using several columnsSummary: We have a master report which has the following columns: -Positioning Before, Grade Code, Gender, Number of eligible employees. I used a stacked vertical bar ch…bervin13 111 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason…
-
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report …User_2025-02-04-08-51-08-912 40 views 6 comments 0 points Most recent by Roma Pandey Reporting and Analytics for HCM -
OTBI Row to Columns Conversion (FA HCM Rel 9.2)Summary Can we convert rows into columns in Fusion OTBIContent Hi Experts, Please have a look at attached word document and png file s and adviseAshishERPCloud 82 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Any report available to fetch ESS -scheduled pick waveSummary: Any standard report available to fetch scheduled pick wave ESS. Content (required): our client has 5 inventory organizations, and each org has multiple pick wav…
-
Customer Statement Report using OTBI.Summary: I want to modify existing OTBI report for Customer Statement Report for which I have to fetch Commitment cost as Expenses under Expenditure Category. For which …Yashdeep 51 views 4 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for HCM
-
How to create Coupons for DiscountsSummary: We want to offer Coupons to offer discounts to the Customer Content (required): We need to offer Coupons to the customers via Coupon Codes. Once they bring that…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to…Gal Shani 98 views 7 comments 0 points Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 42 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM