Reports
Discussion List
-
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
-
Announcement: Financial Reporting change in behavior for valid intersections in 23.05UPDATE: This will no longer be an issue in 23.05, a bug related to this has been addressed. In the 23.05 release, Financial Reporting (FR) will now filter and restrict d… -
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…
-
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver…Naga Hari Krishna P-Oracle 41 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Database connection in FRS reporting studioSummary: New COA is not available when trying to create new database connection FRS reporting studio Please advise Content (required): Version (include the version you a…El1a 41 views 6 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
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
-
Two basic BI Report QuestionsSummary: Hi - I am using a custom data model which contains a mandatory parameter. I have defined the report output to default to Excel. I have 2 questions - please see …
-
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 83 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… -
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table… -
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 121 views 3 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM -
Updating the timezones for all users in bulk in EPM Narrative ReportingSummary: In Narrative reporting, users have not set their timezones, resulting in default date settings when running reports. This can cause inconsistencies in the displ…
-
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 41 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 61 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
In Cloud Data Model, is combining multiple Select using "With" Statement with trailing joins allowedSummary: Hi R&A forum: In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ? See Code snippet. Thank you, Content (required): In a Data Mod…
-
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 121 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…Sahil_Makhiza 61 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
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 52 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Oracle Reports Output to ExcelSummary: Working in Oracle EPM Cloud (Planning) and have reports the users want defined in Excel but, it limits to 100 worksheets when we need a 110 worksheets to genera… -
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 152 views 4 comments 0 points Most recent by Alona Aronov-Oracle Reporting and Analytics for HCM
-
Unable to See Values for Project Organization Name Parameter in project List OTBI Using Custom RoleSummary: We are using Custom role for projects and added required Duty roles to enable this OTBI report. But Unable to See Values for Project Organization Name Parameter…Rohit Kumar Singh 61 views 3 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
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
-
We are weighing the option of having Project segment in COA vs implementing Project moduleWe are considering 2 options to have reports for Project by having Project segment in COA structure or implementing full fledged functionalities. We are considering para…
-
TOC is not respected when merging reports togetherSummary: Content (required): Hi all We are experiencing that if we merge several reports with their respective TOC, when we want to publish them in one PDF the TOC is no…