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
-
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b… -
Discrepancy in Actual Effort Displayed on Screen vs. CertificateHello, I noticed an inconsistency in the Oracle Fusion Cloud Learning system regarding the “Actual Effort” metric after completing training. On the learning screen, the … -
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed …
-
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run… -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
How to pass person id from redwood page to Value setSummary: How to pass person id from redwood page to Value set Content (please ensure you mask any confidential information): Hi all, We created a value set to fetch late…
-
I am getting this error in bursting code ORA-01489: result of string concatenation is too long".Summary: I am getting this error in bursting code ORA-01489: result of string concatenation is too long". Content (please ensure you mask any confidential information): …
-
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant… -
BPM: Is there a way to trigger the escalation notification at a certain time of the day (eg. 9 am) ?Summary: BPM: Is there a way to trigger the escalation notification at a certain time of the day (eg. 9 am) irrespective of the time of submission of the request Content…
-
How to combine multiple max formula criteria in OTBISummary: I'm having trouble pulling in all employees latest Seniority Dates. It seems I need to pull in 2 criteria: 1. LATEST Seniority Change Start Date & LATEST Senior…
-
Looking for report that shows state from tax jurisdictions cardSummary: We have run our first payrolls with USOPTE and are running into a case with tax jurisdiction cards having the wrong state in a particular circumstance. We want …
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati… -
Getting error when trying to save OTBI reportI added an additional Legal Employer to our filter on a OTBI report and wanted to Save it, but I keep getting the following error. I even tried to do a Save As and I get… -
Empty per_person_secured_list_v and per_assignment_secured_list_vSummary: I have admin profile but secured views are empty. Content (please ensure you mask any confidential information): I have admin profile but the following queries … -
We have a requirement to audit changes to folder permissions for custom folders in Reports and AnalySummary: We have a requirement to audit changes to folder permissions for custom folders in Reports and Analytics. Is there a way to get these details? Content (please e…
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
Table to identify password updateSummary: Is there a table that tracks the password updates? We have a scenario where the password of a service account stopped working all of a sudden. I have run the pa… -
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…
-
What's wrong in this bursting?Summary: Content (please ensure you mask any confidential information): I have this template and this bursting query: Report works fine: Why do I get an empty output whe…
-
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed… -
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme… -
Issue Accessing Manage Users in Oracle Fusion Data Intelligence – MFA Redirect to OCI ConsoleSummary: We need to access Manage Users in Oracle Fusion Data Intelligence in order to add users to groups. However, when attempting to access Manage Users, the system r…