Category 81
Discussion List
-
pivot table/ stacked graphSummary: Hi all, I have created an analysis and used a pivot table to generate the stacked graph. Does anyone know if we can move the totals to the top so that it is not… -
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 61 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 11 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 21 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 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Issue on loading Spread Sheet loaderSummary: Hi All, I have been testing the 'Mass Assign Journeys' spreadsheet template to try to mass assign a journey for the PH entities, however I receive an error (ple…RamkumarKadhiravan 21 views 1 comment 0 points Most recent by Marius Voicu-Oracle HCM Spreadsheet Data Loader (HSDL) -
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 display XML tables in BI PublisherSummary: How to display XML tables in Word's BI Publisher add-in Content (please ensure you mask any confidential information): Hello. In my project, I am using Word's R…Keita Furuya 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL IF Statement for FiltersSummary: I am attempting to create an OTBI report that has both work and personal/home email for new hires. For the work email I have that information from the Worker As…
-
Set up a virtual/matrix organization in Oracle HCMSummary: In our organization, there is a regular organization hierarchy showing the line manager and its department. However, as we move more into an agile way of workin…Andries 111 views 14 comments 0 points Most recent by Jordan Gariety 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 11 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
OTBI: manager with at least a direct report both based in the same countryHi everyone, Our customer has the following requirement: To retrieve the list of the manager L1 located in italy with at least a direct report Both manager and direct re…Alessandra T. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Pivot Table limits numbers of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…Arnabb 42 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Periodic Payroll Activity Report bursting Based on LocationSummary: Hi I have a requirement to split Periodic Payroll Activity report based on location. I tried bursting option by creating a copy of globalreport data model and c…
-
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 13 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM
-
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A…
-
Line Manager Dashboard custom with Manager Name HeadcountSummary: Hello, I made a custom OTBI dashboard from the vanila Line Manager Dashboard. In that dashboard we added one prompt Manager Name that is prompted. So when we se…Ilzura Ismailhodjaeva 63 views 5 comments 0 points Most recent by Julian Challenger-Oracle 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… -
Enterprise Hire Date in BI PublisherSummary: Enterprise Hire Date in BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to create a BI Publisher report which cont…Barile Alberto 21 views 4 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Payroll Balance Real Time - Multiple Assignments Not showingSummary: Trying to pull a report with the Payroll Balance Real Time that brings in the multiple (primary & secondary) assignments with hours worked & payroll for each as…Rhonda Fischer 2 views 2 comments 0 points Most recent by Rhonda Fischer Reporting and Analytics for HCM -
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 141 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting on Performance Documents of Workers post Global TransferDuring the Global Transfer of Workers, their existing performance documents can be assigned to the latest assignment. In such cases, the cloud application displays the p…Radhika Ramachandran-Oracle 101 views 2 comments 0 points Most recent by Bhaskar Konar 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 273 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Benefits arrears OTBI reportHi all, We are trying to develop a new OTBI report for benefits arrears , we have used the following 2 subject areas with effective date prompt. 1.workforce management -…yugandhar 162 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to select more than one filter option in OTBI ReportSummary: How to select more than one filter option in OTBI Report Content (please ensure you mask any confidential information): Hi, we created an OTBI report. This repo…Barile Alberto 43 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM