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
-
OTBI Report Issue - "Compensation - Workforce Compensation Real Time"I am currently building a report using the “Workforce Compensation – Real Time” subject area in OTBI. My objective is to retrieve basic employee details along with their… -
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea… -
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development… -
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for …
-
How to keep my oracle account active after changing companies?Summary: Hi Team, How to keep my oracle account active after changing companies? Thank You, Ajay Content (please ensure you mask any confidential information): Version (… -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b… -
Unable to pull the pull the complete parent hierarchy chain through OTBI reportUnable to pull the pull the complete parent hierarchy chain (Parent Manager 01 to Parent Manager 05) for terminated cases through OTBI report Subject Area > Workforce Ma…
-
Employee Rating not fetchingSummary: I have issue with my performance rating analysis. I was able to get the Overall Manager Rating but it's not fetching the Employee Rating, Rating Level Name, Sta…
-
How to report on questionnaires attached to candidate in job application flow folderSummary: We have a questionnaire created (Candidate Survey) Subscriber: Recruiting; Questionnaire Library: Job application flow Content (please ensure you mask any confi… -
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re… -
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…
-
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…
-
Adding Prescreening Questions to QuestionnairesSummary: We have been trying to add prescreening questions to Questionnaire template for an external application flow and getting Rest error. Upon analyzing we got to kn…
-
Assistance Required: How to obtain the history of when a role is assigned and revoked to a userHi Team, For audit purposes, we’d like to know if there’s a way to track when a specific role was assigned to a user and when it was revoked. Currently, we can only revo…
-
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…
-
Subject Area for Exit interview survey Responses --> Which Subject area to use ?Subject Area for Exit interview survey Responses --> Which Subject area to use ?
-
Notify Project Admin when Project manager is terminatedSummary: Hi I have received a request from Project Administration if it is possible to create an alert to notify the registered Project Admin if the currently active Pro…
-
Area of Responsibility subject area does not return latest changeSummary: We created a simple analysis to return AOR but do not get the latest change. Does the subject area return the same values as what's seen in the UI Content (plea…
-
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme… -
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…
-
Bursting query to trigger resignation letter to personal emailSummary: Hi Team, I need help with a data model and bursting query. The goal is to trigger the resignation letter and route it to the employee's personal email. Could yo…
-
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…
-
OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected AccoSummary OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected Account FlagContent HI, I am looking to identify a field in the OT… -
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher …
-
Goal library extractionHi to all, do you know if there is a possibility to extract all the goals entered by the HR on the Goal Library? Is there an OTBI area? Thanks in advance, Best Regards, …
-
Need table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This … -
Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F?Summary: Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F? The lineage documentation (https://community.oracle.com/customerconne…
-
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…