Tip
Discussion List
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th… -
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…Nageshwaran1 857 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…OraFusionworld 57 views 0 comments 1 point Most recent by OraFusionworld Reporting and Analytics for ERP
-
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…User_2025-02-04-18-03-15-131 39 views 3 comments 1 point Most recent by User_2025-02-04-18-03-15-131 Reporting and Analytics for ERP -
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
show project number on GL reportsSummary we building a report to show subledger details like invoice number , supplier etcContent we would like to figure a way to show project number on the GL report we…Sam Solomun 71 views 2 comments 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 121 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks.User_2025-02-04-05-26-22-197 46 views 6 comments 1 point Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 163 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
Lineage document for Oracle Analytics For Fusion ERPSummary This document provides the lineage report from Subject Area to data warehouse table and column.Content Enclosed Oracle Analytics For Fusion ERP subject area to d…Ramamurthy Shankarachetty-Oracle 173 views 1 comment 1 point Most recent by Chandra Yerra Reporting and Analytics for ERP
-
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…Tony Roff 37 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…User_2025-02-01-07-43-15-700 60 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has …Jennifer Wolfe 57 views 5 comments 1 point Most recent by Michael Cook Reporting and Analytics for ERP
-
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line…
-
rtf template - display constant text on every pageContent Hi All, I have a rtf template which contains nothing but a (row*column) table. I need to display a constant text like "Hello" at the bottom of every page, other …Rinku Gautam 85 views 12 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
How to save a report output with date suffix?Summary How to save a BIP report output with date suffix.Content I managed to get a complete XML output using select query with XMLELEMENT () tag using Data Model. Now I… -
Subledger Distributions to General LedgerSummary Subledger Distributions to General LedgerContent All-> Need to show the amounts of Invoice distributions/Matched/not matched POs related to Payables payments/rec…
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Fusion table which store all Data Model SQL?Content Hi, Can anyone share Fusion table(s) which stores SQL's of all data models? Thanks, RinkuRinku Gautam 261 views 5 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…Avesh Ganodwala-57885 205 views 0 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
Key Flexfields and Descriptive Flexfields Supported in OTBI FinancialsSummary The purpose of this White Paper is to help clarify the Key Flexfields and Descriptive Flexfields supported in OTBI Financials and the subject areas in which they…Veronica Dumitriu 158 views 10 comments 9 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
BI Publisher : Setup Data Source and extract data from itContent Hi, In BI Publisher, I am looking to setup a new data source to extract specific business unit related from it in the data model. Also, Out of all the data sourc…Rinku Gautam 55 views 3 comments 0 points Most recent by Milind Dalvi Reporting and Analytics for ERP
-
Parameters Appear Under Data_DS in CSV FormatSummary How to remove the Parameters appearing as fields in CSVContent Hi, We are currently working in a report and the data model is bringing through the fields require…User_2025-02-03-21-40-10-404 52 views 9 comments 2 points Most recent by Wendy Ware Reporting and Analytics for ERP
-
Remove first blank page of BIP report having rtf templateContent Hi, In a rtf template linked to Customer invoice in Fusion Cloud, I am having 2 IF loops inside which, are sections breaks (continuous & next page). It works fin…
-
Data restriction on Data Model in Fusion CloudContent Hi, I am trying to restrict data to users having privilege to create Data Model wrt business unit e.g: There are 2 business units BU_1 and BU_2. If a user logs i…Rinku Gautam 69 views 6 comments 1 point Most recent by Manish Pesswani Reporting and Analytics for ERP
-
BIP Report Parameter - DATE & TIME - TIME ZONESummary DATE & TIME - TIME ZONEContent Good People, How to create BIP report parameter in yyyy-MM-dd'T'HH:mm:ss'Z' format and compare it with last_update_date ? Thanks, …Soumya Prakash Parhi 152 views 1 comment 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Rtf Template : Print specific texts on specific pagesSummary Oracle Fusion BIPContent Hi All, In Oracle Fusion BI Publisher, I need to print certain texts on specific pages depends on how many pages gets printed in Custome…Rinku Gautam 121 views 4 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
BIP Report ParametersSummary BIP Report ParametersContent Hi -> BIP Report Parameters: Can we make BIP report parameters in the required order if there are more parameters. Ex: I have 20 par…Amarnath Govindu 61 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP