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: 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…
-
OTBI Logical SQL complex query assembler - NOW 10 subject AreasSummary Now updated - Combine analyses from up to 10 different subject areas (V4) Content It was already posted on OBIEE forum, but I figured HCM would be a demanding th… -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
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…
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERROR -
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing …
-
Where are Social Security Wages in OTBI?I'm trying to report on information from W-2s, specifically the Social Security Wages from box 3 in the W-2. Where do we find that information in OTBI, specifically Soci… -
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you … -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce … -
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …
-
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Oracle HCM Inquiry Personal Payment Method and Bank AccountHi Oracle SME's, Here is our inquiry, since moving to redwood we noticed that the bank account and personal payment method has been separated. We just need a query to he…
-
Report for ET Final Payout with 403b deductionWe've been asked by auditors for a report of all terminated employees in 2024 that were paid out 'Earned Time Final Payout' and what was deducted for 403b in those paych…
-
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,… -
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…
-
transaction administration subject area securityHello experts, we had an report using the subject area Human Capital Management - Transaction Administration Real Time and it dont consider the security of the employees… -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E… -
Unable to find 'Self-assigned Event Rule' tab under Create Life Event pageSummary: Hi Experts, I’m trying to configure a new Life Event in Oracle HCM, but I’m unable to see the “Self-assigned Event Rule” tab under the Create Life Event page. C…
-
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…
-
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a… -
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…
-
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…
-
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn… -
Unable to restrict OTBI data based on legal entitySummary: While attempting to create any OTBI analysis from HCM subject areas, we are encountering an issue where the data is not being limited to a specific legal entity…
-
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne… -
Calculating Days in Suspended Status for a Requisition - OTBISummary: Calculating Days in Suspended Status for a Requisition - OTBI Content (please ensure you mask any confidential information): I am looking to add a column to our… -
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…
-
How to adjust the alignment of output messages within the OTBI dashboard reports?Summary: Hi Team, Could you please advise on how to adjust the alignment of output messages within the dashboard reports? I’ve attached a screenshot below for your refer…
-
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…
-
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…