Reports
Discussion List
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 120 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Talent Review - no results OTBISummary: We have created a custom Talent job/data role which contains the relevant security access to view Talent in My Client Groups. We now want this custom Talent rol…Jo Ord 23 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom BI Reports and tables performance issue in fusionSummary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week. Could you please provide d…Venkatesh Emani-Oracle 31 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …Jacqueline GRANDIN 14 views 3 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Sickness Absence ReportingSummary: We have work schedules entered for all employees showing their working days. We need to export this in our absence reports so we can calculate working days lost…Karen Wilson 11 views 4 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 12 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How to set a As-Of Date Prompt in a Dashboard PromptSummary: How to set a As-Of Date Prompt in a Dashboard Prompt Content (please ensure you mask any confidential information): Hi, we created a dashboard. This dashboard h…Barile Alberto 83 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMYSummary: How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMY Tried with FND_LOOKUP_VALUES.Meaning does not return any vaue Can anybody Please…MilanMohanty 14 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Can we have multiple RTF templates as links instead of tabs in BIP report?Instead of having as tabs in case of multiple templates, we would like to have them as links in single view/screen, in one page. Attached the usual format, which we don'…
-
What table holds Request More Information data in approval transactions?Summary: What table holds Request More Information data in approval transactions? Content (please ensure you mask any confidential information): Version (include the ver…
-
Report to show all employees who have not been paid in last 3 weeksSummary: Need a report to see the employee, assignment, last paid date and benefit termination date for the employees who have not been paid in last 3 weeks. Content (pl…Priyabrata Prusty 23 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
CSV BI report extract no data the first time you launch itSummary: Hello experts, I have a CSV BI report that extracts no data the first time you launch it, but if you refresh or re-launch it, the data are displayed correctly. …AnnaMorelli 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 12 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 12 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM
-
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 344 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 146 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 276 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 11 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 62 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 12 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. https://us.v-cdn.net/…
-
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 190 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 26 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM