Analytics
Discussion List
-
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 23 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 11 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 21 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 41 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 82 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 75 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
-
ERROR: [94744] Failed to convert RPD to SMMLI was using Oracle BI Admin Tool to work on RPD and then upload to OAC. I was trying to upload RPD to Semantic model in OAC and I am getting below error. ERROR: [94744] …Prashant L 61 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 21 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to add a VB script to Oracle FRS reportNeed to add a VB script to Oracle FRS report to enable a macro step after downloading the excel output.Fredrick Ignatius 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
You don't have enough limits to add child tenancies.hi All, I am running a free tier account and trying to explore different Oracle Cloud services. I already have a tenancy where I have created a OIC instance. I would als…
-
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex…
-
How to add Header and footer in Each group of E-text Template ?I have e-text fixed base position template in which I want to add header and footer in each group of template. I made variable in SQL query but my requirement is not ful…Malik_Umer 32 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Helpdesk Requests that have Journeys assigned to them on an OTBI**This post was created as part of a How to Service Request (SR) Release: [Version] 11.13.24.04.0 Summary of the question: Can we identify Helpdesk Requests that have Jo…Bodhisattwa Mukherjee-Oracle 2 views 2 comments 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Join for sales order tables and Transfer order tables to bring transfer priceSummary: Hi All, I am trying to bring the Transfer Price of Sales orders of type Transfer orders. Please let me know the joins for Sales order tables and Transfer order …
-
Fusion Finance Analytical Reports Dashboard in FAWSummary: GL Account Analysis Dashboard in FAW enables user to analyze account activity from various sub-ledger sources supported in FAW like AP, AR, etc. contributing to…Baskar.Chakravarthi 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Error while promoting SME on FAWHi all, I'm facing an issue while trying to promote SME from my DEV FAW instance to me PROD instance… FYI : I've completed the latest upgrades of both instances (same la…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for HCM
-
What are the PVO's for IBY Tables for BICC ExtractCan someone please help me with PVO's that can be used for below tables for pulling data through BICC Extract. Tables : gl_coa_tree_versions_aggr_dtls, IBY_EXT_PARTY_PMT…Niharika Paramkusam-Oracle 32 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Performance Management
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
REST API in Oracle Digital AssistantSummary Please let me know if anyone has used the BI / OTBI Reports REST API in Oracle Digital AssistantContent Oracle Digital Assistant Version 1 -
ODA Value propositionSummary: Hello, I am looking to gather some information around following topics: Any metrics or data on the savings/benefits of using ODA (e.g., client X reduced help de…
-
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service