Reports
Discussion List
-
LISTAGG Function Not workingSummary: Hi Team, Please help me debugging or optimize the below query. Content (required): The result: The result I want: Version (include the version you are using, if…Robinson Ng 35 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Best way to Archive and Unarchive the BI Reports in Oracle Cloud HCMSummary: Best way to Archive and Unarchive the BI Reports in Oracle Cloud HCM Content (required): Hi all, When we archive a BI Report ( Data Model or Report ) in one ins…Raghu Seregar 353 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Unable to get below requirement of absence columns in BI or OTBISummary: Hi Team, I need to develop thebelow cloumns through OTBI , how can we get below cloumns in absence subject areas. in between 1st apr-22 to 31st mar 23 but i don…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
eText RTF error on Open "XML-20211: (Fatal Error) '--' is not allowed in comments."Summary: Hello I've attached my eText RTF template (in Docx extension per forum rules) and XML (as .txt) I have gone over the template and my Data Model SQL data sets bu… -
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s…
-
Report parameter definitionHi, There is a absence start and end date in the absence used report I created.and when i select start and end dates i want to see absences in that range this is how i d…Cansel Karasoy 22 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Length of Service CalucationSummary Need to subtract Current Date from Legal Employer Seniority DateContent Does anyone know of a SQL formula to subtract the current date from Legal Employer Senior…Rebekah Gilday 117 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …Ajit Dani-Oracle 31 views 3 comments 1 point Most recent by Ajit Dani-Oracle Reporting and Analytics for HCM
-
Department EFFHi, From which table can I find the EFF field defined on the department? If you know, can you share? Regards,Cansel Karasoy 54 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Some of employees not showing checklist task name of 30days HR questionarieSummary: Hi Team, we have onboading perosn task list but some of employees have not showing even task name also and task status also. any one assist me on ? that issue s…AjayKumar Maddipati 23 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, NivyaNivya Mathire 52 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Team Dashboard ErrorSummary: Content (required): I have created a custom role but it is unable to see the compensation tab of the team dashboard area. I know it is a missing role problem bu… -
Need to display Employee Image in the BIP report outputSummary Requirement to display Employee Image along with employee details in the BIP report outputContent Hi All, We have a requirement to display Employee Image and wit…
-
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 55 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM -
How to calculate the number of active assignments for a personSummary: Question from a beginner: How can I calculate the number of active assignments for a person to isolate profiles with potential duplicate assignments? Content (r… -
Seeded/Custom report indicating time spent in previous jobs before moving to current jobSummary: Please share any seeded/custom report that indicates the total time spent by employees in their previous jobs before moving to current Job Content (required): R…
-
How to add a prompts of From and To date and allow the data to filter by this in OTBI?Summary: How to filter the data to be FROM and TO date on the salary change date. I need a prompt to be used to filter the data for these dates. Thank you. Content (requ…Max W 164 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with …
-
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl…
-
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Report unable to generate employment information prior to 2020Summary: We have an employee department dashboard which majority of our users run on a daily basis. This dashboard has prompts to support the kind of data that the user …
-
Cost Center Data not pulling in Workforce ManagementSummary: Content (required): Our reporting team have been trying to add Cost Center to numerous reports and as yet have had no luck. This current report attached, is loo… -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 32 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
when we schedule the report we getting below error messageSummary: Hi Team, when we schedule the report we getting below error message. Thanks, Ajay Content (required): Version (include the version you are using, if applicable)…AjayKumar Maddipati 69 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Seeded list of action and action reasons for HCMSummary Need a seeded list of action and action reasons in HCMContent Hello Everyone, Hope you all are safe and healthy. I need a list of seeded action and action reason…Akanksha Jain 246 views 3 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM
-
We have onboarding 30days questionarie BI report, issue is not showing status in reportSummary: Hi Team, We have onboarding 30days questionarie BI report, issue is not showing status in report some of employess empty coming. I observed that employess statu…AjayKumar Maddipati 33 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Getting the value of Enable Position Synchronization field from Legal employer setupSummary: Getting the value of Enable Position Synchronization field from Legal employer setup Content (required): Hi Team, Greetings! Is there a report or diagnostic or …Parag Hiremath 22 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
What audit reports are available for HCM configuration?Summary: We would like to know the types of audit reports available for HCM modules (ORC, Core HR, Compensation, and Talent) that are configuration and not employee leve…
-
Agent - Promoted ParameterContent Hello all, As you help me a lot before, I would appreciate your advice. We build a DB. Combine few report: New Hires & Terminated employees. The BU is prompted. …
-
Oracle table name containing employment category informationHi, I need a list of cost center information defined in the system, can you share the table containing this information with me? I find the cost center information assig…Cansel Karasoy 453 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM