OTBI
Discussion List
-
Reporting on employment contractsSummary New hires are still showing as pending workers in Employment Contracts Real Time subject area.Content I'm trying to write a report that will show all employees w… -
Time entry Third Party System integration with oracle PPMContent Hi All, we are planning to intergeate our third party time entry system with oracle project costing and for project resource management dashboard to view the act…User_2025-02-06-13-19-17-977 37 views 2 comments 0 points Most recent by User_2025-02-06-13-19-17-977 Project Management -
I can't join suppliers tables and ZX tables through the withholding Group IDSummary I have a retention group code. Do you know how do I get to the PERCENTAGE RATES by query,Content I have a retention group code. Do you know how do I get to the P…Max Lopez-Oracle 36 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Using analysis as a sub query - many values for the IN predicate errorSummary Using analysis as a sub query - many values for the IN predicate errorContent Hi, Using OTBI analysis as a sub query for a field for the another analysis . While…Phani S-Oracle 82 views 4 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
Briefing BookSummary Customization in content of Briefing BookContent Hello, We have created a Briefing book with combination of different analysis and schedule it. Struggling with b…User_2025-02-05-07-43-29-505 66 views 4 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM
-
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudNageshwaran1 20 views 1 comment 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Add note text of an invoice in OTBI/BIPSummary Add note text of an invoice in OTBI/BIPContent Hello, My need is the following : create a report which will show the comments of invoice which are rejected This …Antoine.Kaiber 96 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
EBS to Fusion Migration - Impact on BI ReportingSummary Re-map EBS interfaces with FusionContent We have build DWH from Oracle EBS which has several reports on top of it. We are migrating to fusion and want to retain …Naeem Khan 48 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
General BIP Report AssistanceSummary I have a series of questions about a BIP report I am trying to developContent Hi all, I just have a series of questions about BIP reports/Dashboards when embeddi…CIT Shane 65 views 9 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Unable to report on secret and closed communitiesSummary Reporting and dashboards with community informationContent Hello It appears we cannot report on closed communities unless the user running the report is the owne…
-
Recover Deleted Report or FolderSummary How can I recover a deleted report or folder in any environment after deletion?Content Hi all, I would like to know if there is a recover option when a report or…User_2025-02-05-05-51-12-049 78 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
Emergency Contact Details Report - Required Duty/Data RoleContent Hi All, We have created Emergency Contact Details Report from Person Subject Area to support our Business Continouity agenda (attached). We have two custom roles… -
Workforce Management - Position Real Time - Missing Assignment CategorySummary Unable to find Assignment Category field in Position Real Time subject AreaContent When creating a position, we are using 3 fields on the setup - Assignment Cate… -
Need past 8 years historical data based on a effective date-OTBI analysisSummary Need past 8 years historical data(Counts based on their color) based on a effective date-OTBI analysis, We need to show data in a Graphical format attached.Conte…Nithin Channa 48 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Report showing Annual Accrual, Carryover and remaining balanceSummary Require a report that will show the employee absence information for reporting purposesContent Hi All, I need some help in trying to figure out where my numbers …User_2025-02-04-08-51-08-912 528 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to stop Sourcing Email Notifications to SupplierSummary How to stop Sourcing Email Notifications to SupplierContent Hi Poornima, We have a requirement from business to stop sending email notifications to supplier rela…User_2025-02-10-05-51-05-868 176 views 3 comments 1 point Most recent by Siva Kumar Guntumadugu Sourcing
-
Budgetary Control CubeSummary How to create Budgetary Control Cube?Content We created new budget for 2021, different than 2020, now how can we create the Budgetary Control Cube? -
Otbi report on Asset BookSummary Otbi report on Asset BookContent I need to create a report that shows the change in asset life. Which field names do I need to add to reflect the asset life befo…
-
Current Performance Document TaskSummary Looking for a report showing only the current document taskContent We are looking for a report, one line per employee, that would list the current step that thei…
-
Is there any way to connect Oracle Fusion OBI from SQL ServerContent H Is there a way to connect to Oracle Fusion OBI server to our local SQL Server? We would like to report on Data in conjunction to our local HRIS system. Thanks,…Nizar Kassam 50 views 8 comments 2 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisSummary How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisContent Hi All, We have a DFF attribute called Beneficial ser…
-
Combining Pay Dates in a ReportSummary Need to combine all Results by Date Paid into one Number by MonthContent Greetings, I have a detailed pivot table that displays the run results by pay period by …Thomas Drzaic 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need to display Hire details from last six months in OTBI reportContent Hi All, We have a requirement to display HIRE Employees from last six months in OTBI report. In OTBI analysis we selected "Workforce Management - Worker Assignme…
-
SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBISummary SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBIContent Hi All, Can some one explain to me that how does the below conditions work and what's the in detail meaning…
-
Restrict OTBI reports data by Projects by logged in Project ManagerSummary Can we restrict OTBI Reports projects data such as cost,revenue by logged in project manager or any other role assoicated to the projectContent Hello All, We are…Dasaradh CHenji 82 views 3 comments 1 point Most recent by User_2025-02-01-06-00-17-051 Reporting and Analytics for ERP