Reporting and Analytics
Discussion List
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 13 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 30 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Create tables(DDL) from PVO metadata provided by REST APIWe are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata) Url: https://{server_name}/biacm/rest/meta/da…Alex25 24 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_II_RELATIONSHIPS? Content (required): Version (include the…
-
Extract data from Oracle Fusion via BI Publisher to perform calculations and then load them into EPMHello! I have some Oracle Fusion data in BI Publisher. I need to use this data as a basis for performing some calculations and then load the calculated information into …User_F8Z0S 24 views 2 comments 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 37 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
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 217 views 2 comments 1 point Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
General Ledger Journal Entry Database InquiryHi Oracle Experts, I have a question regarding the General Ledger Journal Entry report. Could you please clarify if the field JRNL_Effective_Date refers to the journal c…
-
Actionable infoletSummary: Actionable infolet Content (required): Hi, Is it possible to build an actionable infolet for Service request? Version (include the version you are using, if app…User_9UU2H 26 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
interactive output format query parameters are not working when new fields are addedhi all, I have a BI report which i have built with the report out put format as interactive. this report has two input query parameters. i have recently add two new attr…Akula123 23 views 2 comments 0 points Most recent by Radhika Abhyankar-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. 18 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
how to exclude our custom application data from being picked by Account Analysis Report?Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each day). Whe…Sathish Ravi 33 views 2 comments 0 points Most recent by Sathish Ravi Reporting and Analytics for ERP
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…aIgnacio 19 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for HCM
-
Query to fetch absence plan balance history detailsHi Experts, Greetings of the day!! We have a requirement to get all the absence plan balance history details. We need all individual entries like Periodic accrual, Carry…Divya Kollipara 71 views 3 comments 0 points Most recent by Deepika J Reporting and Analytics for HCM
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 35 views 3 comments 0 points Most recent by Hussian Sharief M-Oracle Reporting and Analytics for ERP
-
supplier bank account change report, 'last updated by' column showing 'FUSION_APPS_PROV_PATCH_APPID'Summary: Recently Quarterly Fusion 24A patch and console conversion completed in my oracle fusion fiancials. Today Business tried to ran the custom supplier bank account…
-
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 19 views 2 comments 0 points Most recent by Dona Sengupta Reporting & Analytics for Fusion Service
-
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 80 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM
-
Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co…MD-JMS 100 views 2 comments 1 point Most recent by Radhika Abhyankar-Oracle 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 117 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 37 views 5 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Sp HTTP 500/504 errors when using SOAP API in using BI PublisherSummary: My team makes calls every 30 minutes to BI Publisher through a SOAP API to retrieve information we need to update tables on an on prem database. We are making t…StefanyD 23 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
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 23 views 2 comments 0 points Most recent by Mayur_P Reporting & Analytics for Fusion Service
-
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 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…Joliver Caangay 1 view 2 comments 0 points Most recent by Joliver Caangay 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. 16 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service
-
Looking for some prebuilt dashboard for AP productivity metric in FAW(FDI)Summary: Productivity metrics like no. of invoices by processor Content (please ensure you mask any confidential information): Version (include the version you are using…
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 35 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for ERP
-
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 19 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Negotiations Abstract summary Page customizationsHi , we have requirement to hide few fields on abstract summary page. Setup and Maintenance -> Manage Procurement Business function -> Under Sourcing -> Configure Abstra…