Category 81
Discussion List
-
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco…Oriana L. 12 views 3 comments 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell… -
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t…
-
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
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 93 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 66 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 14 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 43 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 21 views 5 comments 0 points 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 18.5K 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 12 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 69 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. 38 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 23 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 43 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 11 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 42 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 33 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 218 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 11 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 22 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 …