Reporting and Analytics
Discussion List
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
How to replace special characters in etext templateIn one if the interface (HCM extract) we are using DBI item as 'Bank Account Name'. For one of the records, it is bringing the special character as Esmé but we need Esme…
-
Custom ESS job is running long for one particular userWe have custom ESS job which is running long for one particular user. For other users it is completed in 3-5 mins for the same parameters.(Both users are having same set…Thanigainathan R 4 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Export Material plan into Excel for all items to review supplies, demands and net inventoryHi there, We are looking for the ability to export the 'Material Plan' view in Fusion into Excel for all items. Issue we are hitting is the 'Material Plan' view does not…Tom Harris 39 views 2 comments 0 points Most recent by Sandeep Pati-Trinamix Supply Chain Planning and Collaboration
-
How to pick delivery method (online or offline) on the report defined in development goal pageOn the development goal page we have attached the course as a training and that course has DFF of online training or offline training defined on create course page, now …
-
ORC Job Offer Letter has got a different font than the RTF Template.Hi Team, I am currently facing an issue on the Job Offer letter in ORC,the customer is using their own custom font style for branding purpose. I am using the same font s…Beatrice C 32 views 1 comment 0 points Most recent by PatriciaS-Oracle Recruiting, Opportunity Marketplace
-
invoice_id is blank in ap_trial_balances_gt tableHello All, We have a requirement to create a custom Payables Trial Balance Report by copying and customizing the data model to add more columns from ap_invoices_all tabl…DebasmitaDas123 36 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to get same data in two data sets in the same data model without any data model link.We have 2 different data sets in the same data model, and we have a common column in both the data sets but without a link. Can we get same data based on the common colu…Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
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 83 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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 324 views 4 comments 0 points Most recent 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 208 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 340 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 186 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 23 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 …
-
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 34 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 63 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 66 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 14 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 26 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 32 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 410 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 52 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