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
-
Do we get any performance issues by enabling BIP Audit reportsSummary: Do we get any performance issues while running any BIP reports after enabling BIP Audit reports access. Any suggestions please? Content (required): Version (inc… -
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…
-
How to Display DFF Attribute Date value to the Alert TemplateSummary: We have document of record DFF where the value is stored in table HR_DOCUMENTS_OF_RECORD column DEI_ATTRIBUTE_DATE2 , and we dont know how to display this value…
-
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl…
-
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep… -
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…
-
OTBI Color coding on rowsSummary: Hi Team, Can anyone please help us on achieving the below requirement in OTBI. We have the percentages on each of the Job row as shown. These percentages are th…
-
how to call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…
-
Report Data PurgingSummary: How often your organisation request Oracle to purge the report job history? Content (required): We have reviewed the report job history and have noticed there a…
-
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…
-
Create an Effective Date Parameter for OTBI ReportSummary: Hi. I am sorry if this question has been asked before. I am looking to add a Effective Date Parameter to an OTBI report so when the user goes to run the report,… -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
Is there a way to enter a prompt date and show this date in a column within the report?Summary: Enter an effective date of 01/05/2023 in a prompt Display this date within a column in the output of the report Content (required): If I user enters a prompt ef… -
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…
-
OTBI:Market Data: No data in report when columns from Global HR dimensions are usedSummary: Guidance to ensure that Market Data reports return data when Global HR dimensions are used. Content (required): 1- Subject Area: "Compensation - Market Data Rea… -
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
What is the process for adding group totals on an OTBI analysis?Summary: I want to add a group by employee number and to show its total trip distance for all start dates. Content (required): I have created an analysis based on Expens…
-
how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…
-
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu… -
Person Identifiers for External ApplicationsSummary: For some employees we have updated payroll id under Person Identifiers for External Applications in person management. Content (required): If I need to take tha…
-
Reporting on future dated positions using OTBI 'Position Real Time' subject AreaSummary: Is it possible to report on future dated positions using the 'Position Real Time' subject Area in OTBI? Content (required): I current report on all active posit…
-
How to Parse or Match specific string within a CASE statementSummary: A Dimension "Job"."job description" returns 'group1.group2.group3.group4'. All four groups are characters of varying length eg 'customer service.customer suppor… -
Application Source website details informationSummary: Content (required): Hello experts, from BI, is there a way to extract website details for the Application Source object (Recruiting module)? For example, if we … -
Reporting on 'Required' Field in OTBI From the Learning CatalogHello all, Does anyone know if its possible at all to report on the 'Required' section of any assigned learning to an individual? Within the Learning Catalog, we have co…
-
Post P2T, how to switch from classic dashboard view to new dashboard view?Summary: We have dashboard in Prod which has a responsive UI as per below. However post P2T, In Test it is showing classic view for the dashboards. How to change this vi…
-
Oracle BI EE option missed in Data source while creating report?Summary: Oracle BI EE option missed in Data source while creating report? Content (required): Oracle BI EE option missed in Data source while creating report? Version (i…
-
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…
-
Headcounts not tieing up with active assignmentsSummary: When we check the headcount for a specific year, on the Line Manager dashboard, the number is far less when compared to the number of persons with active assign…