Category 81
Discussion List
-
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom… -
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…
-
Is anyone else getting a geospatially error in their Payroll Validation Report?Summary: In the Payroll Validation report, we are getting this error for all employees in the first pay cycle since going live on 25C: "The address couldn't be validated…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…
-
Not able to retrieve data from Security - Roles and Privileges Real Time subject area.We are not able to retrieve data from Security - Roles and Privileges Real Time subject area. We are trying to fetch columns from the folder Function Security Policy, Da… -
How to get users logged on info in HCMSummary: User session info required Content (required): Need to get logon info for users. Seems to be a few posts but not a concrete answer. FND_SESSIONS seems to hold t… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 26 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Benefits Enrollment Window - reporting on window start and end dateI would like to be able to report on the start and end dates of a benefits enrollment window. What table or what OTBI subject area would have these dates?Stephen Jones 29 views 5 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 152 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…Khel 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Values not populating in 'Recruiting - Recruiting real time' subject areaHi Oracle community, When we create an analysis using the 'Recruiting - Recruiting Real Time' subject area, filter the results to show only the Recruiting Type 'Offshore…Alyssa T. 34 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 88 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
How do we pass multiple input values for a parameter from Payroll flow to a Bi report.Summary: We have a requirement where in we want to pass multiple input values for a parameter from payroll flow to a bi report. How do we achieve it. We have created a B…User_ANH3E 97 views 9 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 42 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second…
-
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
We Need a table for the Default Values Configure Worksheet Display -Detail TableSummary: Hi We need a table for the below fields under Configure Worksheet Display -Detail Table in workforce compensation plan Content (please ensure you mask any confi…Opkey PA 23 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Bursting to Email:Output sent as URL:Ability to Change the Position of the URL in the Email BodySummary: BIP Bursting to Email: Output sent as URL: Ability to Change the Position of the URL within the Email Body Content (please ensure you mask any confidential info…
-
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 21 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 54 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…Manoharan 456 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
What is the functional difference b/w fusion_ora_ess.request_history and fusion.ess_request_historySummary: What is the functional difference between fusion_ora_ess.request_history and fusion.ess_request_history and please explain ErrorType codes present in fusion.ess…
-
Feedback center manager email and BPM notification content mismatchHad an issue in Notifications content display - We have enabled and customized the template - /Shared Folders/Human Capital Management/Workflow Notifications/NoteSentToM…Challa Ramya-Oracle 7 views 0 comments 0 points Started by Challa Ramya-Oracle Reporting and Analytics for HCM
-
What is the recommended tool to feed Data Warehouse from HCM CloudSummary: I would like to understand what the recommended tool is to feed Data warehouse from HCM Cloud. The BI Cloud Connector seems to me the best tool for this purpose…Jeroen.Broecheler 12 views 2 comments 0 points Most recent by Jeroen.Broecheler Reporting and Analytics for HCM