Category 81
Discussion List
-
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 256 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 32 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 14 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 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 7 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 5 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 11 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 14 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 4 views 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 14 views 5 comments 0 points Most recent by Linga Murthy Reporting and Analytics for HCM -
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 86 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 63 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 33 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 125 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… -
Error on NLS_DATE_LANGUAGE code for Traditional and Simplified ChineseHello, We are editing a data model to update the date in a report for custom languages Traditional and Simplified Chinese and we are facing this error : "ORA-12702: inva…Lise_Rekik_Acc 27 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Date Prompts for two analyses in order to compare data fieldsSummary: OTBI Date Prompts for two analyses in order to compare data fields. I used the instructions of this page OTBI HCM historical reporting (v-cdn.net) to set the da…Sa_De_Or 56 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us… -
How to get user's roles in a BI reportSummary: How to get user's roles in a BI report Content (please ensure you mask any confidential information): Hi, we would like to get in a BI report the following piec…Barile Alberto 97 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
BIP performance after 24ASummary: We have one BI Publisher report that will not complete in any of our Oracle 24A environments. It has a data model size of 661 rows and has numerous Validation m…Thane_Fuller 62 views 2 comments 0 points Most recent by Thane_Fuller Reporting and Analytics for HCM