Reports
Discussion List
-
Copy Member Selection to another report in Books - New ReportsSummary: We are working on moving all reports and reports books from the old FR process to the new reports platform in EPBCS. I noticed in the new reports section that w… -
Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…Nishanth B Jain 31 views 3 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 2.7K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Line Manager DOR- with 0 CountSummary: I have created a Line Manager report with no filters - the intention was the manager can view all their direct and indirect reports. But as there is no filter t… -
How to get the total Headcount of Employees and contract worker on monthly basis.Summary: We are trying to create a dashboard using Analysis Report, but when we try to fetch the headcount of employees and contract workers through analysis, there is a…Harish.M 593 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Getting Shift Hours For An Employee On Particular DateSummary: Folks, We have a requirement to fetch the Hours On Date. Example. Find the screenshot attached. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-… -
No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …JJ_DTU 21 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Tools-> Report and Analytics not available to End user (SUI interface)Summary Tools-> Report and Analytics not available to End user (SUI interface)Content Tools-> Report and Analytics not available to End user (SUI interface) Please sugge…Avaneesh Jain-5059 49 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Privileges required to open Payroll Element Entries - Real Time subject areaSummary: Hello experts, do you know the privileges required to open Payroll Element Entries - Real Time subject area? Thanks in advance for your time! Kind Regards, Vale…Valerio Curzi 11 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Error: An error was encountered when processing your request. Please check the web server logs for aSummary: Error received when prompting for Period in FR report. Content (required): It is one of three prompts. The other two do not return the same error. Version (incl… -
Dashboards and InfoletsContent Hi, I created a simple infolet and a dashboard for Absence Mgmt data. I created the infolet and added the simple report. When it comes to "Add Content" for the L…HulyaAkan76 44 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…User_2025-02-01-03-43-13-079 112 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM -
Difference Between Lease Accounting module and the Lease Asset Option in Fixed AssetsSummary We currently do not have lease accounting turned on and we've been looking to implement it. I notice there seem to be 2 modules to handle it: Fixed Assets and Le… -
Assigment changes- help needed in reportsContent Hi, Is someone can share his knowledge regarding report which can indicate what are the fields in the transaction that were changed(which field). The report is s…User_2025-01-22-19-54-47-882 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 11 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
Is it possible to create drilldown in BI publisher report?I have worked with drill down options in OTBI & OAC. Want to check if this option is available in BIP. Can you please advise? -
Turn Off Elimination for historical periodsIs there a way to turn off elimination in FCCS for (historical) periods? Background:. We have a pretty standard application which consolidates many entities from a GL. O…Ken Chen666 21 views 4 comments 0 points Most recent by Ken Chen666 Financial Consolidation and Close -
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n… -
Passing parameters to schedule event trigger in flow patternSummary: Hi All, We have defined a flow pattern consisting of different tasks. We have the parameters in the flow which is linked back to the individual tasks. One of th…Anirudh Udupa 21 views 2 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM -
Need OTBI Subject Area and columns for incomplete tasks under Allocated Checklist.Summary: We have a requirement report incomplete tasks under Onboarding Checklist, I used Workforce Management - Checklist Realtime subject area. I am able to get the ch…Raghavendra M 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 12 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