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
-
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB… -
Restrict parameter value in seeded line manager dashboardSummary: We are using Line Manager Dashboard in Fusion hcm, we have different BUs and we have requirement to restrict business unit & legal employer parameters (LOV) in … -
How to report Open Requisitions with AS OF DATE parameterSummary: Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022. Content (required): I have an…
-
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c…
-
How to edit contents within a Data Model Report?Summary: Need to update our disclosure form that is a data model thru OTBI connected to Our New Hire Journeys. Is it possible to upload the new data model or edit the co…
-
'Signer Address' column in Checklist Real Time Subject AreaSummary 'Signer Address' column in Checklist Real Time Subject AreaContent We are trying to leverage Checklist Real Time subject area to develop reports on the onboardin…
-
Is there a way to pull a report that shows if an assignment is missing a payroll relationship?Summary: Is there a way to pull a report that shows if an assignment is missing a payroll relationship? We are new to adding assignments for employees, and didn't realiz… -
Report to show when a spouse works for the same companySummary Benefits for spouses that work for the same companyContent Hi All, I am hoping someone can help me out. We have a request to generate a report that shows when th… -
I need query to get expense approver nameDoes any one have query to get expense approver name
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s…
-
Getting Java.lang.Nullpointer exception while running the data modelSummary Getting Java.lang.Nullpointer exception while running the data modelContent Hi Team , i am getting Java.lang.Nullpointer exception while running the data model, …
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …
-
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of…
-
Beneficiary missing some dataSummary: Hello! I am using subject area Benefits - Enrollment Real Time to pull out primary beneficiaries. I have a record in file that is missing some data. EMP Person …
-
Busting OTBI Myths - Reporting on future or past dated informationContent Myth: You can't report on future dated or past dated information in OTBI Data is generally as of the current date. You can define the report effective date to th… -
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…
-
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, Shanmukhi
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve …
-
OTBI reports new calculated item based on the result of a previous created calculated item?In OTBI reports is it possible to create a new calculated item based on the result of a previous created calculated item?
-
BIP Report Job History RetentionSummary: Hi, How far back can we view Report Job History in Oracle Fusion? Is this the right answer? I want to be able to download the reports like in first picture. I h…
-
How to extract on BIP the field Coments from Progress Summury Recruiting (HCM)Hi, I need a help to extract on BIP the field Coments from Progress Summury Recruiting. Could someone help me please? I can't find it in any table
-
Pull a list of custom OTBI and BIP reportsSummary: Hello everyone, Is there a way to pull a list of custom OTBI and BIP reports? Thanks and REgards Content (please ensure you mask any confidential information): …
-
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be…
-
Documenting the Technical part of Dashboard customizationSummary: Hello, We utilized the Oracle cloud prebuilt dashboards, added custom formulas, new attributes, groups and documented the technical part of custom changes with …
-
I want to fetch goal target outcome dataHi I hope you are doing will I want SQL query to fetch goal target outcome data, I tried to use 'HRG_GOAL_TARGET_OUTCOMES' table but it is empty Navigation: My Client Gr…
-
Is there any way to pull the employees in OTBI having future hire dateSummary: Is there any way to pull the employees in OTBI having future hire date?
-
Need formula for anniversary date on 1st of month instead of day of hireSummary: I need to calculate anniversary dates so that they are the first day of the month they fall in instead of the annual hire date. I have got it partway there but …
-
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run … -
Parent manager 2 job tileFrom the Worker Assignment Real Time Subject Area I could get the Parent Manager 2 Name. How do I get the Parent Manager 2 Job Title ?