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
-
Hi! How can I run a query to pull data within 90 days from the effective date?Summary: I need to create a query to pull data less than 90 days of effective date to use as agent and decrease the number of lines in the reporting. Content (required):… -
BIP - List of Employees under the Area Of Responsibility of HRSummary: Hello, Does anyone know how to get the list of employees under the Area of Responsibility of HR via BIP Report? Could you please share a query or do you have do…
-
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …
-
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time… -
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N… -
Secured List View - How it works in a BIP ReportSummary: Hello, Is there any documentation or white paper on how secured list view works in a BIP report? Content (required) We used secured list view in our BIP query t…
-
I am needing SQL for SalaryIdSummary: I am looking for an sql that includes SalaryId for trouble shooting an error I have in data flowing into FAW. I have the SalaryId in the error in FAW but can't …
-
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
BI Reporting function that creates link to attachmentsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Consulting Description (Requir…
-
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…
-
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…
-
Future Dated HiresSummary I need a report from the OBI that will give me a list of employees that have been boarded in Fusion, but haven't started yet.Content I've attempted to load the t… -
how to restricted otbi report to show employee absencesDear , I have a otbi report which is showing correctly result with all employees absences but issue is its showing for those employee who applied leaves on 2021 Dec to 2… -
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Questionnaire Score - 360 FeedbackSummary: Hello everyone, Does anyone know how to fetch Questionnaire Score in a performance document using OTBI? What is the subject area and column folder for this? You…
-
In Otbi reports where we find Absence DatesDear , I need to put Absences Dates in otbi report but i cant find Not need Date Start and End Date i need only Date For example if one employees taken 30 leaves from 25…
-
Can we include a pivot table in a OTBI report.Summary: I have a report and wondering if a Pivot table can be added so if we run this report or schedule it, it would include that pivot table? Content (required): Vers… -
Deep Links in narrative textSummary: Content (required): Hi, I would like to insert a deep link inside an alert with narrative text. For example: https...fscmUI/faces/deeplink?objType=DOCUMENT_RECO…
-
Reset the sequence in etext template when I have only one level where data residesExperts, I have to generate a sequence that resets after printing details for every person. The Cost_ID tag makes sure every record that is needed is fetched on the repo…
-
Restrict Participation in Another Plan Fast FormulaSummary: Content (required): Hello everyone, I'm currently trying to create a Fast Formula that will restrict population's eligibility for Compensation Plan B if they ar… -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 78 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…
-
Checklist QuestionnaireSummary Provides the details of the questionnaire assigned to the worker, questions and responsesContent You can report on the questionnaire questions and responses from… -
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
ADFDI GPO InstallSummary: Any examples of successfully deploying ADFDI via Group Policy Objects? Content (required): We have previously pushed out ADFDI through GPO by extracting the MSI… -
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi… -
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be…