Tip
Discussion List
-
In our FRS Reports, the Description does not work unless you put first few charactersSummary: In our FRS Reports, the Description does not work unless you put first few characters that is you can’t search with string starting with asterisk, but for Name …Abhilash K - Deloitte USI 11 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Prompts are not currently supported for analysis that combine criteriaSummary: Combined two SA i.e "Projects Billing - Revenue Real Time" + "Project Performance Reporting Real time" and want to have 'Project name' as Prompt Value and it is…SBJ_PPM_1210 57 views 2 comments 0 points Most recent by Tomasz Kaniuk Reporting and Analytics for ERP -
Table for Bursting Output ResultsSummary: Does anyone know what table has the results of an individual bursting output from a scheduled BIP report? From the screenshot above you can see that we have one…Lee Eslick-Huff 63 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
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 31 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP -
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
Legitimacy of SQL Writing Softwares like Cloud MinerSummary: Content (required): Hi Gurus, Recently, we heard that softwares like Cloud Miner is helpful in writing SQL query in Fusion BI without the need to create a repor…Ganesan J 276 views 2 comments 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
How to use the "is based on the results of another analysis" filter operatorSummary: We created two analysis in OTBI and put them in a dashboard. The one report drills to the second report via action links. The second report is using the filter …
-
How invoke an Web service using an Analysis in OTBI?Summary: Use an Invoke web service get and push the information in another system Content (required): We have a proposal to active an web service when a field in Transac…
-
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
Can we select a range of member values in the prompts while running a FRS reportHi Team, We have a requirement to provide prompts for running an FRS report, wherein we can select a range of values, like 'From' and 'To' option while selecting account…Srishti Kedia-Oracle 31 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 11 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 183 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can we add attachments using sandbox?Summary: We have a business requirement that the users wants to attach documents in the Supply Request Form. Can we add attachments '+' using sandbox? kindly guide us ho…Immanuel Abishek 31 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 145 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
How to default System Date using Sandbox?Summary: We have one requirement that we need to default the system date in the Supply Request Form Content (required): We have one requirement that we need to default t…Immanuel Abishek 47 views 0 comments 0 points Started by Immanuel Abishek Reporting and Analytics for ERP
-
eText Templates seeded sample templatesHi , From where can we download some of the seeded eText Templates used in Oracle for payment formats. Can anyone please share the exact path in the BI catalog. Thanks V…
-
Template for large BIP reportHi Which template is it recommended to use if we need to generate reports which require layouts with many columns. Using the wizard for creating .xpt reports, it is diff…
-
How to calculate number of periods based on the start date & end date of a GL PeriodSummary: Hello experts, I have a requirement to calculate the number of periods for a particular Invoice Multiperiod Accounting dates mapped to. For example, if the mult…Satyavrat_Savarn 66 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Populate DFF value in Journal Screen based on another field in JournalSummary: Define a DFF at the journal line level and default the parent level COA segment value in this DFF based on the child level COA segment in the journal line COA.…Abhilash K - Deloitte USI 31 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Find all emails sent by OracleSummary: Find all emails sent by Oracle Content (required): Hi, An email should've been sent to a user once he did the reception in Oracle but it seems he didn't receive…Antoine.Kaiber 152 views 1 comment 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…Abhilash K - Deloitte USI 52 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…sailesh_cloudare 31 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP
-
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…Abhilash K - Deloitte USI 22 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI 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…Bernard T 1.1K views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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 775 views 5 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio…sailesh_cloudare 41 views 0 comments 0 points Started by sailesh_cloudare Reporting and Analytics for ERP
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 61 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Report to have budget transfers (Control budget)Summary: Content (required): We have a requirement to have a report to include the Budget transfers. We tried to get it from the standard reports however, there is no re…
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…