Category 81
Discussion List
-
Vaishnavi Phulsay 61 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 41 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 3 views 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 238 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…ROOPESH MADAN-Oracle 14 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle HCM Extract -
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. 1 view 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 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO dSummary: HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO extract giving duplicate records Content (please ensure you mask any confidential information): HcmTopModelA…Pradeep Reddy 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How many ways do I restrict the BIP reports and OTBI reports?Summary: How many ways do I restrict the BIP reports and OTBI reports? Content (please ensure you mask any confidential information): Hi Experts, Please tell me how many…Malak 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
how to capture the selected LOV values.Hi, Need help in achieving to print multiple LOV values selected. Its throwing the missing parenthesis select (:LE) from dual.Shanmukhi 12 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Merge Lead Creation Date & Opportunity Creation DateSummary: We are having a scenario to populate total no of Leads & Opportunity created on Monthly basis. For FY2024, On monthly basis Jan'24, Feb'24 , Mar'24 etc . . It s…Vigneshwar 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Annual Leave Encashment Final DisbursementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…SadiqK 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Combining two rows of data into a single columnSummary: Combining two rows of data into a single column IF an employee has two degrees the expectation is to print it into a single row of data. For example Employee 12…Venkateswaran Murali-Oracle 231 views 15 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Not able edit the OTBI reports for developed by others usersSummary: Not able edit the OTBI reports for developed by others users. Can you please suggest Content (please ensure you mask any confidential information): Throwing an …Linga Murthy 13 views 5 comments 0 points Most recent by Linga Murthy Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Inherited Role Audit detailsSummary: Hi Team, Need a Role report that gives you the details for scenario: Role A is inherited by Role B(Employee Role) and assigned to Person A. Need to know below: …Arun Kumar Krishnan [AK] 31 views 3 comments 0 points Most recent by bobby.hussey Reporting and Analytics for HCM -
Element added back to Balance Feed after updating end dateSummary: After updating the end date of a balance feed element to 2021-12-31 ( through HDL) through Balance Definition page/HDL, the same element is added back with 2022…Hem 81 views 1 comment 0 points Most recent by TudorV-Oracle Payroll and Global Payroll Interface (GPI)
-
Need help finding field in OTBI reportSummary: Hi Team, We have requirement to create a report to pull Progression Grade Ladder’s details. We created OTBI report using Workforce Management - Grade Rate Real …Saurabh_Mharolkar 61 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to export HCM Audit Reports in OTBI?We couldn't find where to export seeded Audit Reports. Does anyone one how can we access?Serap Aktaş 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Someone Deleted the Custom folder from my Username. Is there any way to find the IP address or HOSTSummary: Someone used my credentials to login into UAT POD and Deleted the whole custom Folder. Is there any way to find the IP or Host of the user so that I can find wh…VarunMittal01 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
OTBI Custom ImagesHi all, Just a quick one I'm hoping someone knows the answer to! We've been using our own custom images for reporting and have noticed that the system allows us to uploa…MikeW 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 121 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
No of days old in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…