Tip
Discussion List
-
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 88 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 208 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 201 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 159 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 56 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…
-
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 68 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 150 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 111 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
-
BPM - capture comments in a ReportSummary BPM - capture comments in a ReportContent Hello All, We have a requirement to build the report to fetch all the invoices where Approvers either Rejected or Reque…
-
CSV output Date FormatSummary CSV output Date FormatContent Hello all, I have created one Report using new data model (OBIEE data source) and an Subject Area Analysis based query. I have crea…Animesh Agrawal-79521 73 views 14 comments 2 points Most recent by Kamrul Alom Reporting and Analytics for ERP
-
Bursting : Split Files by Number of RecordsContent Good People, How can we split files based on number of records in BI ? e.g. Say the extract is having 700 records , I want it to be split into 4 files , 3 of 200…Soumya Prakash Parhi 59 views 2 comments 2 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
BI Publisher Report printing in PCL PrinterSummary PCL PrinterContent Good People, How to use BIP to print documents in PCL Printer ? I mean how to convert PDF to PCL in BIP ? or Generate the PCL output using BIP…Soumya Prakash Parhi 45 views 0 comments 2 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
How to show PO Number from Lines PageSummary How to show PO Number from Lines Page -- rtf templateContent Hi All, We have an custom requirement of printing Purchase Order Number from PO lines pages from eve…Amarnath Govindu 45 views 2 comments 0 points Most recent by Amarnath Reporting and Analytics for ERP
-
OTBI - To Display Sum of a column based on other column in New ColumnSummary OTBI - To Display Sum of a column based on other column in New ColumnContent Hi, I want to Display Sum of a column based on other column in New Column in OTBI An…Murali Gangidi 717 views 8 comments 1 point Most recent by Murali Gangidi Reporting and Analytics for ERP
-
Credit Memo Generation on Receivable Invoices via SOAP APISummary Generation of Credit Memo (Refunds) on Receiables Invoices (Transactions) using oracle available SOAP API.Content Hi Friends, (Please correct me if i've posted i…M Kashif Raza-52184 29 views 2 comments 1 point Most recent by Jairo Reporting and Analytics for ERP
-
BI Publisher Reports - Default Email AddressSummary I would like to change the Current default email address which currently is bipublisher-report@oracle.comContent When running BI Publisher reports and selecting …Angelo Cretella 52 views 4 comments 0 points Most recent by User_1B10X Reporting and Analytics for ERP
-
Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES tableSummary Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES tableContent Hi All, I need to pull the Template Name and Template Descript…Murali Gangidi 42 views 4 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
How to Calculate MTD and YTD in Oracle BI Analysis ReportsSummary How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real TimeContent Hi, I am try…Avesh Ganodwala-57885 247 views 2 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
Add Account Parmeter to Custom BI Puslisher ReportContent Hi Friends, I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create paramet…
-
How to rename the Worksheet name from Sheet1 to ?Summary Sheet1 to Content Good People, We are using the guided template for the BIP report and exporting it to Excel. When its exported the File Name appears correctly w…Soumya Prakash Parhi 163 views 2 comments 3 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
German Characters are displayed as Junk.Summary German Characters are displayed as Junk.Content Hi All, We do have a Custom BIP Report to send the extract to External System. When we submitted the report manua…Uvaraja-Oracle 38 views 0 comments 0 points Most recent by Uvaraja-Oracle Reporting and Analytics for ERP
-
Hide Operator (is LIKE (pattern match)) from dashboard promptSummary How to hide operator (is LIKE (pattern match)) appearing on Dashboard PromptContent Hi Experts, I have a requirement in my report to just show the heading and hi…
-
Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Summary Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Content Hello All Is there any Task to search (or) Report in oracle fusion …