OTBI
Discussion List
-
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
SQL Needed for DatesSummary Calculating the later of two dates using SQLContent We are creating an OTBI report to figure out when to discard of hard copies of paperwork. To calculate the sh…Rebekah Gilday 51 views 1 comment 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Table for Attachment of Job RequisitionSummary Table for Attachment of Job RequisitionContent Hi Experts, We have a requirement to fetch the attachment uploaded during Job Requisition. is this possible to ext…Rajeev Nayan 32 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
HCM Last date a vacant post was filledSummary is there a way to report out when a position was last filled which is currently vacantuser1028626 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.Summary An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Exp…User_2025-02-08-08-08-53-292 93 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
We are working on OM to GTM integration, in the process when response is sent from GTM, there is anSummary We are working on OM to GTM integration, in the process when response is sent from GTM, there is an exception error at OM as "User not authorized for DOO_TradeCo…
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…User_2025-02-10-05-51-05-868 77 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
User Roles and UsageContent Hi, I need to develop BI report to understand User System Usage with username and roles attached Please let me know the tables involved ThanksMohammed Rafi 77 views 8 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reporting on HCM/EPM using OTBI/BIPSummary Reporting on HCM/EPM using OTBI/BIPContent Hi Team, Our customer is using Cloud HCM and EPM Cloud. Is there a possibility of creating a report by combining the d…MandeepKGupta 54 views 2 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
To have a filter on OTBI analysis that should filter based on 'As-Of-Date' Prompt that is used in OTSummary Currently As-Of-Date' Prompt is there in the OTBI Dashboard and based on that As-Of-Date' Prompt need to have a filter on OTBI Analysis.Content Hi All, Currently…User_2025-02-08-08-08-53-292 79 views 2 comments 0 points Most recent by User_2025-02-08-08-08-53-292 Reporting and Analytics for HCM
-
YTD Turnover or Rolling 12 Months TurnoverSummary Is it possible to do trends over custom periods of timeContent Hello! I'm using workforce Trends and have been very impressed how it calculates turnover for me a… -
Transfer PricingSummary What's reporting is available for transfer pricing reporting requirements ?Content We have one client who wish to have some reporting to show the Transfer Pricin…
-
Infolets Drilldown Export IssueSummary Not able to export after a drill down on InfoletsContent Hi All, I have created an infolet where I have provided a roster so that when the user clicks on it, it …Vibha Pandey - Oracle 66 views 9 comments 0 points Most recent by User_DB0CL Reporting and Analytics for HCM
-
Customization of Recruit to hire DashboardSummary Customization of Recruit to hire DashboardContent Hi Team, As per business requirements, we are customizing Recruit to hire Dashboard (Seeded Dashboard). We woul…
-
RSUM not giving expected results.Content Hi. I made an OTBI report (check attached image) using the Cash Management - Bank Statements Real Time, Subject Area I want to do a RSUM of each bank account to …User_2025-02-07-06-48-26-537 45 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for SCM
-
Basic General Ledger Transaction Report - Filtered By AccountSummary Does anyone have a robust Basic General Ledger Transaction Report - Filtered By Account that they could shareContent We are due to go live with Oracle Fusion (SA…User_2025-02-11-02-45-23-645 69 views 5 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP
-
How to Open XML in OBIEESummary I want to open XML format file in OBIEEContent I have an XML extension file and want to open/export in OBIEE Version OBIEE 12c -
Unable to download . User does not have sufficient privileges UCMContent I've tried getting a file with the UCM web service: https://:/idcws/GenericSoapPort?WSDL this is my request: UCMFA00755994 -
Report of changes caused by an actionSummary Need a report of attributes that were changed by an action.Content Hello all, I am trying to pull a report of all the fields/attributes that were changed with an…User_2025-02-04-15-06-22-759 71 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI annual leave analysis displaying incorrect Other AdjustmentsSummary In an annual leave analysis, some of the records are pulling through incorrect value for Other AdjustmentsContent We have created an analysis using the below sub…Anna Kryszak 106 views 2 comments 0 points Most recent by Anna Kryszak Reporting and Analytics for HCM -
Reqs over TimeContent I am trying to show the changes in # of openings/openings left to fill/Reqs week over week. Does Recruitment module support this point in time reporting? Has som…Riti Malhotra 32 views 1 comment 0 points Most recent by Sudeep Doke Reporting and Analytics for HCM
-
GL Rates in OTBISummary Need to add FX rate details in Cash Management OTABI report to show the balances in Foreign currencyContent Hi, Need to add FX rate details in Cash Management OT…User_2025-02-10-09-09-51-319 35 views 4 comments 0 points Most recent by User_2025-02-10-09-09-51-319 General Ledger & Intercompany
-
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 131 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How to open Catalog file in OBIEESummary We downloaded a Catalog File and need to upload and use it in OBIEE 12cContent We are working in Oracle Fusion Report and Analytics. We have a Catalog file and n…
-
Environment Upgrades and Maintenance for BI ReportingSummary Working in an enviornment that has not been maintained for a while. Reports are not working well.Content Hi everyone. I'm working in an HCM environment that has …Gina Consalvo 23 views 2 comments 0 points Most recent by Gina Consalvo Reporting and Analytics for HCM -
Metrics for Invoices paid on timeSummary Metrics for invoices paid on timeContent Hi Gurus, Is there any standard report or dashboard that provides metrics for AP invoices paid on time? regards, MakMurali M. 41 views 2 comments 0 points Most recent by User_2025-02-04-11-33-30-197 Payables, Payments & Cash Management
-
Dashboard Prompt values in format YYYY-MM using TO_DATETIMESummary date formatsContent hello, Looking for some suggestion on date format conversions in dashboard prompt, here is my scenario: One of my dasboard has a month prompt…SantoshKumarBhairi 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM