Reports
Discussion List
-
FCC Reports - Excluding Members FormulaeSummary: I need to excluded some entity members from a report I am writing, can some one advice best practice/formulae and provide some screen shots of what I need to do…Mela2104 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
does headcount reports include contingent workerSummary: The delivered headcount reports, do they have contingent worker also? Do they include CWK in the headcount? Content (please ensure you mask any confidential inf…Priyanka_Kumari 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
How to find the sum total of an element for all the groups in rtf template?Hi, I am working on an RTF template for Oracle BI Publisher and I am trying to get the total sum of amount for all the groups in the template. The scenario is there are …Kratika Sharma 1.4K views 0 comments 0 points Most recent by Kratika Sharma BI Publisher Learning Center
-
OTBI report is taking too much timeSummary: Unable to run Time Card Status Report Content (please ensure you mask any confidential information): We devloped custome OTL report. When we are running for one…
-
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (…
-
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 81 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos…
-
Anniversary report for specified dates in the NEXT MONTHSummary: Anniversary report for specified dates in the NEXT MONTH Content (please ensure you mask any confidential information): I have an anniversary report using Subje…JHaden3 282 views 9 comments 0 points Most recent by Andreea Herovic Reporting and Analytics for HCM
-
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 41 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to group rows based on one column and then find the sum for each group?Hi, I am working on a rtf template where it is required to group the records based on the tax code value. Now I want to show the sum of amount for each tax code in diffe…Kratika Sharma 11 views 0 comments 0 points Most recent by Kratika Sharma BI Publisher Learning Center
-
System reports showing the link between rules and task listsHello All, On 2 February 2024, we exported the system report showing us the link between rules and task lists / forms / rulesets. Today we are trying to do the same, but… -
Report Data PurgingSummary: How often your organisation request Oracle to purge the report job history? Content (required): We have reviewed the report job history and have noticed there a…Sejal R 83 views 2 comments 1 point Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Overtime Report for Direct and Indirect EmployeesHi all, I'm looking to build an overtime report that can be used by mangers to see their direct and indirect reporting lines claims, etc I've usually used the 'Assignmen…
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 311 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Grade null for Job requisition OTBISummary: Grade null for Job requisition OTBI Content (please ensure you mask any confidential information): Hello experts, we are building an OTBI report with "Recruitin…
-
Oracle HCM Extract: Deprecated User EntitiesHi, Can anyone please let me know how the Product Team announces about deprecated User Entities? Thanks Chaitra
-
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 91 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
The 'termination category' stopped working in OTBI in 24ASummary: The 'termination category' field in the 'workforce management - work relationship real time' subject has stopped working for me in OTBI. I created a report in m…
-
Context sensitive DFF in LookupSummary: Actually i have done all the setup and Before i'm able to see the DFF value in lookup. My system got cloned from Prod. After performing all the steps as before …
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 11 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …Clare Murtagh 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
What are all the Privilege required to run the Standard ESS job of the Leasing moduleWhat are all the Privilege required to run the Standard ESS job of the Leasing module Ex: Lease Reports 1.Lease Liability/ Analysis Report 2.Lease Transactions and Balan…
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti…Jason Snipes 31 views 4 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM