Category 81
Discussion List
-
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 14 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to set in OTBI report the difference between a variable (an input parameter) and a fieldSummary: How to set in OTBI report the difference between a variable (an input parameter) and a field Content (please ensure you mask any confidential information): Hi, …Barile Alberto 73 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …Parag Hiremath 43 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to run the report USOnlinePayslip from BI PublisherHi All, I need to run the report USOnlinePayslip from BI Publisher. I am not able to get the output whatever parameters I pass. I need to get the xml data of the output …SowmyaSk18 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
BICC VO for PAY_COSTS linking to XLA tableSummary: We are looking for a BICC VO that links the PAY_COSTS Table with XLA tables. This VO should bring in the segment details. Currently we are using PAY_XLA_COSTS_V…Conor Murnane 42 views 4 comments 0 points Most recent by Conor Murnane Reporting and Analytics for HCM
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 23 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn…Oriana L. 44 views 3 comments 1 point Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …Oliviero Riva 22 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 16.8K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OCI: Infrastructure utilization statsHello Team, Please guide on how to generate the following reports Infrastructure utilization stats Including for the peak times - store opening and closing We want to ma…Wale Odusanya 11 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Transpose rows to columns for RatingsSummary: I want to show the ratings of two specific performance document section names in columns. I named the header like the section name. I used a "CASE WHEN" stateme…
-
Hi experts , is there any SQL query to get policies, privileges, and application of a user roleSummary: Need assistance to build a SQL query to get security console details of a user role. Content (please ensure you mask any confidential information): Version (inc…Tharushi Sathsarani 61 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
Chart functionality in Word's BIP add-inSummary: I want to display data from different time periods on a radar graph, but I don't know the necessary setting Content (please ensure you mask any confidential inf…Keita Furuya 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 35 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to Embed an HTML Page in XSL for Report Generation?Hello everyone, I'm seeking guidance on how to embed an HTML page within an XSL file to include it in a report. I have attached the HTML for context to facilitate unders…Nando 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Is it possible to create an OTBI report that will show payment details by payment date and employee?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…Chris West 42 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
View your data in a report included in a journeyHi Team, is it possible to ensure that a user can only view their own data in a report included in a journey task? Thanks in advance, VittoriaVittoria 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fusion HCM Table Column to fetch "New Hire Status"Please guide us with Table.Column to fetch "New Hire Status" information for an employee. PFA image for UI screenshot.Ranganatha_CV 45 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Not possible to use the phase/state name joining other subject area in OTBI analysisHi all, We are trying to create an Analysis in OTBI with Recruiting data. For this, we are joining the "Recruiting - Recruiting Events Real Time" and the "Recruiting - R…
-
Pre-Active and Post-Active Details OTBI subject areaSummary: Pre-Active and Post-Active Details OTBI subject area Content (please ensure you mask any confidential information): Hello Experts, I'm currently using the OTBI …
-
Remove assignment 'O' and 'OT'Summary: We have a internal candidate who is in Offer-Draft status, an assignment has been starting with 'O' we wish to remove this assignment and withdraw the offer, ho…Tara Samari-237472 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Recruiting, Opportunity Marketplace
-
How to track the user who delete a report/data model/folder in the Reports and Analytics areaSummary: How to track the user who delete a report/data model/folder in the Reports and Analytics area Content (please ensure you mask any confidential information): Hi,…Barile Alberto 176 views 2 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
'Sort Column' doesn't workI created this pivot table but seems like function 'Sort Column' only works for 'Person Number' column which is all numbers. I'm looking for sorting report by 'District'…Yiming Xiong 14 views 4 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
Goal Plan Alert composerSummary: Hello Experts, Is it possible to create a resource alert which can trigger when any employee has not declared minimum number of goals as defined in goal plan. F…Saurabh P Singh 23 views 3 comments 0 points Most recent by Ajay Kumar Reddy Gondesi Performance Management
-
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie… -
How-to get a complete view of AOR Security person level accessSummary: I need updated version of general query for AOR that have all AOR scope possibilities so I will pass the employee number and responsibility type then the query …
-
Custom ESS Audit ReportSummary: I am trying to find instructions on how to build a report that will contain all ESS transaction history (before and after data). Could someone please assist on …Pamela_Diaz 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to restrict Data Source in BI > Data Model > Data SourceSummary: Can we restrict the List Of Values from BI > Data Model > Data Source Content (please ensure you mask any confidential information): Customer is soon going to b…Dhananjaya Bhatta 101 views 3 comments 0 points Most recent by Dhananjaya Bhatta Reporting and Analytics for HCM -
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b…