Global HR
Discussion List
-
Last Paid DateSummary: Looking to pull a report on active employees that shows the last date they were paid/payslip was generated? Content (required): Version (include the version you…Jessica D 52 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Remove Alerts section from dashboardSummary: I created a dashboard with a prompt. When i run the dashboard the alert section is showing despite me not adding an alert section Content (required): How do i r…Tiesha Jones 61 views 2 comments 0 points Most recent by Tiesha Jones Reporting and Analytics for HCM
-
Challenge with TIMESTAMPADD function not returning correct resultsSummary: When I add X number of years to a date field the formula produces a wrong date. Content (required): I build an OTBI analysis based on Workforce Management - Per…Maboagamo 61 views 13 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
OTBI Webinar - Introducing Logical SQLSummary This is the monthly OTBI best practice training webinar delivered by Oracle Development. Jan.27 training topic: how to use Logical SQL to control data join with …User720640-Oracle 949 views 12 comments 18 points Most recent by Srihari Murthy 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 11 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…
-
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 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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…
-
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…
-
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 32 views 2 comments 0 points Most recent by Rajeshkumar_Sekar06 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 117 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
.dat file not generating for inbound interface in HCM extractSummary: .dat file not generating for inbound interface in HCM extract Content (required): Extract output generated in .txt extension not as .dat though I have used file…
-
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 51 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Connecting Business Unit to Employee DetailsContent Hi everybody, I am struggling with a (seemingly) easy OTBI task: I am using two Subject areas: WORKFORCE MANAGEMENT - PERSON REAL TIME and WORKFORCE MANAGEMENT -…User_2025-01-31-17-16-46-301 55 views 8 comments 0 points Most recent by Nimna Reporting and Analytics for HCM -
Error in Copy of Seeded NotificationSummary: BIP Notification issue Content (required): Hi Oracle Experts, I need your help regarding BIP notifications, I have a requirement to add/hide the fields in the n…
-
I'm getting a Dashboard screen parameter error, how should I solve it?I get the 'NAME' field from the same subject area in my Analysis Report and parameter report. and in the analysis report I choose 'is promted'. But the parameter does no…Cansel Karasoy 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 255 views 8 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
No fact table exists at the requested level of detail - Ethnicity IssueSummary: Hi - We have a roster report for our whole employee population and I was trying to tweak the ethnicity section to account for the many scenarios of if they choo…
-
Where can I find Product and Segment from the financials side (default expense account) in OTBI?Summary: I want to join HCM data with expense account data Content (required): I need to be able to pull in the Product and Segment from the default expense account (or …Monique Dias 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Why do some fields break a report in OTBI?Summary: trying to create a census report with fields from multiple subject areas and many fields work together but certain fields break the report Content (required): I…Monique Dias 51 views 8 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Extract Comment after Hiring Transaction or other transactionSummary: Extract comments after hiring transaction Content (required): Extract comments after hiring transaction as show in the image Version (include the version you ar…teresa.marciano 1 view 0 comments 0 points Started by teresa.marciano Reporting and Analytics for HCM
-
Succession Permission AuditSummary Succession Permission Audit ReportContent Is it possible in Oracle HCM to create a report showing all plans, and the individuals who have Succession permission f…
-
How to fetch Contract Type Description into OTBI Analysis (Work Assignment Real Time)?Summary: We have different analysis based on subject area Workforce Management -Work Assignment Real Time, and we need to add an analysis per contract type Description. … -
OTBI - Person Disability cannot View History using Workforce Management - Person Real Time subject aSummary When using "Workforce Management - Person Real Time" subject area we are only able to return the latest Disability row for an employee. How can we see all Disabi…Derrick Campion 81 views 2 comments 0 points Most recent by Amy Wilson Reporting and Analytics for HCM
-
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 41 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
View Extract Results task not showing any instances which has ran post 23A upgradeSummary: View Extract Results task not showing any instances which has ran post 23A upgrade Content (required): User does have access of payroll admin data role and payr…
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 401 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM