Reports
Discussion List
-
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 57 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 155 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a formula row for Grand Total in Financial Reporting Web StudioContent Hello everyone, Need some help with a report build in FRWS. We have a report where we have on Pages the children of entity, in this way we get, let say a P&L for… -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 284 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
Resignation Submitted dateContent Hi All, We had a predefined report which use to give Resignation Submission date along with the Employee last working date. Few days back the report stopped work…Kiran Kancherla 38 views 4 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Raw data extraction from Oracle Fusion to Datalake/SFTP serverSummary Exporting data from Oracle Fusion to SFTP Server - Unable to handle systematic deletesContent Hi All, We have a requirement where we need to push raw data into a…Kalyan Reddy 58 views 1 comment 0 points Most recent by User_2025-01-28-08-43-27-760 Reporting and Analytics for ERP
-
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 8 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust… -
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 39 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Table name and column for Accounting Period of Project CostSummary Table name and column for Accounting Period of Project CostContent Hi Experts, What could be Table name and column for Accounting Period of Project Cost (under M…
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 32 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 109 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 37 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Archive Versions vs Archive ScenariosContent I was talking with an old colleague about archive version/scenarios and wanted to get a broader opinion. The requirement is to archive off the forecast every mon… -
What's New in 20.12?Summary Wrap-up for a Strange YearContent Well, this concludes a strange year (to say the least) but one with lots of new features. We've snuck several more for this mon…Mark Rinaldi-Oracle 244 views 5 comments 6 points Most recent by User_2025-02-08-03-53-41-891 Planning -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor…Dena Swanson 37 views 4 comments 0 points Most recent by RaviThejaDarbha Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari…Vamshi Mohan 69 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 102 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…User_2025-02-10-05-51-05-868 18 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - …User_2025-02-06-08-26-40-838 98 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 21 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM
-
Locate First Names that begin with Blank characterSummary Locate First Names that begin with Blank characterContent Can anyone please advise on the proper Function or CASE statement to use in an OTBI Analysis to locate …