Category 81
Discussion List
-
Can you create a personalized prompt to combine multiple selections into 1 prompt selection?Summary: Wondering if it's possible to create a custom prompt in an OTBI report to create a 'group' to select for a variety of different job name codes? Content (please … -
How to use TOPN in a filter in a column in OTBISummary: I would like to use a TOPN filter in a column formula in OTBI to provide the latest date. There are multiple lines per employee and just want the latest seniori…
-
fast formula to have the eligibility criteriaSummary: Eligibility Criteria to Assign Benefits Tasks through Journeys Content (please ensure you mask any confidential information): I have built a fast formula to hav… -
Can I make a leaver report as a graph showing reasons of termination?Summary: I have made a leaver graph in excel showing leaver reasons by month and have tried to recreate in Oracle, the leaver reasons are appearing, but not the correct …Matthew Gooch 22 views 4 comments 0 points Most recent by Matthew Gooch Reporting and Analytics for HCM -
Just went live and delivered reports don't return data. Need help troubleshooting Absence Calendar.Summary: I am brand new to Oracle and trying to figure out why we're not seeing data in the delivered reports. The one I'm working on now is the Absence Calendar. I've r…Dana Lockwood 34 views 8 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM
-
OTBI Dashboard we getting below error ?Summary: Hi Team, we have custom old dashoard but when we run the we getting below error. May I know what is the error and how can I rectify the issue! Thanks, Ajay Cont…AjayKumar Maddipati 53 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
CMP_SALARY_SECURED_LIST_V emptySummary: Using CMP_SALARY_SECURED_LIST_V to secure a BIP report, but the table is empty for target user. Content (please ensure you mask any confidential information): H…Claudia Schiff 49 views 2 comments 0 points Most recent by Claudia Schiff Reporting and Analytics for HCM -
Reporting on Leave Duration Without Absence ModuleSummary: Need to report on how long employees have been on a continuous leave using assignment real time subject area. This is for an existing report and my preference i…Matthew Phillips 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 23 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Can we customize HR Helpdesk DashboardSummary: We have a requirement to customize the HR Helpdesk Dashboard which is available in the Helpdesk requests landing page. The requirement are categorized into 2 pa…
-
How to print only tags restricting corresponding values in xslt template version 1?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Pritha 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Bi Publisher. How do you show parameter values used for the reportSummary: We would like to show on the BI Publisher report output the parameter values used to create the report. Can anyone help with this please. Thank you. Content (pl…Kevin Robertson 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 32 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…Nishu_Kumari 46 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Manager not able to see the anything in reportHi Everyone, I have created 2 reports and deployed it for the Line managers to be able to run and self serve but when they run they cant see the results. Details of the …Girish Bhatia 24 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How to enable file data source in BI publisherSummary: Add new data source feature has been disabled for FILE connection. How to enable this option. Content (please ensure you mask any confidential information): Add…Anoop K N 495 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM
-
Report of employees with element entries during the pay period NOT calculated due to ineligibility.Summary: For reconciliation purposes we need to identify the elements that were not included in the calculation process for employees since they were not eligible for th…
-
Security and OTBI AgentsSummary: Hello everyone! I've just started at a new company and have found out that internal policies mean we cannot use OTBI Agents at all (even to send reports without…
-
The custom report spacing is not aligned in PDF and Word formatSummary: A custom report is built for the contract purpose. With the PDF version, the format and the spacing are accepted by the UAT. When the report is generated in a W…Keene-Oracle 2 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
How to find the BIP report name which is using a specific SFTP connectionI know the SFTP name that is being used to transfer a file to vendor. But I do not know which BIP report is using that SFTP connection. I have looked at the report jobs …
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 5 views 1 comment 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Last Standard Process date column in payroll reportHi There, Hope you are good! I m looking for creating report with last standard process date for terminated employees in order to run HSDL for final close for these term…Priya1 12 views 2 comments 0 points Most recent by Raju Sandepogu-Oracle Payroll and Global Payroll Interface (GPI)
-
How to calculate number of continuous weeks of Submitted TimecardsSummary: For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks. Content (please ensure you mask any confidential …Richard Kemp-Eyre 22 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How to add BI publisher report to Briefing bookSummary: We have a requirement to Add a BI Publisher to a Briefing Book. I tried creating it by following the steps mentioned in below link but not able to see the outpu…Santhosh Gangishetty 23 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 22 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
ytd payroll balance values using pay_run_balancesSummary: How to fetch the Ytd balance value of the Gross Pay,Net and Employee tax deductions using pay_run_balances table Content (please ensure you mask any confidentia…susmita 756 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How we can pull old assignments and old payroll name?I need logic for old assignments and payroll name, it will be appreciable if you will provide me any sample query. This is the Requirement Global Transfers processed in …Narmada Yadav 31 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM