Category 81
Discussion List
-
we have requirement of how extract person history detailsSummary: Hi Team, we need to create the report on history details of person like surname before marriage and after marriage , etc of person history details Content (requ…AjayKumar Maddipati 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report the completion date for Journey questionnaires and or tasks?Summary: Is there a way to report on the specific completion date for when a journey questionnaire or general task is completed? Right now, I have noticed a completion d…Emily Cox 65 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…Leslie G 457 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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…Giuseppe Iacono 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
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…
-
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…Nicolas Vahman 42 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
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…Deepak Bhatt 22 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
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…Parag Hiremath 21 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
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…Mark kristan De los Reyes 22 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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…Mark kristan De los Reyes 11 views 1 comment 0 points Most recent by Jbgood Reporting and Analytics for HCM
-
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…Mark kristan De los Reyes 12 views 0 comments 0 points Started by Mark kristan De los Reyes Reporting and Analytics for HCM
-
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…Parag Hiremath 93 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
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…Deepak Bhatt 22 views 7 comments 0 points Most recent by Deepak Bhatt Reporting and Analytics for HCM
-
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…Cesar Saveedra 2.8K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
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…Yves Chassein 32 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
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…Sharon Harper 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 …Alvaro Couto 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…
-
Incorrectly formatted phone number in OTBI tableSummary: Content (required): Hello! I have noticed a situation in our Fusion tables that I'm curious about resolving. We are currently seeing two phone numbers for two d… -
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…AjayKumar Maddipati 34 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
I can still see some of the factory folders even after removing the associated rolesHello, after applying Oracle method of hiding shipped folders in the catalog we still have some remaining that refuse to be hidden hehe. as seen below I logged in as a u…
-
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…AjayKumar Maddipati 60 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…Dharmendra Shukla 54 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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…User_2025-02-05-14-11-28-072 389 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Job Agent Sending to Removed RecipientSummary: Job Agent Sending to Removed Recipient Content (required): I had an OTBI report job agent and needed to change the recipient list, however, after saving the new…