Reports
Discussion List
-
Host address in BI publisher reportIs it possible to get the host address in the BI publisher report? Regards, NivyaNivya Mathire 41 views 8 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
HelpDesk category reportingSummary: My company utilizes an HR Shared Services department for HR Inquiries. They are essentially a call center for HR questions. They file tickets for each inquiry, … -
Where can I find the database table that holds Segment Value Security Conditions and Policies?Summary: I'm looking for the table in the database where Segment Value Security Conditions and Policies live. Content (required): I am making some changes to the rules a…David Rabalais 91 views 2 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Dashboard: Workforce Compensation Budgets issueSummary: Content (please ensure you mask any confidential information): Hello experts, what is the meaning behind the attached budget seeded reports? The count of total …Valerio Curzi 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How can I add a deep link to go straight to an employee's details?Summary: I am trying to create a deep link in OTBI using the employee number to open the Additional Person Info page, but can only get to the initial page rather than th…Mark Stoker 235 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesSummary organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesContent HI Team, report has to be developed in the column format parent_n…Hanuman Chennamsetty 3.1K views 3 comments 2 points Most recent by Shrikant Gupta Reporting and Analytics for HCM -
Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 89 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report to confirm those that do not have a probation keyedHello, Has anyone built a report to show those that do not have a probation keyed? I have tried building one based on anyone that has the action reason 'end probation' a… -
How To Prepare Extract For Changed, marked attributes, previous data under threading groupSummary: Content (please ensure you mask any confidential information):Hcm Extracts Version (include the version you are using, if applicable): Code Snippet (add any cod…B V LAVAN Salivahan 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 74 views 9 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Formatting issues in excel template for BIP report (formatted as number in data model but is text)Summary: So, we have a BIP report which details the amount for various pay elements, the element name is hard coded in sub select clauses so we can control the column or… -
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 61 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OPSS Audit Report BIP TablesSummary: What are the Tables used in the Oracle Platform Security Services (OPSS) Audit Reports? Need for a BIP Report Content (required): Hello everyone, I have a repor…Tom John Bontoyan 31 views 2 comments 1 point Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM -
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 1 view 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 174 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report to extract Assessment Questionnaire of Learning sectionSummary Need to extract assessment questionnaire of an offering linked to a learnerContent Hi All, I am trying to extract the assessment questionnaire with the answers i…teresa.marciano 669 views 3 comments 1 point Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
How do I download Diagnostic Test Reports?I have run several diagnostic tests regarding an issue we are experiencing. I can view the report, but am also needing to download the tests/reports in HTML. Does anyone…Alicia Martens 266 views 2 comments 0 points Most recent by Alicia Martens Reporting and Analytics for HCM -
Help reporting on Veteran, Disability, and DiversitySummary Looking for a way to report on Veteran, Disability, and Diversity dataContent Hello All, I would like to create a report in Fusion to include veteran, disability…User_2025-01-22-19-24-11-575 369 views 4 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Dashboard Performance for performance document reating distribution no resultSummary: when open Dashboard Performance for standard line manager Dashboard , the result for performance document reating distribution not showing . Content (please ens…Mohammed Alharbi 21 views 1 comment 0 points Most recent by Mohammed Alharbi Reporting and Analytics for HCM -
Can HCM OTBI output file be password protected like BI Publisher ReportSummary Can HCM OTBI output file be password protected like BI Publisher ReportContent Hi, We know how to BI Publisher report output file can be password protected with …User_2025-02-05-22-36-27-300 82 views 11 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Different infolets for employee and managerHi, Can we enable different infolets for Employee and Line manager ? Regards, NivyaNivya Mathire 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can you secure reports using area of responsibility?Summary HR Managers have an area of responsibility based on business unit however can see every employee when in Oracle Transactional Business Intelligence.Content We ha… -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 23 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
Alternative ways to Schedule Reports, Agents and Report Bursting as opposed to using a Generic userSummary: We currently use a generic user which is against our IT internal controls (so have an open Risk we track). We are looking to establish if other customers have t… -
Automate the Archive process in OTBISummary Automating the Archive process in OTBI for Fusion HCMContent Hi, We take backups of the OTBI catalog across our Fusion instances by archiving the custom folder. …User_2025-01-30-01-56-27-828 138 views 9 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to join worker assignemnt real time and Higher education person Real timeSummary: Hi Team, We unable to add the two subject areas ? Any one assisatnce me on ? We need RACE colum from Higher education person Real time. Content (please ensure y…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM