Category 81
Discussion List
-
BIP Report Status DashboardSummary: BIP Report Status Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple flows wh…Parag Hiremath 13 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Reporting on paper payslip flag from People GroupSummary: We require a report that gives me people who have a paper payslip flag ticket in People Group segments. This is to ensure employees out of business get their pa…MKuch 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Bypass self-evaluation reporting in Performance ManagementSummary: Bypass self-evaluation reporting in Performance Management Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for…Parag Hiremath 21 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
query to get deactivation date of userSummary: query to get deactivation date of user Content (required): May I know if any one know how to get deactivation date of user, I tried using end_date from per_user…Swati U 396 views 7 comments 0 points Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need a subquery that returns whether the manager filled out an assessment of the employees' goalsI need a subquery that returns whether the manager filled out an assessment of the employees' goals - from which tables can this be retrieved? In Oracle HCM Explanation …Alex_Balanovsky 12 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How many reports are there in systemSummary: can we create a report with the followed fields Report Name, Folder or path where, creator, who has access/visibility to it Content (please ensure you mask any …
-
How to report on Recruiting Organization Description assigned in Job FormattingSummary: I am looking for the table / views that will pull in the Job Footer details assigned in the Recruiting Organization Description section in Job Formatting. Conte… -
Table that holds action tabs in subscriptionSummary: looking for table that holds Close Reason column and Amendment Reason column from action tab in Oracle subscription Management - Subscription Product page. (Pro…Hemnath Natarajan 53 views 1 comment 0 points Most recent by Arturo Macias-Support-Oracle Subscription Management
-
How to fetch all sites linked to a particular customer using querySummary: How to fetch all sites linked to a particular customer using query Content (please ensure you mask any confidential information): Version (include the version y…Neelesh Varma 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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 4 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Duplicate Data Rows for EFF fields in Reporting (Data Issue?)Summary: Hello, We are noticing when we are building basic reports whenever we bring in Job or Department EFF fields in the criteria, we get duplicate rows for employees…CCannadayCTR 32 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all …
-
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 11 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM -
OTBI - Store Analysis or static Briefing booksSummary: Can we use OTBI to store month-end snapshots of static data to refer back to without exporting offline? Content (please ensure you mask any confidential informa…Clare Murtagh 2 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…Venkatesan 1.8K views 3 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
Vaishnavi Phulsay 62 views 4 comments 4 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
Standard Hours From per_availability_details.get_availability_detailsTeam, We have a requirement to get the standard hours for particular period. We have two parameters. Period Start Date and Period End Date. Ex. We are passing 03-Dec-202…
-
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th… -
Get Scheduled Hours From Assignment Work SchedulesWe have a requirement to get the scheduled hours from Assignment Work Schedules. We are trying with the below code but its not giving hours. SELECT * FROM ( TABLE(PER_AV…
-
Human Capital Management - Approval Notification Archive Real Time - Transaction ID missingSummary: Hi, I am trying to create a report using Human Capital Management - Approval Notification Archive Real Time subject area. I am unable to fetch transaction ID wh…
-
How to Restrict groupings with 0 from display in HR dashboard chartsSummary: Restrict groupings with 0 from display in HR dashboard charts Condition used in column Level: CASE WHEN "Workforce Trend"."Termination Headcount"Raman Singh 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fetch Employees not a part of Talent Profile SectionSummary: We have created a Custom Section using the Skill Template under the Talent Profile Page. As followed fields HPI.ATTRIBUTE1 AS TRAINING_NAME, HPI.ATTRIBUTE2 AS B…YASHWANTH GOWDA H R 1 view 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o…Alex van Gulijk 202 views 14 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Table or OTBI subject area to get extract run status and logSummary: Table or OTBI subject area to get extract run status and log Content (please ensure you mask any confidential information): We want to inform business if HCM ex… -
Community of a learning course - OTBIDear all, We would like to report the community in which a COURSE has been integrated to. In my following example : for my COURSE "English language training", I would li…Jacqueline GRANDIN 31 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Override the Online Delivery Option for the PayslipSummary: I need help on set ups for overriding an employee's Payslip online delivery preference when they are terminated in Oracle Fusion Cloud. We are currently on 24A.M. S. 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM