Reports
Discussion List
-
Min, Mid and Max Salary Ranges missing for some associates in OTBI Report. How can we fix this?Summary: Unable to pull Salary Range Min, Mid and Max for some associates in OTBI report. Content (required): Hello, While pulling a report created in OTBI the Salary Ra…AH SL 31 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
FCCS Hybrid Cube Report runs in seconds, when before as a FR report run for 20 minutes.Hi All, We recently migrated an FCCS application from legacy to enterprise. Once in enterprise license we activated the dense sparse optimization. Amazingly enough, the … -
Adding if/then statement in attribute for extract definitionSummary: I have an employee extract that creates new users in a third party system when new hires added to HCM. One of the requirements is to pass the users reimbursemen… -
Cost center detailsSummary: Hi, Can anyone provide SQL to get cost center details of the department. Content (required): Version (include the version you are using, if applicable): 21C Cod…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need advice on creating Dashboard for Current Year and Previous Year data togetherSummary: I have a requirement to create a dashboard for some of the KPI accounts. It should display data for the current month and 5 previous months (with comparison aga…TarunG-Oracle 31 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme…Michael Nega Gebrehawariyat 24 views 1 comment 0 points Most recent by User_2025-02-10-15-51-50-906 Reporting and Analytics for ERP -
Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…User_2025-02-05-22-11-22-331 145 views 16 comments 1 point Most recent by Sourabh Choudhury Reporting and Analytics for ERP -
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 61 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…StuartHibbert 230 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Learning community reportContent Hi does anyone have a learning community report they could share? Kind regards MelissaUser_2025-02-06-11-18-47-896 56 views 4 comments 0 points Most recent by User_2025-02-06-08-05-57-271 Reporting and Analytics for HCM
-
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…User_2025-02-05-02-38-04-251 45 views 4 comments 2 points Most recent by A.JOSH Reporting and Analytics for ERP
-
SQL for Period Close Exceptions ReportSummary: SQL that generates reports Content (required): Hello, I am new as report guy at my company, and I would need to extract the SQL that generates this report 'Peri…
-
Need OTBI/BI query for checklist QuestionnaireSummary Need OTBI/BI query for checklist QuestionnaireContent Hi All, We have created Off boarding checklist and we are planning to develop a report(OTBI/BI)based on que…User_X612P 242 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
notes function & named POVhello, Is there a dynamic way to read the account member on a note template without having to use named POV´s. Our account dimension is on the report rows. Thank you
-
Candidate Profile Print out ReportSummary Candidate Profile Print out Report BuildContent Hi All, I have a new requirement to build Candidate Profile Print out Report HCM--> My Client Group --> Hiring --…Iann hick 86 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 41 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query for extract Hierarchy ManagerHi there , we need to reconstruct the hierarchy of a user's managers via a query in BI. The real problem we encounter when a manager then has several active assignments …User_2025-02-07-06-30-13-200 2.1K views 6 comments 0 points Most recent by User_2025-02-07-06-30-13-200 Reporting and Analytics for HCM
-
All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar…Andrew_Schmitz 24 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 41 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Catalog of Payroll Flows Dashboards in OTBI reportingContent From 21C or 21D release onwards, following OOTB Payroll dashboards will be deprecated: * Active Processes Dashboard * Payroll Flow Details Dashboard To continue …Tanvi Jain-Oracle 302 views 6 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Not able to add dashboards objects and OTBI contents on Dashboard pagesSummary: I am trying to create one dashboards using analysis but when I created one dashboard and trying to add column sections and other dashboards options on dashboard…Kamini Kaushik-Oracle 21 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Output from BI Report is not fully getting passed to HCM Extract in the flowSummary: We are working on the process with the flow including the first step of HCM extract execution which calls BI Report to generate the data in HDL format and then … -
Unable to get the BIP DataModel With DataCache References in Diagnostics ResultsContent Hello All, As per the oracle KM note 'Fusion Global HR: BIP DataModel With DataCache References Diagnostics Resulting Failure: null (Doc ID 2754842.1)', i tried …Janardhana Kondaveeti 32 views 12 comments 2 points Most recent by Peng Yang Reporting and Analytics for HCM