Category 81
Discussion List
-
Adding a column that calculates the % based on absolute numbersSummary: Content (required): Hi there I am sure this must be fairly simple but ... I have a report with pie chart for people completed, not started and in progress for L…Bobby Jourdan 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include… -
RestAPI -for HCMSummary: I have to extract organization information from HCM using RestAPI but I struggle to find the "organization tree" Could someone tell me how to get an overview of… -
In any of the OTBI Subject area, multiple Manager_Type are not available.Summary: When I am using workforce management checklist real time subject area for the 'Contact Person for external' type of manager I am unable to find column where the…User_2025-02-11-23-20-16-609 11 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 12 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 266 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Filter out a double entry and leave only one entry in Person Profile Real Time subject areaSummary: Filter out a double entry and leave only one entry in Person Profile Real Time subject area Content (required): Hi there, We have a report that lists all the va…Bobby Jourdan 14 views 4 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
OTBI Column decodeHi In OTBI report , we need to decode the column value , like if column value is 'ABC' the we need to decode the it 'BCD', how can we do this please? Thanks
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 2 views 2 comments 1 point Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
In a scheduled report send outcome only if the result of a specific query is 20Summary: In a scheduled report send outcome only if the result of a specific query is 20 Content (required): We need to count the number of extract run. If the result is…Nicola Petri 22 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 75 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Not able to view entire data in assignment and performance related subject areaSummary: I am using performance document status Real time/worker assignment real time subject areas but in the respective subject area I am able to see only my record. I…Kamini Kaushik-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
For how long the Job Run History of a BIP report is maintained in Oracle Fusion?Summary: Content (required): Hi Team, For how long, the report job history for a BIP report is available in Oracle Fusion? How often the history is purged? Is it configu…MandeepGupta 21 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Not able to view entire employees details in Subject area only able to view own recordSummary: I am using Assignment and performance related subject area to fetch details of employee but when I am using my subject area it is only displaying only my data. …Kamini Kaushik-Oracle 79 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 22 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Position Details with Grade Minimum and MaximumSummary: I am trying to get a report of all active positions, their grades and pull in grade min and max. I don't want to base this off of worker assignment since I want…Jennifer Wiggs 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to integrate data to our custom web site using data module build in Oracle BI PublisherWe are building intranet for our office and we want to use the data available with oracle BI publisher. We have already created data module in BI Publisher but currently…Kiran Kancherla 12 views 2 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
How to connect two data groups using number DBI and text DBI in HCM Extracts?Summary: In sql we can use to_char(HDOR.documents_of_record_id) = to_char(FAD.pk1_value) but in HCM Extracts is there any way to connect. Please help me on this. Content…User_2025-02-05-14-11-28-072 31 views 0 comments 0 points Started by User_2025-02-05-14-11-28-072 HCM Extract
-
Accessing OTBI analysis using a linkSummary: Just like we can access the BI report using the link to the report where we can use _xmode to hide all the BI page buttons. Can we also access OTBI analysis usi…Abhishek Nigam 51 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Applying filter for the analysis report with in the dashboard.Summary: Content (required): Currently we are building a dashboard with number of analysis/reports on Headcount using 'Workforce Management - Workforce Trend Real Time' …Su Ma 51 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Invoice Line DFFsSummary: How to associate invoice line dff fields back to the invoice line via sql Content (required): The table PJB_BILLING_EVENTS holds attribute_number1 field for inv…dwright 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Recruiting - Need to show Offers made that were Declined and the reason givenSummary: Does anyone have a report or dashboard built that will return this? The business needs to review the reasons given for recruiting offers made to candidates that…Rich R 12 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 206 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI: "Performance Task": How to get 1 value per employee on report?Summary: All Performance Tasks show as "Ready" unless the task has been started, then it gets a second value of "In Progress". I would like my OTBI report to only have o…Natalie Andrek 12 views 1 comment 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 29 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for HCM
-
Balance Report for CanadaSummary This BIP report renders all dimensions associated to the reported balance and their values (RUN, MTD,QTD, YTD, etc.). Content Data model is based on the query pr…