Tip
Discussion List
-
Difference between Ess Job Derived attributes and AttributesSummary: Content (please ensure you mask any confidential information): We are creating Custom ESS job for one custom report requirement. We need know, what is the real-… -
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr… -
Create an AP invoice using supplier number instead of supplier name in the REST API payloadSummary: Currently the payload to create AP invoices requires to enter the supplier name to create the invoice, since the source system is not Oracle the characters may …Octavio Aguirre 11 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Customer require to extract FRS report data in XML or SQL format. Is this possible?Hi All, Customer require to extract FRS report data in XML or SQL format. Is this possible?Janitha Perera 3 views 2 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 112 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 1.4K views 1 comment 4 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Need a query to get accounting period of a POWe are unable to find a way to get an accounting period for a purchase order. Could you help with a query? I need the PO# and the accounting period as a column. Also, le…Abhilash K - Deloitte USI 24 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 21 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Can we access dashboard prompts value in URL as Dynamically in BIP Report?Summary: Hi Experts, We are having a requirement, whenever user clicks on count then it should redirect to the detail report for those specific values selected in Dashbo…
-
secure flexfield by role on Purchase requisition lineSummary: Hello, Is it possible to secure a DFF on the requisition line by role ? Content (please ensure you mask any confidential information): Version (include the vers…
-
How to use Projects related Condition in AP Invoice Approval RulesSummary: We need to use Project related conditions in the AP Invoice Approval Workflows. Please suggest. Content (please ensure you mask any confidential information): W…Narasimha Rao Kondapalli 13 views 4 comments 0 points Most recent by Meghana Gaddam-Oracle Reporting and Analytics for ERP
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 1.9K views 14 comments 15 points Most recent by Bea Reporting and Analytics for ERP -
Recommendations to generate a delimited output over 5GB in FusionAre there any recommendations to generate a delimited output over 5GB without timeout and going into error using a report in Oracle fusion. Currently we are generating e…Abhilash K - Deloitte USI 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …Giuseppe Galluzzo 11 views 2 comments 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for ERP
-
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati…Abhilash K - Deloitte USI 2 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?Abhilash K - Deloitte USI 1 view 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur… -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 305 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Pros/Cons of creating an ESS job for a custom bi report versus not create a ESS job?Hi Community, Are there any advantages or disadvantages for creating an ESS job for a newly created custom bi report versus not creating a ESS job for it?Abhilash K - Deloitte USI 32 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Bhavani Rikkula 31 views 2 comments 2 points Most recent by Nagaraju Upputuri Reporting and Analytics for ERP
-
How to hide compatibility checker in Excel while opening excel template based outputs in Fusion?Users are complaining for showing the below message while opening the excel report outputs.How to hide this?Abhilash K - Deloitte USI 11 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 63 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…JayK 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Make every report output display date in PST timezone instead of UTC in Oracle FusionSummary: Hi Team , is there a way that you are aware of in oracle cloud that we can make the report to run in California timezone instead of default UTC timezone of clou…Abhilash K - Deloitte USI 222 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
how to add unpaid reason under transaction tab for collections dashboardSummary: how to add unpaid reason under transaction tab for collections dashboardSwapnil Sapkal 21 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 154 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP