Reports
Discussion List
-
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
21b Upgrade causes Data Models to FailSummary 21b upgrade has failed testing because of failed to load servlet/dmvalidate errorContent We have had 21b on our 3 test environments and it caused an issue that i… -
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require…
-
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…Vinod Kumar Mohanraj 55 views 1 comment 1 point Most recent by SimonTomey Reporting and Analytics for ERP
-
What's New in 21.06?Summary More cool ways to enhance your Oracle Cloud EPM experience!Content Wow, here we go with another monthly update! First, KScope is rapidly approaching, so be sure … -
Session Timezone in BI PublisherSummary BI publisher not using the timezone from the Account screenContent I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the us… -
While scheduling setup name file based on parameter. Is that possible?Summary While scheduling setup name file based on parameter. Is that possible?Content Hello, is there a chance to have the file name dynamically setup based on parameter…Nicola Petri 19 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 43 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Lease Accounting to comply IFRS 16Content I am keen to understand the functionalities available in Lease Accounting. We have looked at it couple of years ago where we felt it was not fitting to our requi… -
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …User_2025-02-04-08-51-08-912 18 views 1 comment 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Report by Performance Task countSummary Report by Performance Task countContent Currently have a query that reports out current status of performance task: Employee Self Evaluation, Manager Evaluation,…User_2025-01-29-19-46-35-367 77 views 2 comments 0 points Most recent by User_2025-02-06-15-04-02-124 Reporting and Analytics for HCM
-
BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTCSummary Trying to display Report Run Time in User TimeZone, but unable to do itContent The requirement is to display the Date and Time in user Timezone. I came across fe…Rajesh Ravikumar 40 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 84 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Seeded Report Location for Worksheet ExportSummary Looking for seeded report location for Worksheet Export under compensation module.Content Hello Everyone, Does anyone know how to find the seeded report location…
-
BIP Schedule Skip or Resume after Oracle DowntimeSummary BIP Schedule Skip or Resume after Oracle DowntimeContent Hello, Whenever Oracle SaaS is down due to patching or release upgrades, does it pause all the BIP Sched…Vinay Gharge 40 views 0 comments 2 points Most recent by Vinay Gharge Reporting and Analytics for ERP -
Report Job History does not display informationSummary OTBI Report Job HistoryContent OTBI Report Job History displays for a few seconds and then screen mostly vanishes in Production.User_2025-02-10-21-24-50-036 48 views 5 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
Add new permission to existing custom folder in BI CataglogSummary Error when adding new permission to existing custom folder in the BI catalogContent 'Assertion failure: !tAccountId.isEmpty() at line 282 of project/websecurity/…Hannah Dorman 31 views 5 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 38 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying … -
OTBI Multi-Language SupportSummary This white paper explains how OTBI supports multi-language translation, the current limitation and the planned enhancementContent OTBI supports multi-language tr…User720640-Oracle 748 views 3 comments 7 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 714 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
BI Publisher report in Oracle fusion not completing after 21B upgradeSummary BI Publisher report in Oracle fusion not completing after 21B upgradeContent Hello Peers- Posting our experience with one of the BI Publisher reports after upgra…Dhruvjoshi23 67 views 11 comments 2 points Most recent by Dom Galano Reporting and Analytics for ERP -
Can we create replica of changes only extract using BIP reportSummary Can we able to create a replica of changes only Extract using BIP Report. If Yes can you please guide me how we can proceed with this kind of requirements.Conten…Ashish Mangal 208 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Query to fetch data model output in hdl formatContent We are trying to automate HDL process using BI publisher report and Extract. Data model query to include output for Worker dat file with two metadata lines (Assi…Kavya Sreenivasulu 788 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …User_2025-02-05-06-55-02-399 175 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo…