Reports
Discussion List
-
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 334 views 27 comments 4 points Most recent by Shameer Shaik Reporting and Analytics for HCM -
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table… -
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 142 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need help on Long Running Custom BI Report - running more than 5 hours and failingSummary: The Custom bip report is running for long time(more than 5 hours) and erroring out saying that "Elapsed Time is exceeded" . Would you please help in tuning the …Rama123-Oracle 243 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…SAHAD 13 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
BI Report for otbi reports and the scheduled agentsWhich table stores the information of otbi reports and its scheduled agents.Aishwarya Somvanshi 58 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Get all EMP reporting to a manager in certain time periodI am looking to get all direct reports(all active and term) of a manager during the time period 10/31/22 to present day 05/20/24. If termed I need also need the term dat…Trupti Khodke 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. There are a number of…
-
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …User_2025-01-25-00-37-41-739 65 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Resubmission Reason and Resubmission Status values in Manage Time cardsContent Hi All, In which column and table holds "Resubmission Reason" and "Resubmission Status" values. Navigation:Navigator--> My Client Groups-->Time Management--> Man…
-
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e…MilanMohanty 144 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anup Karmankar 15 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …
-
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree…Parag Hiremath 13 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Workforce Management - Workforce Trends Real Time subject area data dictionarySummary: Workforce Management - Workforce Trends Real Time - metrics calculation We are using the Workforce Management - Workforce Trends Real Time subject area for tren…tanyak 85 views 10 comments 0 points Most recent by Shaik Saddam-Oracle Reporting and Analytics for HCM
-
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 234 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco…Oriana L. 11 views 3 comments 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t…
-
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 14 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …Parag Hiremath 41 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 22 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn…Oriana L. 44 views 3 comments 1 point Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 16.7K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Chart functionality in Word's BIP add-inSummary: I want to display data from different time periods on a radar graph, but I don't know the necessary setting Content (please ensure you mask any confidential inf…Keita Furuya 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 35 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to Embed an HTML Page in XSL for Report Generation?Hello everyone, I'm seeking guidance on how to embed an HTML page within an XSL file to include it in a report. I have attached the HTML for context to facilitate unders…Nando 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Multiple Values in PIVOT tableSummary How to have multiple values in Pivot tableContent Hi I want to have a pivot table where i want to show the Competencies in measure with competency type as Column…Jagdish Varadraj 56 views 3 comments 0 points Most recent by Krishna_Vellela525 Reporting and Analytics for HCM -
Report for Approval Status of Performance GoalsSummary Report or Dashboard for Approval Status of Performance GoalsContent Hello All, A report/dashboard is required to show current Approval Status of Performance Goal…Veena P 425 views 6 comments 0 points Most recent by Mayqueen Sefakor Attatsitsey Reporting and Analytics for HCM