Reports
Discussion List
-
How to exclude weekends and holidays from calculation in OTBI Report?Hi We have a requirement to not include weekends and holidays in calculation for one of the metrics in OTBI report. Kindly suggest some steps to archive Thank you Prathy…Prathyusha pari 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Why is barcodes not getting scanned in RF-Smart handheld scanner ?We have modified the standard Print Pick Slip report to add a custom template, type RTF and output PDF, and added barcodes to it with IDAutomationC128S as the font style…Prathyusha pari 81 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Download the zip file (Authorized Hosted Named Users.zip) does not workSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Manisha Rajupeta 41 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to Join Multiple Subject Area in OTBISummary: Hi All, Need suggestion on OTBI report. Content (please ensure you mask any confidential information): We have requirement to build an OTBI report to show trans…Akansha 112 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to find the BI reports that are using Excel TemplateHi, Referring to Doc ID 2990643.1, the BI reports that are using Excel Template are getting the corrupted output while scheduling it. Could anyone please let me know is …Vigneshvaran KJ 42 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI Asset Depreciation Report with Pivoted Accounting DateI'm trying to create an asset depreciation report in OTBI using a pivot table. My goal is to have the accounting date itself be a pivoted column (displaying depreciation…
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 71 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
Incomplete information in the dashboard Customer Listing ReportSummary: Site Purpose Source Reference field does not always display record information Content (please ensure you mask any confidential information): In the dashboard C…SERGIO BARRETO 11 views 0 comments 1 point Started by SERGIO BARRETO Reporting and Analytics for ERP -
Excel Bursting issues with Payables Payment Register reportSummary: Strange behavior in custom Payables Payment Register report Content (please ensure you mask any confidential information): I have customized the seeded 'Payable…
-
Arabic text not displaying properly when generating pdf outputSummary: Arabic text not displaying properly when generating pdf output Content (please ensure you mask any confidential information): Hi Experts, In Invoice Print Templ…Venkatesan 61 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
which table stores the information of Fusion Middleware Error Messages ReferenceWe wanted to find oracle Fusion Middleware Error Messages Reference code and thier meanings from backend tables. While performing any transaction in our fusion instance …Opkey PA 24 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…JayK 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Unable to find subject area to fetch FAI Required field for OTBI reportSummary: Hi, we have a requirement to fetch FAI Required field but unable to find the subject area for OTBI report. Content (please ensure you mask any confidential info…Prathyusha pari 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
FRS report Grid IssueI am trying to create FRS report with Grid1 and Grid2. I have lots of columns and detail in Grid1, I would like to copy same detail from Grid1 to Grid2. I am not able to…
-
Query to fetch approver details for all pending requisitionsSummary: Query to fetch approver details for all pending requisitions Content (please ensure you mask any confidential information): We are creating a report which will …Nidhi Chhajed 312 views 13 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta…Andy Gough 879 views 10 comments 8 points Most recent by JLogan-EncoreGlobal Reporting and Analytics for ERP -
AR Transaction details with receipt details custom OTBI reportSummary Need to link Receipt Application subject area to transaction details subject areaContent Hi, I have created a custom OTBI report with all standard AR receipt det…User_6OFC2 275 views 4 comments 0 points Most recent by User451524-OC Reporting and Analytics for ERP
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…Mansi1302 862 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Can we do Dynamic Custom File Name in BI Publisher???Summary: We have a requirement to save XML file on the BI report custom name on output files before send the file to SFTP location. File name must have the tag sent by …Sarinee.p 439 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need to create Dependent Value Sets in a Data model in oracle cloud (SAAS)Content Problem Description --------------------------------------------------- Hi Team, Is there any possibility to create a dependent value set in a Data model in orac…User_1B10X 46 views 8 comments 1 point Most recent by Britika Kumari Reporting and Analytics for ERP
-
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 58 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…Tasha Kretlow-Oracle 82 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Etext negative number paddingSummary Etext negative number paddingContent Hi All. We have a requirement to dispay a number like -123 as -00012300. Please suggest how this is possible in Etext templa…Aditya Lanka 72 views 2 comments 2 points Most recent by YehanWithanarachchi Reporting and Analytics for ERP
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba…User_2025-02-06-06-17-13-684 110 views 4 comments 3 points Most recent by Andres Hernandez Suarez 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 261 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…Prathyusha pari 92 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP