Category 81
Discussion List
-
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
-
Logical SQL with NULL resultsSummary: I'd like a Performance Tile based on a Logical SQL query to show Zero when no results are found i.e. there is a null result Content (please ensure you mask any …Richard Kemp-Eyre 31 views 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
-
Line Manager Dashboard Workforce Trends with no resultsSummary: Hi, We are working on customizing the seeded Line Manager Dashboard. In "Workforce Trends" tab there are no results for the analysis (see attached screenshots) …Vasco 52 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 31 views 8 comments 0 points Most recent by Pradnya_Pampatwar 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 172 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Third party organization payment method reportSummary: Third party organization payment method report Content (please ensure you mask any confidential information): We have a requirement to run a report of the bank …Michelle Hughes 102 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
-
Can you secure objects in Subject Areas?Summary: Can you restrict certain objects contained within a Subject Area? Content (please ensure you mask any confidential information): Hi Community, I have a requirem…Matthew Hancock 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 257 views 2 comments 0 points Most recent by Alicia Martens Reporting and Analytics for HCM -
How do people manage data load of sick where 2 absences are broken on input but joined as no RTWSummary: How do people manage data load of sick where 2 absences are broken on input but joined as no Return to work Where an employee is sick Monday to Friday and SSP i…
-
How to get the PTD & YTD Balance values from the "Payroll Balances Real Time" Subject AreaWe need to create an OTBI report with the balance PTD and YTD values. In the "Payroll Balances Real Time" Subject Area, Assignment-Period to Date, and Assignment- Tax Ye…Jatin_Maru_1 82 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Payroll - Payroll Costing Setup Details Real Time subject area has timed tracked changesSummary: This subject area is called RealTime but it contains history, as a result it will only return costing details for a position if the costing details have a start…Diane G123 21 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani 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 -
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
-
Workforce Management - Documents of Record Real Time: how to pull the DOR attachment link?Summary: Workforce Management - Documents of Record Real Time: how to pull the DOR attachment link? Content (required): Hi experts, I am curious if there is any way to p…Volodymyr Faranosov 41 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 21 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… -
LSQL - Connect Job Applicant and Employee AssignmentHello All, I am writing an LSQL analysis in OTBI which requires us to add the Hire Date for applicants who are hired. We're familiar with the Projected Start Date and ev…Nick Dorfner 31 views 2 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec…
-
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 -
how to change the hyperlink text in the workflow checklist tasks notificationSummary: I am trying to change the "More details" hyperlink to "Click Here". attached is the data model, xml output and rtf template screenshots any idea ? Content (plea…Shlomo Elnekave 11 views 1 comment 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
hi all, by any chance can you point me to the join between per_person_names_f and CMP_PLANS_BSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 21 views 2 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How do we control Grant/Restrict access to OTBI > Jobs > Report Job HistorySummary: Hello All, We Would like to understand how can can we grant or restrict access to "OTBI > Jobs > Report Job History". Do we have a role or Privilege with contro…tawfeeq.k 61 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 71 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f…
-
Report a journey task status "not applicable"Summary: How can I report, via OTBI, the status "not applicable" if an employee clicked on it during the completion of a journey? It won't appear as a completed task on …Jacqueline GRANDIN 22 views 4 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM