Category 81
Discussion List
-
CMP_PERS.CUSTOM_SEGMENT7 Oracle HCM table nameSummary: Content (required): Hello experts, in which Oracle HCM table can I find the attribute CMP_PERS.CUSTOM_SEGMENT7? Thanks in advance for your time! Kind Regards, V…Valerio Curzi 28 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to extract the results of the notifications sent using BI Publisher with Bursting.Summary: if seeded report got bursted one notification through EMail to X Users, is it possible can we get notification delivered date. If yes what are the tables involv…Sivaram Injeti 45 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Error message when downloading BI ReportSummary: Content (required): Hello experts, when downloading a BI custom report with some users I get the following error message: ORA-01847: day of month must be betwee…Valerio Curzi 59 views 9 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Are the running records kept in the OIC environment like the scheduled reports?Hi, Is it possible to take the last runtime of the service I prepared in OIC and add a condition in this direction to my sql report?I s such information available? For e…Cansel Karasoy 16 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
Oracle BI EE option missed in Data source while creating report?Summary: Oracle BI EE option missed in Data source while creating report? Content (required): Oracle BI EE option missed in Data source while creating report? Version (i…
-
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 54 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Examples of Termination reportsSummary: Content (required): Hello experts, please, could you share some examples of Worker Termination reports? Thanks in advance for your time! Kind Regards, Valerio V…Valerio Curzi 45 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for getting list of all Customized objectsIS there a report which can list out all the objects on which either Page Customization or Customization via Designer Studio was done?
-
Payroll Deductions by Benefit PlansSummary: Looking to report on employee benefit deductions and their respective plan by pay period. Content (required): We have been tasked to report on employee pre-tax …
-
Need table to get position headcount from Manage position pageSummary: Need table to get position headcount from Manage position page Content (required): Need table to get position headcount from Manage position page Version (inclu…
-
Which Role is required for column AsgRepresentativePEO.WORKER_ASSIGNMENT_ID?Summary: I have Created an OTBI report in which AsgRepresentativePEO.WORKER_ASSIGNMENT_ID is cloumn is there I am not bale to access the report , So I am assuming may be…Rajib_Samanta 36 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to adjust a query to return only work email address and add Person NumberSummary: Hi, I'm looking for some help to adjust the below query to only return work email address (W1) and if possible add in Person Number Content (required): select E…Sharon Ferguson 769 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to get an analysis to show # of open Positions being recruited for each month over the past yearSummary: How to get an analysis to show how many positions were being recruiter for each month over the past year? We have a dashboard with the time dimensions of Month,…Craig Stevens 34 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Layout name in the report output file nameSummary: When report is exported to Excel, the report name is concatenated with the layout name, to arrive at the report file name. Content (required): What are my optio…
-
Need formula for Date Paid is in last calendar monthSummary: I have a report using Subject Area Payroll - Payroll Balances Real Time. The report will run on the first day of every month and will capture the number of hour…
-
OTBI Report - Phone logicHi Team, I have one report have couple of assignment details, Now I have to add one column phone number. Criteria to fetch phone number is, If the work mobile number is …
-
Favourites window only fills half of screenSummary: In OTBI the favourites window only fills half of the screen Content (required): When entering OTBI the favourites window only fills half of the screen, bottom h…DennisOliver 38 views 4 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
How to view specific subject areasSummary: I can't seem to figure out how to access the vacancy numbers under Workforce Management - Vacancy Real Time Content (required): I'm attempting to view the vacan…RyanPE 38 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha… -
Error with Next 90 Day SyntaxSummary: I'm getting an error when I use the below formula to get the next 90 days form a specific date field in my filter. Content (required): The error I'm getting bel…
-
Need BIP query for Sensitive Information in Job Application ORCSummary: Which is the source table for National Identifier and Date of Birth under Sensitive Information? Navigation: My CLient Group >> Hirings >> Search Req Number>> C…
-
Dear Experts I want to check do we able to get the translated report in OTBI ScenerioSummary: We have built questionnaires with a translation of the language and prepared the report to see who attended the evaluation and their responses. Currently, we ca…Mohammed Tariq 37 views 2 comments 0 points Most recent by Rajeshkumar_Sekar06 Reporting and Analytics for HCM
-
Change Dashboard Icon ColourSummary: Content (required): Recently, our client decided to change the background color of the application, and overall it looks fine but on the dashboard, the icon col…
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 55 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Please help share SQL to extract all oracle fusion hcm setup configuration with dataHello All, We want to have a download of Config Workbook from the POD,but Configuration Package and Implementation Project setup isnt working as expected. Please help sh…C.R.Balaji 116 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Manager hierarchy in Recruitment using OTBISummary: Need guidance on which field or logic to be used to include manager hierarchy in an OTBI recruitment report Content (required): OTBI Manager Hierarchy Recruitme…
-
California Pay Data Reporting UpdateSummary: The California pay data reporting requirement is getting updated. Is Oracle developing an update to the delivered report to account for this? Content: Existing …User_2025-10-31-01-06-01-706 184 views 5 comments 2 points Most recent by User_2025-10-31-01-06-01-706 Reporting and Analytics for HCM
-
Parent Manager Job Name/TitleSummary: I have a report using Workforce Management - Worker Assignment Real Time and need to know if there is a way to add the Parent Manager Job Name (Title) to the re…JHaden3 60 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What Criteria will return Previous Position along with New Position for Action Changes?Summary: I am looking to pull a list of employee internal moves (Transfer to a new position). I have the criteria set to show me the action - transfer - and the new posi…Kelly_at_D&R 37 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM