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.
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
-
Job requisition approver using OTBISummary: Job requisition approver using OTBI Content (please ensure you mask any confidential information): Hello experts, we would like to build an OTBI analysis specif… -
Subject Area Access for OTBI ReportingI am trying to create a report of all our Department levels and the hierarchy. I am using the Workforce Management - Work Relationship Real Time subject area. I don't se… -
Tax Reporting Unit field on OfferSummary: Where can I pull the Tax Reporting Unit that is listed on a candidate's offer. Understand that the TRU name is on the hr_organization_units_f_tl, however, how c…
-
Is there an updated HCM OTBI Subject Area to Table Mapping document that can be shared?Summary: Looking for the current HCM Reports - OTBI Subject Area to Table Mapping? I have release 12 and wondering if there is a current one. Content (please ensure you … -
Overtime Report for Direct and Indirect EmployeesHi all, I'm looking to build an overtime report that can be used by mangers to see their direct and indirect reporting lines claims, etc I've usually used the 'Assignmen…
-
OTBI Dashboard we getting below error ?Summary: Hi Team, we have custom old dashoard but when we run the we getting below error. May I know what is the error and how can I rectify the issue! Thanks, Ajay Cont… -
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager … -
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…
-
HR_Action table in Workforce Trends subject areaSummary: The 23R4_HCM_Semantic_Model_Lineage spreadsheet contains HR_Action table that I am unable to find in R13_23A_HCM_OTBI_Database_Mapping_with_ViewObjexts document…
-
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an…
-
OTBI Prompt: Returning Data Not Part of Selected Work EmailSummary: I have a prompt related for Work Email but when I tried to paste 5 work emails, the report return an email (Home Email) which not part of the 5 work emails sele…
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…
-
How we can schedule report to a shared folder.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…
-
Can see all results in Me tab with Admin. accessSummary: Trying to get an OTBI report on the Me Tab that doesn't give me all users Content (please ensure you mask any confidential information): Hi All I'm trying to re… -
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. …
-
I am looking for Oracle fusion HCM exit interview questionare tables to develop a BI reportSummary: with the columns mentions below Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code …
-
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
-
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide… -
OTBI analysis with Termination Reason and Termination Category are failing after 24A upgradeSummary: Hello, All our OTBI analysis with Termination Reason and Termination Category in them are failing after 24A upgrade. I forced deployed PER_ACTION_OCC_EIT_EFF ex…
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C… -
OTBI Leave of Absence Report - No Absence ModuleSummary: Hello, We are trying to use the Assignment Event SA to build a report that will reflect all of the employees who are currently still on Leave of Absence and hav… -
-
benefits cancelled before coverage start dateSummary: Hello Experts, I have to extract in BIP the employees that cancelled or changed a benefit plan before the coverage effective start date. Can you explain me how …
-
can you append the sysdate to the file name while delivering the report through agents'Summary: can you append the sysdate to the file name while delivering the report through agents' Content (please ensure you mask any confidential information): Version (… -
Reporting on Approval Transactions outside HCMSummary: Is there a subject area or report for Approval Transactions that are not HCM related. I know of the Human Capital Management - Approval Notification Archive Rea…
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …
-
hr_org_unit_classifications_fSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…