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
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…
-
Common Question: In what particular subject area can I find these columns?Typical Symptoms: you see columns on an application page and you want to know where they are in OTBI. Content: navigate to and download the latest database lineage mappi…
-
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to … -
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi… -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…
-
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat… -
Pay Period End date Retroactive CostingFor reporting on payroll costing, how are people populating pay period start and end date for payroll actions Retroactive Costing, Estimate Costing or Balance adjustment…
-
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…
-
Is it possible to report on Interview Requests?Summary: Is it possible to report on Interview Requests? I've seen the post linked below, which I thought was asking the same question, but the answer appears to be dire… -
Unable to create report using Workforce Management - Assignment Action Occurrence Real TimeWe have a custom role mapped to the Human Resource Specialist role, with a new requirement to grant access for creating reports using the Workforce Management – Assignme…
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The … -
Rational for the 14day record retention limit on successful HCM AlertsSummary: What is the rational why successful Alert records are saved to the tables for only 14 days? Content (please ensure you mask any confidential information): We wo… -
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr… -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
not able to view future dated hires in my reportSummary: not able to view future dated hires in my report. I added the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='2050-12-31' but still not showing Content (please ensure…
-
Excel report is not printing the parameter when used with burstingSummary: Excel report is not printing the parameter when used with bursting Content (please ensure you mask any confidential information): Hello All, I have an Excel tem…
-
An unresolvable error has occured. Please contact your administrator for more InformationSummary: Getting unknown error as "An unresolvable error has occurred. Please contact your administrator for more Information" While clicking on Start Synchronization fo…
-
Scheduled Processes > Import Costs: Generate Output ReportHi, When accessing the Scheduled Processes page, we search for the Import Costs: Generate Output Report process, as shown in the screenshot. This occurs when the posting…
-
Disciplinary and GrievanceSummary: I have a report meant to capture both active and inactive records for a specific value in the subject area of personal real time. Because the criteria is set to…
-
How to see ESS log messages/files in a Global Absence Ceiling fast formulaI have configured a few ESS log messages within my Global Absenece Ceiling fast formula, however the formula doesn't get triggered when the Calculate Balances and Accrua…
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …
-
HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO dSummary: HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO extract giving duplicate records Content (please ensure you mask any confidential information): HcmTopModelA…
-
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t… -
query that fetch failed transactionSummary: SELECT * FROM ( SELECT DISTINCT HTCE.TRANSACTION_ID, HTCE.PROCESS_CATEGORY, HTCE.OBJECaT_NAME, HTCE.CREATED_BY, papf.PERSON_NUMBER, ppnf.FULL_NAME, TO_CHAR(HTCE…
-
dashboard for CXOSummary: is there any dashboard available by delivered for HR basis of AOR, they can data trends for all modules including core HR , Absence , Talent including learning … -
Custom Approver Logic in BPM – Validating User Email/Access via BIP or Alternative ApproachSummary: In Oracle Fusion BPM, approval routing is typically based on predefined rules such as user, supervisory hierarchy, AOR, or role. However, we have a requirement …
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any… -
In which table candidate position stored?Summary: I am looking for HCM table in which canidate position information stored ? Content (please ensure you mask any confidential information): Version (include the v…
-
SQL Query - Absence entries to Payroll Calculation CardSQL Query - Absence entries to Payroll Calculation Card: This query can be helpful for all users to validate that recent all absence hours are properly synced with the P… -
Getting Invalid format excel format requested error using RTF templateSummary: Getting Invalid format excel format requested error using RTF template Content (please ensure you mask any confidential information): Hi, I have a report that I…
-
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …
-
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl…