Reports
Discussion List
-
Best ways to provide data extracts for external applications/data warehouses/dashboardsHi everyone, We have been receiving more and more requests for data extracts from our Planning application into various data warehouses, dashboards (such as PowerBI), et… -
Position Details with Grade Minimum and MaximumSummary: I am trying to get a report of all active positions, their grades and pull in grade min and max. I don't want to base this off of worker assignment since I want…Jennifer Wiggs 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to connect two data groups using number DBI and text DBI in HCM Extracts?Summary: In sql we can use to_char(HDOR.documents_of_record_id) = to_char(FAD.pk1_value) but in HCM Extracts is there any way to connect. Please help me on this. Content…User_2025-02-05-14-11-28-072 32 views 0 comments 0 points Started by User_2025-02-05-14-11-28-072 HCM Extract -
I want vertical text in Text ColumnSummary: I want vertical text in Text Column Content (required): Trying to rotate the text to vertical format Version (include the version you are using, if applicable):… -
Sorting throws off the Conditional PropertiesContent I am using the ascending sort option on row dimension members, and conditional properties are set to prefix a $ in the first row for data column. This is however… -
Position/Incumbent Report - by FTEContent I am trying to create an analysis that lists the current active positions, by department, the position FTE and all employees assigned to the position and their F…Annette M 605 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Narrative Reporting - How do we run the REST API /rest/v1/jobs to execute a bursting definition ?Content We are trying to use REST API /rest/v1/jobs to execute a bursting definition using Postman. * Narrative Reporting API = /rest/v1/jobs * API Type = POST * jobType… -
How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Summary How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Content Hi Experts, How to Display BIP Report Output file with Data stamp. Examp…Bala Kasineedi 92 views 6 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM
-
Not able to generate csv file which has both English and ArabicContent Hi, I am not able to generate pipeline delimited csv file which contain both English and arabic values. Arabic text is replacing with some other characters in CS…Nivya Mathire 20 views 6 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Task Manager - Integration to Reports DcoumentsSummary Documents uploaded in Reports DirectoryContent Good Day, is it possible to create an integration on the Task Manager to select a documents that was uploaded on t…Resh 18 views 3 comments 1 point Most recent by Kurt-ARCS Support-Oracle Financial Consolidation and Close
-
Management Reports - Availability in Smart ViewSummary: Management Reports - Availability in Smart View Content (required): We are currently building out Management Reports in our Planning application. While we can e… -
Payroll element entries costingSummary OTBI Subject Area and fields for data.Content Under the payroll element entries - Cost Account are the fields Fund___ Purpose__ Prc__ Object___ Location___ CostC…User_2025-02-08-08-49-19-186 33 views 3 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 212 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI: "Performance Task": How to get 1 value per employee on report?Summary: All Performance Tasks show as "Ready" unless the task has been started, then it gets a second value of "In Progress". I would like my OTBI report to only have o… -
Alias in Financial ReportSummary I can't see the aliases on the pov of the report even though I set up it in the user pov. Any reason?Version 11.1.2.4
-
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…Varkey George-Oracle 171 views 3 comments 1 point Most recent by User_XHDBT Reporting and Analytics for HCM
-
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe…User_2025-02-04-08-51-08-912 615 views 2 comments 0 points Most recent by User_XHDBT Reporting and Analytics for HCM
-
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?Riti Malhotra 36 views 13 comments 0 points Most recent by Caleb Pingelton Reporting and Analytics for HCM
-
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve…
-
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet…Prateek Parasar - GTUK, ACE Pro 109 views 9 comments 0 points Most recent by Shruthi Ramesh Reporting and Analytics for HCM -
Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you…Lucky Sharma 52 views 3 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Task Manager - Reporting for entered comments and answers within the task functionalitySummary Users add answers to questions and comments in the assigned task. How do I get a quick overview?Content Users are guided through the closing process with the hel…Bjoern Schumacher 37 views 2 comments 0 points Most recent by Bjoern Schumacher Tax Reporting (Direct Tax)
-
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…Padamatinti Varsha 20 views 4 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio…
-
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 1K views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP