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
-
HOW TO DELETE INACTIVE USERS IN fUSIONSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Why are there different formats of the Transaction Analysis Duty role codes?Summary: Some Transaction Analysis Duty role codes follow this format: "ORA_FBI...DUTY_HCM" and others this format: "FBI…DUTY". Is there any significance to the role cod…
-
Difference between Headcount and worker count in fusion analytics dashboardsSummary: Why are there two extremely similar workbooks (for many metrics) which include Person Count and some which do not. Their descriptions show the only difference i…
-
What is the table name of evaluation comment during "Share and Release" phase?Summary: What is the table name of evaluation comment during "Share and Release" phase? Content (please ensure you mask any confidential information): During performance… -
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
we joined two subject areas but when we apply single country it is woking fine but multiple not workSummary: Hi All, we joined two subject areas but when we apply single country it is woking fine but multiple not working. stlll searching mode ? subject area: workforce … -
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN… -
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i… -
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ… -
HCM Position HierarchySummary: Hello, I created an OTBI using Position Real Time subject area but I am not able to get the desired results. Example, I have below position hierarchy Position1 …
-
Where to find/add Brazil Job Details attribute values ?Summary: I am not able to find this Brazil Job Details values in Job Details/Jobs page. I believe its an attribute under a delivered DFF attribute (as shown in the Desig…
-
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):
-
Fast Formula or query retrieving the number of working daysSummary: Content (please ensure you mask any confidential information): Hello experts, it is possible to build an SQL query or Fast Formula retrieving the number of work…
-
Succession Plan ReportHow to view All Private succession plan available in system in OTBI ?
-
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…
-
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…
-
Windows 11Summary: Hi Team, Windows 11 in our organization roadmap for next year. Can someone please point to Oracle Fusion HCM Cloud documentation that covers the OS supported by… -
Issue with formatting totals in OTBI Analysis TableSummary: I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted … -
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…
-
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
function to return fast formula return variabledo we have any function / package in hcm that we can use in BI query to retrieve the return values from a Fast Formula. Like we have one for value sets (pay_ff_functions…
-
OTBI Absence reportSummary: I have created a OTBI report to pull absence details and it has parameter of two dates start date between. Client is passing the dates of 1st of Aug to 30th Aug… -
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a… -
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…
-
BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS WordSummary: BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS Word Content (please ensure you mask any confidential information): BIPubli…
-
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od…
-
Issue with number of direct reportees in OTBI reportHi All, Facing issue with number of direct reportees, its showing inaccurate direct reportees. Logic for direct reportees →COUNT("Assignment Manager List Unsecured"."Per…
-
BI Impersonator roleSummary: We are trying to connect OTBI through OAC. To implement this, we need to know what privileges should 'BI Impersonator' have. As of now BI Impersonator role not …Muralidhar Manchikanti-Oracle 81 views 0 comments 0 points Most recent by Muralidhar Manchikanti-Oracle
-
Drill Down in the OTBI does not work correctlySummary: Drill Down in the OTBI does not work correctly Content (please ensure you mask any confidential information): Hi, we created an OTBI report. The extracted data …