Reports
Discussion List
-
Most Recent Assignment RecordSummary Most Recent Assignment RecordContent When we need to report inactive and active employees in one analyses, it is not easy to get the latest record (for example, …User_2025-01-23-21-37-42-476 76 views 9 comments 1 point Most recent by Julie Mandel Reporting and Analytics for HCM -
Formula for exporting date in csv as dd mmm yyyySummary: I have a need to present date in a csv extract as dd mmm yyyy. I have the below formula that presents it as dd mm yyyy, any assistance that could be provided to… -
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 173 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
New Redwood reports available for P&GSummary: Hello, Is there any new redwood reports available for Performance & Goals? Kindly provide the links here. Your help is highly appreciated. Regards, Hazel Conten…Hazel De Castro 51 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
we need below BI columns but unable to development of those from absenceSummary: any one help me and to the requirement Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that …AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Degree Reporting - Item Code not available in Subject AreaSummary: Hello there, I'm trying to create a simple analysis that provides a full list of Degrees and the Item Code. There doesn't seem to be a "Item Code" option to sel…
-
How can I pull the source information indicated on the Candidate Profile.Summary: We are looking to pull the source information that is stored on the Candidate Profile - not the submission that is associated with any requisitions. Content (re…Craig Stevens 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Does the Oracle code 3 of 9 barcode (B39R00.ttf) work?Summary: Content (required): I'm trying to utilize the built in oracle barcode fonts but I have taken screenshots of the barcode and scanned them on online scanners whic…KevinCochran 121 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Error on running an OTBI report after 22B being appliedSummary: We are facing issues in running a OTBI report post 22B upgrade. Please see the attached error and let me know how to resolve this issue. Content (required): Ver…
-
Custom date and currency formatting in report data table columnsSummary: Is there a vehicle for providing custom formats? Content (required): In OTBI data tables, columns only offer a limited set of pre-defined formatting. How can I …Maboagamo 41 views 8 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How should I format the phone number in sql?HOW CAN I FORMAT THIS QUERY AS '+55 111 222 33 11' SELECT CASE WHEN SUBSTR (LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)), 1, 3) = '+55' THEN LTRIM (RTRIM ((PPH.SEARCH_PHONE_N…Cansel Karasoy 82 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Change Date format in OTBI reportSummary: Hi, I would like to know how can I change the Date format in OTBI reports. Currently in reports that I create, date format comes up as MM/DD/YYYY. However, I wo… -
How to connect oracle cloud HCM data from microsoft power bi reportSummary: How to connect oracle cloud HCM data from microsoft power bi report Content (required): How to connect oracle cloud HCM data from microsoft power bi report Vers…RIfdhy Zain 112 views 3 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM -
SQL function to convert number into descriptionSummary: Content (required): Hello experts, do you know if there is a way to convert an amount into description? For example, in addition to salary amount 40.000 we need…Valerio Curzi 61 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Oracle HCM BI Tabel for manager compensation plan approval statusSummary: Content (required): Hello experts, could you suggest the BI tables allowing to track workforce compensation manager approval status? In other words, we should b…Valerio Curzi 34 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Termination Report - Adding Level 04 Manager NameSummary: Hello I created a report and I want to add "Level 04 Manager Name". I'm using the subject area Worker Management - Worker Assignment Real time and selecting Ass…KMore 52 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Identifying employees missing goalsSummary: We are creating an OTBI analysis to identify employees missing goals in the year 2022. As soon as we add goal plan information we are noticing that there is dro…
-
How to use latest version of Excel template for BIP ReportSummary: How to use latest version of Excel template for BIP Report Content (required): Currently we are using Excel 97-2003 Workbook (.XLS) as Excel Template Extension …Sujeeth Chinta 124 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
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 45 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Finding Reporting Fields - Compensation ModuleContent Hi all - my reporting team is working on finding some fields within our Compensation Module and are unsure how to best located them. For example, we are provided…Prudence K 102 views 9 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I have a requirement to add column to show Count of number of levels of direct and indirect reportsSummary: I have a requirement to add column to show Count of number of levels of direct and indirect reports I am not sure what logic to build. Please help. Content (req…Parul Sah 31 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is it possible to see pending workers' assignment details in Checklist OTBI reports?Summary: Is it possible to see pending workers' assignment details in Checklist OTBI reports? Content (required): When running a checklist OTBI report of open/closed tas…Alona Aronov-Oracle 141 views 4 comments 0 points Most recent by Alona Aronov-Oracle Reporting and Analytics for HCM
-
Unable to extract the results of the notifications sent using BI Publisher with Bursting.Summary: if seeded report got bursted one notification through EMail to X Users, is it possible can we get notification delivered date. If yes what are the tables involv…Sivaram Injeti 41 views 1 comment 0 points Most recent by David --Oracle 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
-
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 51 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…
-
How to get an analysis to show # of open Positions being recruited for each month over the past yearSummary: How to get an analysis to show how many positions were being recruiter for each month over the past year? We have a dashboard with the time dimensions of Month,…Craig Stevens 32 views 1 comment 0 points Most recent by David --Oracle 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…
-
How to view specific subject areasSummary: I can't seem to figure out how to access the vacancy numbers under Workforce Management - Vacancy Real Time Content (required): I'm attempting to view the vacan…RyanPE 31 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha…