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
-
Employees Performance goal BI report not showing properly in excel outputSummary Employees Performance goal BI report not showing properly in excel outputContent Hi , We have requirement to create bi reports to fetch the below goal columns fo… -
Is there a Subject Area with User Name and Email on it?Summary: Hello, I am new to OTBI and we are using it for Oracle's new Higher Ed module (Oracle Student Management) , but we do have the HCM and CRM subject areas accessi… -
Payment Method Bank Account Details is not available in OTBI Payroll Personal Payment details RealSummary: We have a customer requirement that we only need to use the Bank Account in ESS Personal Payment Method but when we try to create an OTBI using the Payroll Pers… -
Custom metric doesn't work inside dashboardSummary: Content (required): Hello, We realize a new custom analysis in order to calculate the #Avg Time To Fill (Days), we use this formula: AVG( CAST( TIMESTAMPDIFF( S… -
Delete a Talent profile entrySummary: Content (required): Hi there We are trying to delete a talent profile certificate. We use the following lines. We get an error but no clear details of the error… -
Can hourly rates be reported on?Summary: Our workforce has both salaried and hourly associates and we have a requirement for an analysis to show hourly rates using the SA Compensation Salary Details Re…
-
Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla versSummary OTBI Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla version as old value and new value as custom expression lang… -
Can we create report for the data that we see on Person Management > Review page ?When we edit the existing data in update or correction mode and click on Review button , we see a page with changes that opens up. Can we create report that is present o… -
Time and Labor OTBI - Time card version numberSummary: Content (required): I'm creating a dashboard with different reports for Line Managers and department secretaries. And the report is working good and I get to se…
-
Need to find the oracle table name in BI reportSummary: Hi all I am not able to find the Oracle table name for "TID Upgrade Job" Can anyone help me to find the table name for "TID Upgrade Job" and see the data from t… -
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O… -
BI publisher not working as expected after 22B upgradeSummary: We are facing issues with BI publisher delivery options after 22B upgrade Content (required): We are running BI publisher from Oracle SOA and delivery options a…
-
Event Triggers in Data ModelSummary: Can someone explain how to use the event triggers in the Data Model Content (required): Can someone explain how to use the event triggers in the Data Model Vers…
-
Nested IFNULL and CASE StatementSummary: Hi All, I'm trying to write a CASE statement where if the Annualised salary is blank I need it to say 'Not Reported' Content (required): Below is what I am tryi…
-
Event Triggers in Data ModelSummary: Can someone explain how to use the event triggers in the Data Model Content (required): Can someone explain how to use the event triggers in the Data Model Vers…
-
Has anyone created a dashboard page similar to a website using HTML CSS Coding?Summary: Has anyone created a dashboard page similar to a website using HTML CSS Coding? Can you please send a screenshot of your work. Content (required): Dashboard Pag…
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…
-
Need help to Payroll Employee Deduction BI reportSummary: Report Parameter 1) Person Number 2) Element Name 3) Period 4) Pay Period Start Date 5) Pay Period End Date Report Column · Person Number · Person Name · Elemen…
-
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…
-
Multiple date rowsSummary Multiple date rows In analysisContent Hello friends, i am migrating a direct sql analysis to a new analysis using the subject area, but I have a problem with the… -
How to set property ShowNullValueWhenColumnIsNullable in BI AnswersSummary: Hey, we need to set this property ShowNullValueWhenColumnIsNullable to never like it is mentioned in 2636774.1. Unfortunally in thsi note it os described for An… -
Report data not displaying in tab delimited formatSummary: I am trying to extract data in CSV format. I need the data to show in tab delimited format. Content (required): I am trying to extract data in CSV format. I nee… -
Report Worker Details at Payroll Period End DateSummary: Is there a way that I can return the worker assignment details at the pay date of payroll period end date Content (required): I am building an OTBI report using…
-
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job … -
BI Publisher versionSummary: Need inputs to find the BI Publisher version in Fusion. Content (required): Need steps/sql query to find the BI Publisher version in Fusion. Version (include th…
-
May I know use of below to screen hots of archive and unarchive of reportsSummary: Hi Team, May I know use of below to screen hots of archive and unarchive of report catalogue. from archive we have two options that is Keep Permissions and Keep… -
when I open the PDF format output of Bi publisher report its not downloaded automaticallySummary: Hi Team, when I open the PDF format output of Bi publisher report its not downloaded automatically. any option to set the download the automatically when i open…
-
Is there any way to automatically download the data and upload to FusionSummary: Is there any way to automatically download the data using BI Report and upload it back to Fusion Content (required): We have a requirement to generate some data… -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…
-
Is there any sql query for pulling BIP reports location/path?Summary: Is there any sql query for pulling BIP reports location/path? Content (required): BIP Report properties Version (include the version you are using, if applicabl…