Tip
Discussion List
-
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 16 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 15 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 13 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 13 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 24 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
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…
-
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 13 views 0 comments 0 points Started by Immanuel Abishek Reporting and Analytics for ERP
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 315 views 7 comments 8 points Most recent by JatinderSingh 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…
-
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 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Where can we see warnings after FBDI import of customersSummary: Where can we see warnings after FBDI import of customers Content (required): Where can we see warnings after FBDI import of customers. I cannot find them in the…Lucky Sharma 106 views 9 comments 0 points Most recent by Mayank Kumar-Oracle 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 22 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 33 views 1 comment 1 point Most recent by Prasanth Senthivel-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 32 views 1 comment 1 point Most recent by Raghavan p-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 14 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
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 25.9K views 97 comments 27 points Most recent by Dan Bsales 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 32 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…
-
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 314 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 22 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 63 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…
-
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 52 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP