Tip
Discussion List
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 41 views 3 comments 1 point Most recent by Lee Eslick-Huff 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 341 views 10 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP -
Concatenating Values in a Database with 'for each' with a delimiterDear all, Is there a way to retrieve data using a 'for each' loop and insert a string between the values? For example: I have the following values in a database table: c…George Mattar 21 views 5 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
How to sort data in etext template using a hard coded fieldSummary: We have a requirement to sort data using a record type element. this element is custom and is the first column of the level and not present in the xml file. Ple…Abhilash K - Deloitte USI 54 views 3 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
Schedule Report > Dest FTP > Case When There is No Data > Ability to Not Generate Output FileSummary: BIP Report > Schedule Report > Destination FTP > Case When There is No Data > Ability to Not Generate Output File Content (please ensure you mask any confidenti…
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
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 71 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 141 views 2 comments 0 points Most recent by Lee Eslick-Huff 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 343 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…Ricardo V. 173 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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 61 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 23 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 261 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 32 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 421 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 61 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 62 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 42 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 301 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 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI 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 71 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP