Tip
Discussion List
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 47.6K views 129 comments 30 points Most recent by Dileep P Reporting and Analytics for ERP -
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 628 views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
Is there an audit trail for Location Based Access entries?Summary: Oracle Fusion 25A In Security Console > Administration > Location Based Access, IP addresses can be added to restrict access by location. Is there an audit for …
-
how to load jobrequisitions.dat with minimal mandatory fields onlySummary: I went through the below documentation before i started doing a basic load of open job requisitions, as part of our data migration requirements: " Examples of L…
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 36 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…SuniChacko 231 views 5 comments 1 point Most recent by suamanch-Oracle Reporting and Analytics for ERP
-
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…
-
Redwood Time Card Change History Errors "We couldn't find any audited data for this time card"Summary: Log in as user Modify an existing time card Change the hours, select a change reason, and save it. Toolbar > Click … Change History Save it Click Details next t…Vincent T 22 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi…Abhilash K - Deloitte USI 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
FTP Files of BI Publisher Report Via Bursting > Defining The Bursting QuerySummary: FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query Content (required): Hello All, We would like to send a report generated in CSV forma…
-
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based…
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 65 views 2 comments 1 point Most recent by User_0P0CT Reporting and Analytics for ERP
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 21 views 3 comments 0 points Most recent by Toyesh Patra Reporting and Analytics for ERP
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…User_2025-02-11-06-12-35-024 765 views 11 comments 0 points Most recent by Eswarvoona-Oracle Reporting and Analytics for ERP -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include …Lucky Sharma 13 views 2 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Cannot access name on errored out EssBIPJobSummary: 24C version The errored out process name is not displayed, when i check from Report job history page, not able to check the details of this ess bipjob, can anyo…Shahid Qureshi 32 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Need SQL Query for Project Custom ReportSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …Awal 22 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
What is the Retention policy for BIP Jobs run in Fusion ERP Cloud?Summary: What is the Retention policy for BIP Jobs run in Fusion ERP Cloud? Do we have more information on maximum value/minimum value for retention? Also Is there a cos…Abhilash K - Deloitte USI 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be…Abhilash K - Deloitte USI 51 views 2 comments 0 points Most recent by AnupamAgr Reporting and Analytics for ERP
-
Synchronize Hierarchies from EPM to ERPIn EPM, we have established a project hierarchy under an "All Projects" node, with dimensions assigned by department. Our goal is to ensure these hierarchies are accurat…
-
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 910 views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
wrong postSummary:Version (include the version you are using, if applicable): 24D
-
Order Management Extension to copy Inventory Organization from Original Sales Order to RMASummary: Customer needs to copy warehouse information from the original sales order when creating a referenced RMA but we couldn't do it using pretransformation rules. I…
-
How to print previous period in smart view reportsHello All, I need to print the account value for current period and previous period. In FRS we have the relative period function that helps us print the pervious period.…ShitalRamteke 2 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 22 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar…
-
Asset Transaction Real time is not showing dataSummary: when I select Asset number and invoice number just these two columns from several folders of the above Asset subject area, report is not fetching any data, howe…
-
Group Project Tasks by Task NameSummary Group Project Tasks by Task NameContent We have a standardized work breakdown structure and would like to compare costs for the same task across projects, right …Prasanna Reka-OC 38 views 1 comment 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP -
scheduled report not getting data in output filewe have scheduled a report on daily basis to the SFTP folder using the destination while scheduling reports. Reports are scheduling but not showing data in the output ge…Dara Nagasai 37 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to create a hyperlink to another sheet within same excel -BIP report Excel templateSummary: I am trying to create an Excel template in which there are 2 tabs. One will have budget control balance details and other sheet will have PO details. Expected f…Rekha Jose 24 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP