Category 81
Discussion List
-
User not able to run a dashboard in OTBISummary: Content (please ensure you mask any confidential information): Hi, I am testing a user where he is able to view the Dashboard and when I click on it, the prompt…Pannala 118 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 16 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…Stefaan Onderbeke 160 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to find Notifications setup on a Scheduled Process scheduleSummary: In Scheduled Processes, how you do view/edit Notifications setup on a scheduled report? Content (please ensure you mask any confidential information): Version (…
-
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 -
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…Simranjeet Singh 93 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle 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 24 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 32 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 82 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 240 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 122 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 762 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 23 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur… -
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 42 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 53 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 22 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 203 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 65 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 42 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. 332 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 34 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 13 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 23 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM