Analytics
Discussion List
-
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …Ashu Singh 13 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ritu123 14 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…User_VJWD5 59 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 7 views 0 comments 0 points Started by Dineshkumar.A-Oracle Reporting & Analytics for Fusion Service
-
Offer details are not getting stored in transaction table (HRC_TXN_HEADER)When an offer is sent for approval and after approval if the offer is "Re drafted" and edited then the table "IRC_OFFERS" is storing the latest data. Whereas i need to f…Nalsoft Pvt Ltd 9 views 0 comments 0 points Started by Nalsoft Pvt Ltd Reporting & Analytics for Fusion Service
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…
-
Does Oracle Analytics publisher desktop needs licensing?We are already using Oracle Fusion cloud. For creating BI report templates, we would require Oracle Analytics publisher desktop. Do we need additional license to downloa…
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 10 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
which field should I use for the Validation Status of AP Invoices?I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status.Alvin 4 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…Ritu123 7 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
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 32 views 2 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Fusion Service
-
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 6 views 0 comments 0 points Started by Pandeyujjwal007 Reporting & Analytics for Fusion Service
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…Ramsha Zameer 14 views 0 comments 0 points Started by Ramsha Zameer Reporting & Analytics for Fusion Service -
How to Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
How to fetch Additional Communication settings under Recruiting Messaging Configuration in sql queryHi Team, We are unable to fetch Additional Communication settings under the task "Recruiting Messaging Configuration" in oracle table. Could you please help us in fetchi…Garvit Garg 15 views 0 comments 0 points Started by Garvit Garg Reporting & Analytics for Fusion Service
-
How to download .PDF attachment from Contract through BIP report in fusionDears, We have a requirement to download .pdf attachment from contract. How we can download the above attachment (24000065-1 (1)نسخة التوقيع.pdf) from BI report. Thanks,…
-
Feasibility of Dynamic Conditional Account Insertion in Financial Reporting Studio (FRS)We are implementing a financial report in Oracle Financial Reporting Studio (FRS). The business requirement is as follows: Based on the sum of two accounts (18600000 and…Patrick Chrabieh 14 views 0 comments 0 points Started by Patrick Chrabieh Reporting & Analytics for Fusion Service -
Getting Duplicate data on performance and goalsGetting Duplicate data on performance and goals when employees checking from Me >> Performance >> Employee is able to view the list of goals of other employees from his …Shivani Karna 14 views 0 comments 0 points Started by Shivani Karna Reporting & Analytics for Fusion Service
-
Getting not a group by function for the query in BIP reportGetting : ORA-00979: not a GROUP BY expression for the query in BIP report. Below is my query I am getting this errow while adding any sub query(Payment Terms). In the g…
-
Can I have multiple logos for 1 only income statement FRS report?Kindly find the below: The client want more than one logo used in the same income statement created in financial reporting center is there any way? thanks for help, Rega…Anthony Sleiman 41 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
REST API for FDI Fusion Data IntelligenceSummary: REST API for FDI Fusion Data Intelligence to GET the information of users, groups, application roles, and data access Content (please ensure you mask any confid…
-
is it possible to have access for specific entities in FRS report(income statement)?Dear all, Kindly find the below: the client want to have access in the FRS income statement for each entity to not show all the income statements available in the financ…Anthony Sleiman 21 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
how to edit Supplier negotiation invitation email subjectSummary: I need to change/edit the supplier negotiation invitation email subject which is sent to suppliers to invite them to negotiation. Content (required): I need to …
-
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 …
-
OTBI Prompt to control AORIn OTBI, can we control the prompt list of alues based on area of responsibility. Example - if the employee is tagged to abc, xyz & 123 legal entity, then when opening t…Suganya v 13 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
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 31 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 31 views 1 comment 0 points Most recent by PatriciaS-Support-Oracle Recruiting, Opportunity Marketplace
-
How to display the content of the PO PDF document in the Email body of the Approval NotificationApart from getting the attachment as a PDF, need to display a few columns in the email body as well
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 11 views 1 comment 0 points Most recent by Shahid Qureshi Reporting and Analytics for ERP