Category 81
Discussion List
-
create a performance template section based on goals subtypeSummary: Create 2 goals section in performance template Content (please ensure you mask any confidential information): Hello, I have a request to use the subtype to spec…Catherine Abi Samra 21 views 2 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
SQL or ORA exceptions caused due to invalid sql, database package state or some database exceptionsSummary: Me pueden ayudar con el error que genera solo para periodos del 2024, el informe es un Publisher .Elia Lican 21 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
OTBI Dashboard-when i click the apply button it not changing the dashbord dataSummary: HI All, I have edtionally added completion date but when i click the apply button it not changing the dashbord data but when i apply the hire date of dates its …AjayKumar Maddipati 31 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
What is the OUTPUT CHARACTER SET can support German umlauts in etext templateSummary: What is the OUTPUT CHARACTER SET can support German umlauts in etext template. Could anyone please provide any information about this. Content (please ensure yo…mohityagyik 111 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
RTF holding on the empty space if the condition is not satisfiedHi, I facing an issue with rtf template where if the condition is not fulfilled it shows blank space and then the next text in the report like below picture Is there som…chpriyanka 271 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
How to Print data in reverse mode through RTF template , Ex: ABCD>>DCBASummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. I found fonts from internet , but those are m…SAKTHI SUNDAR 121 views 4 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for HCM
-
Query to list all the tables used by a BI publisher reportSummary: Experts - Is there any base table that stores the various tables used in a datamodel for a BI publisher report? Content (required): Version (include the version…Vijay Rajendran 831 views 4 comments 2 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
How to access deleted data information using BI Publisher?Summary: 22A Record Additional Data When Deleting an Assignment Record Using Employment Info Page indicates accessing the deleted data information in BI Publisher (PER_E…Viviane Beaudoin 31 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Get the (comments and attachments) in the performance approval document notificationI want query to get the comments and attachments that appear in the performance document approval notification depends on the employee numberMustafa Abu Dayeh 61 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
How to configure reminders for workflows notificationSummary: How to configure daily reminders for approval workflows notification if no action is taken from approver Content (please ensure you mask any confidential inform…Gleamy Mishra 81 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to know whether a position is vacant or not in Oracle? from which oracle fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Gleamy Mishra 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report for all direct and indirect reportsSummary: I need to write a report for all employees that role up to each VP. Content (required): I need to write a report for all employees that role up to each VP. I wi…Donna Valentine 211 views 5 comments 1 point Most recent by Girishbabu800 Reporting and Analytics for HCM -
How to get the Unique values in the table based value set query ?Summary: I need to get the List of unique manager name based on all the associates. But I couldn't use the distinct or any to get the unique value. Is there a way to han…
-
How to create sub departmentSummary: How to create sub department Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Sni…Gleamy Mishra 101 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
OTBI REPORT- ERROR WITH COMPENSATION SALARY REAL TIME DETAILS SUBJECT AREASummary: Hi All, when I try to add the Annualized salary and salary currency to an employee with a changed salary we find the following issue: 1. adding only the annuali…GiovanniD 41 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th…
-
How to develop a report using year-to-date balance dimensions for payroll balancesSummary: We need to be able to generate effective OTBI reports delivering year-to-date information on payroll balances. When looking at Payroll Balance Results in the UI…Len M. 411 views 9 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Is there syntax in OTBI I can use to round down?I have age in years as 22.6 which I need rounded down to 22. Using ROUND rounds up to 23; applying data formats rounds up. e.g: ROUND((CURRENT_DATE - "Workforce Manageme…Clare Murtagh 41 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Filter not working for case statementSummary: I am creating a HDL formatted report to produce a list of employees that require termination from HCM. I have managed to produce a list of all the employees tha… -
OTBI Agent sends spoiled action linksSummary: OTBI Agent sends spoiled action links Content (please ensure you mask any confidential information): Hi experts, I am working on the new job applications list O…Volodymyr Faranosov 11 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 31 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
FIlter on Excel BI Publisher TemplateSummary: FIlter on Excel BI Publisher Template Content (required): We want to apply a filter on a column in the excel template. We have a report showing all employee of …A.Ferraro 359 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Performance Document Changes Audit ReportHello, We have a need to audit our Performance Documents to understand who all made changes on a performance document. Each time a rating is changed we want to generate …Nick Dorfner 331 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Report on Role MappingsSummary: I'm looking for a way to pull all Role Mappings currently set up. Is there a delivered one I'm missing? Or, does someone have a sample to share, please? Content…
-
How to Filter for Calculation Component Details in OTBISummary: Business requires a report to pull all current information on the Reporting Information Calculation Card where the Calculation Component Detail = Third-Party In… -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 41 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Extract text data from "SuccessCriteriaText" in "XML_DATA_CACHE" column "HRC_TXN_HEADER" tableSummary: Does anyone know how to extract text data from "SuccessCriteriaText" column in "HRC_TXN_HEADER" table? Although I could extract some text data such as GoalName,…S.Watanabe0110-Oracle 161 views 1 comment 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM