Reporting and Analytics
Discussion List
-
Fast Formula of Type HCM Data Loader does not loop to LINEREPEATNO = 2Summary: Hi Intelligentsia, With reference to development of Fast Formula of type HCM Data Loader i am unable to loop to LINEREPEATNO 2 or the else part after LINEREPEAT…Abdulrahman2k 55 views 1 comment 0 points Most recent by Raghavendra M Payroll and Global Payroll Interface (GPI) -
How we can invoke multiple templates/Grids in FRS reporting based on the input parameters ?how we can invoke multiple templates in FRS reporting based on the input parameters. Unfortunately, we have not found any functionality to invoke multiple templates like…Vikas Prajapati 32 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
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 33 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Payment Approval HistorySummary: We need the payment approval history data to capture the approvers at template level Content (please ensure you mask any confidential information): Hello Team -…Samarpit 187 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for ERP
-
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 1 view 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 …
-
Is there a simple way to create a report based on Service request, Work Order and Debrief?we are working to create a report that will include information from the Service request and all the work that was done by the engineer. the entity structure we need (or…Boaz Hayon-Oracle 1 view 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
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 31 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Performance Management
-
how to convert Universal time to CDT timeSummary: PROCESSSTART is displaying as 2024-06-06T06:03:22.173+00:00 (Universal time) in table fusion.ess_request_history. Could you please Help how to convert Universal…Rama Krishna Annam 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Data flow in fusion.ess_request_history table while Running the BIP Report which was scheduled.Below are values populated in fusion.ess_request_history table while Running the BIP Report which was scheduled. state value is 3(Running),processend is NULL value and E…Rama Krishna Annam 73 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
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
-
Does anyone have an idea on how to Call Third Party API from Fusion via ESS JobSummary: We have a standalone Oracle DB and and API that exposes the data from a specific table. Since we can't connect OTBI to other DB, we just want to be able to call…PeterXavier 11 views 2 comments 0 points Most recent by John Ferguson Reporting & Analytics for Fusion Service
-
Which table contains Credit Management, Credit scoring model detailsCould you please provide the name of the backend table where the details of credit collection data points, such as category, data point name, DataPointId, data type, and…Jeetesh Singh 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
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
-
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Inquiring about business object in audit reportSummary: Hi team, Please help us with the following questions: 1. What kind of log will appear when Business object type is not selected and is blank? 2. Are there any b…Zafar Ara Nawreen 23 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
How to Customize the Asset Register Report to remove special characters from asset descriptionI have to update the Data model query for Asset Register Report as the report is reading the special characters in asset description and resulting in distorted format of…Shikha_Singh12 31 views 5 comments 0 points Most recent by Shikha_Singh12 Reporting & Analytics for Fusion Service -
I need Time Elapsed from Report run History in Fusion HCMI ran the report in Fusion HCM I need to know how much time taken to complete the report Is there any way to know how any records in report out putRama Krishna Annam 11 views 2 comments 0 points Most recent by Rama Krishna Annam Reporting & Analytics for Fusion Service
-
how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 11 views 1 comment 0 points Most recent by RajuT Reporting & Analytics for Fusion Service
-
Chart not showing in bursting email in fusionDear Team, I have developed one report where we are showing chart in the output. Same output we are sending over the email through bursting query and the output is comin…
-
Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web…
-
A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…Jim Jam101 11 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…MD-JMS 55 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…Aaron Paul 1 view 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Separate heading for two grids in FRS reportWe have two grids in FRS report, is it possible to have separate Header for two grids?Hemanth Buccapatnam Tirumala 11 views 3 comments 0 points Most recent by Komala Reddy-Oracle Reporting & Analytics for Fusion Service
-
Unable to find table name for files uploaded on content server by partnerSummary: My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server and the external user/…Abdulrahman2k 2 views 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
-
Is the Standard AR Aging Report working after 24B Patch Upgrade?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nehsingh 21 views 2 comments 0 points Most recent by Ankita Ankita-Oracle Reporting & Analytics for Fusion Service
-
Is any possibility to Fetch Report Last run details ( BIP or OTBI reports)?Is any possibility to Fetch Report Last run details ( BIP or OTBI reports) Can anyone tell me that is oracle capturing the information for the Reports (BIP or OTBI) last…User_7A1QO 16 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting & Analytics for Fusion Service