Category 81
Discussion List
-
Troubleshoot Incorrect Work Pattern SQL QuerySummary: Hello, I am a beginner with SQL and am trying to resolve an issue with an incorrect Work Pattern Report built for us by an Oracle Consultant. I am trying to get… -
Best Approach to Restrict Seeded Folders AccessSummary: We have users from 3 areas such as HCM, Finance and SCM. We have dedicated Custom reports folders for each set of users such as HRs can access 'Custom HCM Repor… -
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…Evelina Hobson 25 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…Rama123-Oracle 240 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident… -
Need query to get the list of all roles for a given roleSummary: Navigation: Tools > SecurityConsole > Roles If I query a role name, I want display all the roles associated with it. I want to build a query for the same. Pleas…Niranjan_DTCC 42 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…User_7A1QO 578 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
OTBI Report not match count - Absence ModuleSummary: I built a OTBI report using Workforce Management - Absence Real Time Subject Area, but I noticed in front-end there are 3 Absence Plans for my sample employee b…Joanah 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th…Pinky Mukherjee 57 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…Sagar Perala 63 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 52 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…sultank 21 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Reporting and Analytics for HCM
-
Can we add a textbox (Number) as runtime parameter in OTBISummary: Hi team, Can anyone please confirm if, we can create a text box as run time parameter and we need to use that runtime parameter in one of the Column formula. Pl…Sagar Perala 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can we change the row sequence in OTBI reportSummary: I have created an OTBI report, but one of the columns is not displaying in the same sequence as it does on the UI screen. On the UI screen, the column is showin…Vikas V. Kamat 31 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Leavers Work ScheduleSummary: Hello, Is there a way to bring historical leavers Work Schedule and Work Schedule End Date? I am currently using the Workforce Management - Person Real Time sub…Dan_Hinsley 11 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …Janardhana Kondaveeti 133 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Inconsistent results in my analysisSummary: Inconsistent results in my analysis Content (please ensure you mask any confidential information): I have this dashboard. If I filter for year 2024 my analysis …Stefano_Mazzocca 32 views 10 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Recruiting Real time Subject Area - Candidate Pool missing data?Summary: Hi Experts, I’m wanting to create a Candidate Pool analysis report using the Recruiting Real time Subject Area. I cannot find a data field to capture the start …
-
BI Publisher for word is stuckSummary: BI Publisher for word is stuck Content (please ensure you mask any confidential information): Hi, BIP for MS Word has stopped working and the application is get…
-
Need to Split Job.Job Name into 3 different fields - Primary, Secondary, TeritiarySummary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as Primary Secondary Tertiary Unmapped Unmapped HEAD OF AGRICULTU…Pradnya_Pampatwar 22 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Admin tool or (other method) to identify all OTBI Subject Areas that my company can accessSummary: Is there an admin tool (or other method) to identify all OTBI Subject Areas that my company can access? Content (please ensure you mask any confidential informa…
-
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 369 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic…RamkumarKadhiravan 12 views 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM -
Recruiting Custom Posting Description Fields Query / SQLHello Experts We need to fetch in a query posting descriptions, for internal and external posting, that were entered by the Manager on Job Requisition Creation > Recruit…Pedro Teixeira 149 views 1 comment 0 points Most recent by Ben Baumes-Oracle Reporting and Analytics for HCM -
how can we export the questionnaire question response comments in Performance Document?Summary: how can we export the questionnaire question response comments in Performance Document? Content (required): we are now using a quesition to get the feedback fo …
-
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…Soumya Suravita 297 views 6 comments 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Need to find table to get all Bank account related informationTeam, i need to fletch all the data related to bank account , can you please suggest which table suits ? ThanksNaidu.R-Oracle 23 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
I cannot find a job offer listed in the transaction logs form 9-22-22 for a specific employeeOne of our job offer from 9-22-22 was selected audit sample. EY is asking that we prove that this job offer was submitted with the correct job descriptions. When a job o…
-
Top 5 reasons for sicknessSummary: Hi, Has anyone got any ideas how i can get top 5 reasons for sickness and display the same as a % of the total absences? Also how to achieve the top 5 reasons a…BillM 32 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM