Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Gross earnings reportSummary: Is it possible to create a report in OTBI that shows gross earnings per pay for a specific date range? If yes which subject area should we use? can anyone help … -
How to create a link with dynamic user IDSummary: Content (please ensure you mask any confidential information): We have a button inside the Goals page where the manager can give feedbacks to the employee in an… -
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …
-
Need to fetch HOD comments in Performance managementSummary: I am trying to fetch HOD Comments in Performance task in Fusion HCM? And which table this comments will store? Generally, comments will store in HRA_EVAL_RATING…
-
Query to link Location to Reporting EstablishmentSummary: Hello, CC! I am in a need to find a way to develop a query that can list all the Locations given for a Report Establishment(Or a Legal Employer) for a Report I … -
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): … -
to insert dynamic images in rtf template horizontallyHi, We have a requirement to insert the dynamic images in an RTF template horizontally. we are fetching the image from PER_IMAGES table, but currently the images are fet…
-
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…
-
Default prompt values not workingGood morning, I created a dashboard prompt that filters the values based on a query and works fine but I'm struggling to set the default values. In fact, even if I set "…
-
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c…
-
How to find the OTBI report last run history?Summary: Hi All, Need to find the history of the OTBI report last run, user-wise. Content (please ensure you mask any confidential information): Version (include the ver… -
IN BI report how to restrict the usersSummary: Hi Team, how to restrict the user in BIP query. suppose i want to restict one person in query how can i restrict. Thanks, Ajay Content (please ensure you mask a…
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some … -
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…
-
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …
-
find value in one loop and traverse back to another loop in xml etext templateSummary: I have an XML of ACH file where in there is a value in this path PAYMENT_RECORD/PAYMENT_DETAILS/PAYER_METHOD/EFT_USER_REF. When Make EFT Process is ran the outp…
-
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te… -
Issue with extract for termination detailsSummary: We are using this extract from couple of months back . It is working for all other employees. Only 2 employees facing issue with termination details , we could …
-
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…
-
Order by phase in Recuiting OTBI ReportSummary: Hi everyone, I tried to sort the phase in recruiting but it doesn't work can anyone tell me why? and what is the solution to sort the phase?
-
Employee advance settlementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Job Change ReportSummary: I have a Job Change report that I was sent and I need to add a few fields to it. It was built in Logical SQL and I'm having trouble adding a few fields. Any hel…
-
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a … -
How can I have a nested for-each group inside rtf report?Summary: How can I have a nested for-each group inside rtf report? Content (please ensure you mask any confidential information): If I add a for-each group outside anoth… -
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu… -
Need to remove ‘0’ percentages from Rising star program participant by Ethnicity graphGood Day All! We are facing one issue in a Customer created Dashboard Report. Dashboard is created to show the Rising star program participants by Ethnicity graph. we ha…
-
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find…
-
Report for ESS and MSS TrasactionSummary: Need Report for ESS and MSS Trasaction Content (please ensure you mask any confidential information): Hi All We need to fetch all ESS and MSS transactions Versi…
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
not able to create group by function for date columnSummary: not able to create group by function for date column in OTBI Content (please ensure you mask any confidential information): Version (include the version you are…