OTBI
Discussion List
-
Configure Business UnitSummary Configure Business UnitContent Is there any white paper on how to configure /add a new Business Unit to Purchasing and Payables? -
When bursting a BI report gives error NearSummary I am trying to bursting a BI report with data source as Oracle BI EE by converting OTBI to BI query it is giving error [nQSError: 27002] NearNeha Nahar 31 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Deliver OTBI report to SFTPContent I could see there is limitation in sending OTBI report output to SFTP folder. Is there any workaround that is being followed or is it just via BIP report?Sowdha Murugan 93 views 3 comments 2 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
AP Trial Balance with liability account in aging bucketsSummary AP Trial Balance with liability account in aging bucketsContent The Finance team would like an AP Trial Balance for all invoices - including un-validated invoice…User_2025-02-04-18-52-28-503 33 views 1 comment 0 points Most recent by Waleed Fetoh Payables, Payments & Cash Management -
BIP Data Sources accessSummary BIP Data Sources accessContent Hi Experts, Does anybody know if it is possible to restrict access to the Data Sources in the BIP data model UI? I appreciate any …Volodymyr Faranosov 43 views 7 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Project Costing - Committed CostSummary Project Costing - Committed CostContent Project Costing - Committed Cost - 1. Once a requisition is raised it is reflected under Committed Cost. 2. Once the Purc…
-
Need an OTBI report/field that shows Mapping set for natural account by procurement categoryContent Hi, I would like to see if any of the OTBI subject areas for Procurement have a field that shows the natural account mapped by procurement category? On Procureme…Vanessa Garma-Oracle 82 views 3 comments 1 point Most recent by Vaishnavi Aryasomayajula-Oracle Subledger Accounting & Accounting Hub
-
How to embed hyperlink from OTBI report - data column field into Apps Composer CRM custom formSummary I need the ability to drill into some Custom App Composer CRM data from a Dashboard Report on that data set. Non Standard Oracle Cloud App FormsContent I need th…User_2025-01-30-01-01-15-242 33 views 2 comments 0 points Most recent by User_2025-01-30-01-01-15-242 Reporting & Analytics for Sales
-
Employees with Leave Status within a Specific MonthSummary Employees with Leave Status within a Specific MonthContent We are tracking leaves through Manage Employment using Action and Assignment Status. Our HRBPs would l…Kathleen Nguyen 23 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el…Chiara Arcidiacono 26 views 7 comments 1 point Most recent by SimonTomey Reporting and Analytics for HCM -
Payroll-Calculation Cards Real Time OTBI SA issueSummary Payroll-Calculation Cards Real Time OTBI SA issueContent HI, We have a issue with "Payroll-Calculation Cards Real Time" SA. I am picking the Calculation Card :'S… -
SQL Expression on column filter in OTBI reportContent Created a headcount report and looking for a SQL Expression for a column filter so I can generate the report based on current or system date employee start dates…User_2025-02-11-16-17-40-645 2.5K views 4 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 931 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM
-
OTBI report for enrollment messed up - ConsequencesContent Hi there, with the 21B update I see differences in the columns in the Subject Area "Learning Records Real Time". I have to redo the reports. For instance, I get … -
How to Add Sorting to Bar Graph ResultsContent When I create a bar graph using "Facts - Requisition Counts"."Number of Job Requisitions Currently Open" by "Job Requisition - Hiring Team"."Recruiter Full Name"… -
Inventory Turns ReportContent Team, In Inventory Turns Report, the 'Days sale of Inventory' formulae is '(start date - end date) / inventory turns' as per below document https://www.oracle.co… -
HCM Quarterly Changes Impact on Reporting and AnalyticsSummary HCM Quarterly Changes Impact on Reporting and AnalyticsContent Hi all, Is there any other references for Quarterly changes on HCM that affects reporting? I have …Raymund Jerome 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Manager name from Assignment Manager (Unsecured) does not work with event countsContent When I add Manager name from Assignment Manager (Unsecured), the hire/ termination count reduces significantly. How does the Assignment Manager (Unsecured) work?…User_2025-02-10-08-27-16-805 45 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Drill down and action link opening an email to the user - OLCContent Hi there, I have a table with users' names or email addresses. Can I add an action link with a drill down that will open an email to the user? Thanks BobbyBobby Jourdan 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to sort Age BinsSummary Sorting Age Bins in a ChartContent Hello, I am trying to get my Age Bands to sort in numeric order but the Bin Labels with text keep defaulting to the end of the…Rebekah Gilday 49 views 5 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Current status is "Interim"Summary Trying to report on all employees who are an interim assignmentContent I'm trying to report on all employees who are currently on an "Interim". Using the HR Acti…
-
Tracking new line managersSummary Identify line managers who have managed employees less than a yearContent Is there a way to identify line managers who have managed employees less than a year? W… -
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…Valerio Curzi 25 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 21 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
How to mask data values?Summary In OTBI, how to display an * instead of a number or percentage where the results might identify peopleContent In OTBI I would like to mask identifiable data such…Mnrussel-Oracle 71 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Job History Page in OTBI IssueSummary Report Job History Page in OTBI Issue is BlankContent Is anyone else experiencing an issue accessing the Report Job History Page? I assume a browser issue, but h…