Category 81
Discussion List
-
How to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: First, I apologize, as I am not a reporting guru like you all so this question may seem rudimentary! I am the main administrator for our HCM Learning app. I oft…Angie Elliott 31 views 4 comments 0 points Most recent by Thulasi Ram Reporting and Analytics for HCM -
How can I see all chart types in Fusion Data Intelligence (FDI)?Summary: How can I see all chart types in Fusion Data Intelligence (FDI)? Content (please ensure you mask any confidential information): I need to know what kind of char…Stefano_Mazzocca 33 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Oracle FDI initial configuration guideSummary: Oracle FDI initial configuration guide Content (please ensure you mask any confidential information): We are trying to setup a brand new FDI environment. Does e…Stefano_Mazzocca 149 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI… -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 45 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Assigning HR AOR Roles Changed ReportingSummary: We are moving our HR Specialists to AOR Roles, based on Location. And in testing this in our lower instances, everything on the screens is working as expected. …
-
Employee job levelsSummary: Adding job level to employee report Content (please ensure you mask any confidential information): We have a requirement to show the employee job levels. When I…Ridma Karunanathan 60 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 253 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…Consultant Ian 24 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Are there subject areas for Connections Reporting?Summary: We'd like to report on activity and user participation in the Connections feature. Are there subject areas available for analysis reports? Content (required): W…Janine Brown 33 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Report Perfomance issue when I apply the 7 countries in promptSummary: Hi All, We have OTBI report but in report Perfomance issue when I apply the 7 countries only but if i apply one country working fine in prompt . needs all the d…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Absence reportSummary: I have created a OTBI report to pull absence details and it has parameter of two dates start date between. Client is passing the dates of 1st of Aug to 30th Aug…Reddykrishna 42 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get the details of Project Cost Transfer status in Time card details in OTL.For a reporting purpose we want the details of Project Cost Transfer Status from Additional Statuses with in Time Card Details for a particular date range. Please find t…
-
Can someone help me how to apply Pivot in my OTBI Analysis?Summary: There are multiple values per employee. I want it to display in a single row, but one per column. Is it possible? Your help is so much appreciated. Content (req…Hazel De Castro 32 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
The journey report also tracks journeys that have not startedSummary: Hi experts, The journey report has tracked journeys that have not been started Hi experts, The journey report has tracked journeys that have not been started, i…Mihaela13 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
How to get Consolidated output using Bursting data modelSummary: Hi Team, I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule…
-
How to control the font size in TCS ?How to control the font size in TCS? The font size for the Total value in TCS is smaller than the font size used for tabular data.Divyansh srivastava 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.…Evelina Hobson 2 views 0 comments 0 points Started by Evelina Hobson Reporting and Analytics for HCM
-
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture …
-
OTBI Report for Gross EarningSummary: Hi Can you please suggest if it is possible to create a report in OTBI that will provide gross earnings per element for a specific period? If it is possible, ca…
-
Periodic Accrual in OTBI giving wrong valueSummary: Requirement is to create a OTBI report that has accrual plan balance and accrual value from last period. Plan is incremental so every period, employees accrue a…
-
Oracle Report Rendering IssueHi All, When I try to run a report post mapping the fields using BI, the excel output is not generating. Getting the below issue.. But when I try to download the same in…Dhilipkumaar-Oracle 12 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 424 views 5 comments 0 points Most recent by Madhavi Achyuta-Oracle Reporting and Analytics for HCM -
How to calculate Holidays and Weekends using groovy in Fusion Sales Cloud ObjectsSummary: The requirement is to calculate calculate age of the record which is (today()-creation date). But the age should exclude weekends and public holidays. Is this p…Aditya Varma Gadiraju-Oracle 1 view 2 comments 0 points Most recent by Aditya Varma Gadiraju-Oracle Reporting and Analytics for HCM
-
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all …Oriana L. 5 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th…
-
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our …
-
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom…