Analytics
Discussion List
-
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …Vivek Gautam 231 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
What is the impact of renaming a Fusion Analytics DataWarehouse DBaaS Database?Summary: We've deployed Fusion Analytics Warehouse as a PaaS service (Version 24.R1.P3). As part of that deployment, the DBaaS instance is created simultaneously, but we…Clay T. 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Until when would the request be considered active?Summary: Until when would the request be considered active? Content (please ensure you mask any confidential information): For queue purposes, client would like to know … -
Where can i find Item Drawing Number in Oracle Fusion ERP tables ?I Am trying to search for "Drawing Number" in oracle fusion ERP tables, it might be an Attribute but I am not getting in which table I can find this attribute. Please re…Dona Sengupta 13 views 2 comments 0 points Most recent by Dona Sengupta Reporting & Analytics for Fusion Service -
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 113 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Is it possible to track BIP report logs where user has not submitted a report jobSummary: A user logs in to Report & Analytics and opens any custom BIP report to view/export output, without submitting a report job. We are looking to get table/report …Mayur_P 22 views 2 comments 0 points Most recent by Mayur_P Reporting & Analytics for Fusion Service -
How do we scheduled the processes associated with our profile options?Summary: How do we schedule our processes associated with HRHD IN WAITING DAYS, HRHD AUTO CLOSE, etc? We have SVC_HRHD_IN_RESOLVED_DAYS set to 30 days… will the process … -
Contract duration is displaying no data on FAWHi, I've been trying to create a simple report to show the contract duration of the new hires in a company for a specific month. My reports should look like that where T…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 42 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service -
How is the average time for all calculated?Summary: Hi, how is the “Avarage time for all” resolution time calculated (see screen) Is it calculated on the working calendar? Or is it counted on the 24-hour day? Tha… -
How to export the resource detailsHi Team, To add the agents, I heard that we have to add a resource first. But I couldn't see the tasks to identify the resource. 1.Is it possible to see the existing res… -
FDI Report AccessHi, I am currently unable to see any workbooks in the FDI environment but a different user is able to for the same environment. What would I need to change for my accoun…User_EO6AY 42 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Can we build a GTI dashboard for GTM Registrations?Summary: License data can be pulled to GTI dashboard via ETL but not sure if we can pull the GTM Registrations data too to build a GTI dashboard Content (please ensure y…Hemant Kumar Salvi 11 views 3 comments 0 points Most recent by Hemant Kumar Salvi Global Trade Management -
Error occurred while bootstrapping the model deploymentGot an error while using the model deployment in OCI Data science module. "Error occurred while bootstrapping the model deployment. Error occurred while starting the web… -
Change the source environment for FAWHi, Our FAW dev instance is linked to an HCM test environment which has not been refreshed recently.., I'l like to change the source with another HCM test environment wh…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
FAW average assignment calculationHi, I have a report to produce using the assignment count KPI for different years. I've been struggling in FAW to create the calculation that would allow me to display t…Lauriane Massin Whitaker 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Best way to create reports from Oracle General Ledger data?What's the recommended approach for building custom reports from Oracle General Ledger data.I'm building a custom periodic trial balance report in Oracle. I need to incl…Omran Zeaiter 21 views 4 comments 1 point Most recent by Jagdish Kumar Arora General Ledger & Intercompany -
Can we create custom folder in UCMHi Team, Can we create custom folder on UCM.vikram khengare 22 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Possibility to combine multiple rows into one cell in Oracle SQL data base.Summary: I have a query regarding the possibility to combine multiple rows into one cell in Oracle SQL data base. We have tried STRING_AGG, LISTAGG and WM_CONCAT, but no…Lizy Lazaro 13 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to create a new compartmentSummary: I have activated my new OCI free trial account, as suggested by Oracle Support I waited for 24hrs to get provisioned with all resources while creating my tenanc… -
Oracle HCM Implementation Gap analysisSummary: Our organization is nearing completion of a two-phase Oracle Cloud HCM implementation encompassing Core HR, Talent, Performance, Succession, FAW, Compensation, … -
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 41 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM -
Is it possible to zip multiple template layout outputs from a single report into a single file?I'm looking to understand if there is a way to consolidate multiple template layout outputs from a single report into a single zipped file. If anyone has experience with…Omran Zeaiter 22 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
Help Needed with URL Navigation in Notification via REST APIDear All, I am trying to attach a URL to a notification using the REST API endpoint: /fscmrestapi/resources/11.13.18.05/atkpopupitems. I am using the following body requ… -
FAW reportingHi everyone, I was wondering where I could find a list of all the kinds of reportings that can be done with FAW (in the fied of Human Resources )? Thank youLauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BI Publisher template builder for Excel and Word Plugin in Microsoft integrated appsSummary: Hi Everyone, Our customer is moving to Microsoft integrated apps where all manual plugins will go away. Which means any plugin will be handled in MS Office 365 …Murugaganesh 44 views 4 comments 0 points Most recent by Murugaganesh Reporting & Analytics for Fusion Service -
FAW native analysis with external dataHi, I was wondering whether or not we could use the native/pre-configured analysis provided by Oracle in the FAW console adding external data to these pre-configured rep…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to convert PERIOD NAME to Date data type?Hi I am using Between operator in Period Name and it is not working. Period Name is a Varchar type. How to convert it into Date data type so i can use between operator i…Khushi 81 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Not able to print parameter values in BIP report, using if condition in Excel rtf templateUsing if condition in excel template had validated values if parameter is null , should return all as values selected is ALL, see below All But when i am populating spec…Shahid Qureshi 65 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Can we build a BIP report for the child processesCan we build a BIP report for the child processes that are run after after load interface file for import.Shalini S 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service