Reports
Discussion List
-
Problem with aggregating percentage values against custom created ScenarioContent Hello guys, We have an issue with newly added custom Scenario member (Actual vs SPLY %). This member is supposed to calculate the % of Difference of Actual scena… -
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
Dimension Update failing when using Excel TemplateSummary Dimension Update failing when using Excel TemplateContent Hi- I have a requirement to add around 1700 new cost centres in PCMCS. I downloaded the dimension file …Amit Agarwal-158816 30 views 8 comments 1 point Most recent by Amit Agarwal-158816 Profitability and Cost Management -
BI report to extract Status information for Absence ManagementSummary Any pre build report to extract absence type and status information for Absence Management?Content Hello, If anyone has any pre build report/query to fetch the d…
-
Need help on Logical SQLSummary Need help on Logical SQLContent Hi , I have added three columns to existing logical sql OTBI, After adding the three new fields report format has changed, Can an…Reddykrishna Chidella-Oracle 50 views 4 comments 1 point Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Does valid intersections in planning works in Reports POVContent We have a requirement in a report where we need to control the member list in one POV dimension based on the POV selection in the other. I believe it is not poss… -
OBIEE SQL and Listagg functionSummary Need to display a list of degrees and certifications in a list for a reportContent Hi all, I am trying to produce a list of certifications and degrees for each e…User_2025-02-04-08-51-08-912 54 views 2 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
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 42 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 39 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 …