Category 81
Discussion List
-
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 32 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 51 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 105 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 …
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
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 53 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 32 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can contents of a UCM file be used to fill a BI-Publisher prompt parameterSummary: Can contents of a UCM file be used to fill a BI-Publisher prompt parameter Content (required): Is it possible to use a UCM file (i.e. a comma separated person n…
-
BI Publisher RTF Template - Repeating GroupSummary: Team, we have a requirement to print the timecard details For each employee the header should be same and the Last Row Should Be Repeated. It would be really he…
-
How to get the Time Dimensions to work with the Move HR DateSummary: We have a recruiting dashboard that has the Time.Month, Time.Quarter and Time.Year dimensions as prompts. When we run a drill down to show details of the intern…Craig Stevens 43 views 6 comments 0 points Most recent by Craig Stevens Reporting and Analytics for HCM
-
Able to see Schedulers attached to Reports?Summary: I have been asked to remove scheduled reports for a few people. These schedulers were made by someone else, and I cannot locate them. I can find the reports, bu…
-
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 -
Display OTBI Analysis to Employee Without Giving Access to Reports and AnalysisSummary: Content (required): We have a requirement where the logged in employee can view his/her development goals count viz., total goals completed, total goals in prog…Jaydeep More 62 views 6 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM
-
Changing time zone for BI reportsSummary: I need to keep the time zone as GMT-05:00 Eastern Time ( US & Canada) for all BI reports when I'm scheduling jobs. I followed the instructions of this document …Ayesha Iroshani 441 views 2 comments 0 points Most recent by Ayesha Iroshani Reporting and Analytics for HCM
-
Need help to fetch the roles with stream names and service detailsSummary: Need help to fetch the roles with stream names and service details Content (required): We have a requirement to develop a report to fetch all the roles along wi…
-
How to obtain a query between the user and the roles associated with itSummary: Roles associated with a user Content (required): Hi team, We need to obtain the list of users and the associated roles. I have reviewed some tables but I cannot…SERGIO BARRETO 122 views 4 comments 0 points Most recent by Raghavan p-Oracle 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…
-
Create analysis using logical SQL error?Summary: Invalid SQL Identifier: fusion.per_allocated_checklists ac. error Content (required): Hi All, We are looking at building OTBI analyses for identifying allocated…William_Johnson 177 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Hello, has anyone tried creating a report in OTBI or BIP that displays an employee's most recent ratContent (required): Hello, has anyone tried creating a report in OTBI or BIP that displays an employee's most recent rating as well as their historical rating (Performan…Hazel De Castro 11 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 22 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculate Percentage based on Running Sum displayI'm displaying a running sum for minority hires and overall hires from month to month. I want to calculate the % of minorities to hires for each month based on the runni…Susan Anderson 71 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Benefits Report Etext template question?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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 54 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 2 views 0 comments 0 points Started by teresa.marciano Reporting and Analytics for HCM
-
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 56 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Difference between primary assignment flag and primary flag in per_all_assignments_m tableSummary: Hi , Can anybody let me know what is the difference between primary assignment flag and primary flag in per_all_assignments_m table. How these two columns behav…