Category 385
Discussion List
-
Is there any drop down option to have FRS reportBusiness is expecting to have FRS for Balance sheet. So expectation is to restrict the balance sheet values only to only Intercompany segment (Member) or Sub Account seg…Hemanth Buccapatnam Tirumala 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
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
-
What is the PVO for Currency and FND Valuesets in BICC?Need PVO details to create BICC extracts for below objects. • Fnd Value sets: We need to list the unique segment values for Chart of Accounts. Those are stored in value …Sreeram Tadepalli 31 views 2 comments 0 points Most recent by Sreeram Tadepalli General Ledger & Intercompany
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …Dhanusia 1 view 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting and Analytics for ERP
-
Different Child Data Set fields are not coming in Interactive format of BIP Report.I have modified the Data model of Compensation Report to increase the report performance in Oracle HCM Cloud (Fusion) After making different data sets, linking by parent…Bindu Janoti-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
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…
-
Hide Catalog menu item in Catalog BarBusiness users need to be restricted to access to entire catalog while executing reports. We have given page entries for reports to execute. So we thought to hide the me…SurendraPB 32 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
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 61 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 41 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to reduce execution timeHi, I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.…Madhu A 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
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 34 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 273 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 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 -
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 2 views 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 71 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 JohnCap 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…
-
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
-
Reporting on completed action plan actionsSummary: Hi, Our client wants to be able to report on when action plan actions are marked as complete, this is to ensure Next Gen Agents/ Case Workers/ Managers are comp…
-
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 21 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM