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
-
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… -
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… -
DocumentsOfRecordEORowSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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. …
-
Flexfield does not show up in subject areaSummary: We have an existing flexfield available on Employment/Assignment page of employee but when I try to report out of it, i cannot find that attribute in Worker Det…
-
Reporting on Guided Learning UsageContent Hello, This might be a long shot, but our business is trying to report on how often employee's are using guided learning. Are there any tables that store the usa…User_2025-01-31-00-25-12-234 31 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 -
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…
-
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…
-
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…
-
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… -
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' …
-
Position/Incumbent Report - by FTEContent I am trying to create an analysis that lists the current active positions, by department, the position FTE and all employees assigned to the position and their F… -
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…
-
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…
-
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… -
Administration-->Bi Publisher/Manage BI Publisher-->Runtime Configuration/Properties Refreshed?Content Hi there, I searched My Oracle Support and the Community, but wasn't able to find any documentation regarding the following: Any knowledge/documentation regardin… -
PDF Template with XML tagsSummary PDF Template with XML tagsContent I have a requirement to upload a PDF template to the report. And the report should populate employee name, date to the PDF when… -
How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Summary How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Content Hi Experts, How to Display BIP Report Output file with Data stamp. Examp…
-
Not able to generate csv file which has both English and ArabicContent Hi, I am not able to generate pipeline delimited csv file which contain both English and arabic values. Arabic text is replacing with some other characters in CS… -
Payroll element entries costingSummary OTBI Subject Area and fields for data.Content Under the payroll element entries - Cost Account are the fields Fund___ Purpose__ Prc__ Object___ Location___ CostC…
-
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… -
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… -
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 …
-
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…
-
Employment History extract is not picking up Salary history records when assignment effective date iContent Employment History extract is not picking up Salary history records when assignment effective date is not between salary start date and salary end date Here are … -
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe…
-
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?
-
Work structure reports for Oracle HCMSummary Work structure reports for Oracle HCMContent Do anyone have list of reports which can help pulling the work structure details from the configuration tables - JOB…
-
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet… -
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…