Reporting and Analytics
Discussion List
-
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 81 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…
-
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can …
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 246 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 21 views 0 comments 0 points Started by Yahya Khan Reporting & Analytics for Fusion Service -
Is it possible to add conditions in etext template like when there is no dataSummary: Hi Everyone, We have a requirement not to show ("") double quotes in text output when there is no data returned from the output Can we add conditions in etext l…Bhanu Priya 157 views 3 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
REST API for FDI Fusion Data IntelligenceIs there a REST API available for FDI (aka FAW)? We have a requirement to initiate an incremental refresh of the FDI data after a specific event in an OIC orchestration.…TimMcK 282 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…KDR 182 views 6 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Recommended architecture for establishing Print Server in DMZ for Oracle fusionRecommended architecture for establishing Print Server in DMZ for Oracle fusion. Print from Oracle Fusion over the public Internet to an on-premise printer or print serv…Mohammed Imran-Oracle 11 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Identity and Access Management
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…
-
How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th…
-
I am creating a data extraction query, but cannot fetch rule name and to link to discount list.Would appreciate help if you could provide the table name and the respective join for this.
-
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…
-
Add Supplier Name in Account Analysis ReportSummary: Would it be possible to add a Vendor Name column under the Account Analysis Report for all source related to Payables and Receipt Accounting? We have a custom r…Akshitha Vyas 31 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_ITEM_INSTANCES_HSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_ITEM_INSTANCES_H? Content (required): Version (include the…
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…Bobba Anil 61 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…Isaac_s 53 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
Equivalent Oracle Cloud table/view for the EBS 11i entity QA_CSI_ITEM_INSTANCESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity QA_CSI_ITEM_INSTANCES? Content (required): Version (include th…
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…Jessamyn Donovan 21 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 31 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,…Gurujothi D 374 views 4 comments 3 points Most recent by Hugo Martínez Reporting and Analytics for SCM
-
Transaction table limitation in performance goalsHi Team, Please find my concern below: There is a limitation on transaction table "fa_fusion_soainfra.wftask" to store data only up to latest 3 months. I want to know if…
-
Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…Sateesh Kumar 51 views 3 comments 0 points Most recent by Praveen Kumar Ponnusamy Reporting & Analytics for Fusion Service
-
how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables
-
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…
-
New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a… -
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 11 views 0 comments 0 points Started by Raghu_Nandan Reporting & Analytics for Fusion Service
-
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca…