Reports
Discussion List
-
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 326 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 882 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 274 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 884 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 469 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 81 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 111 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 285 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
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 411 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP
-
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
Inactive User Report - Is it possible to see this in OTBI?Inactive User Report - Apart from the scheduled process, the report can be seen. Is it also possible to see this in OTBI? If yes, where is the path name?
-
how to add attachment column in bank account creation of register supplier page in fusionSummary: how to add attachment column in bank account creation of register supplier page in fusion Content (please ensure you mask any confidential information): Hi All,…Venkatesan 22 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Deliver BIP report to sharepointSummary: Ability to deliver BIP report to sharepoint seems possible, but documentation is from 2007 and doesn't seem to line up with current sharepoint screens. Content …Alex Glose 91 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 31 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a…
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 512 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 184 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
Segment value Security tableSummary: Need a table that stores values stored in Segment Value Security (SVS) Rules. Content (required): Table fnd_object_instance_sets stores the value in FILTER colu…
-
Italian AR E-Invoicing ProgressivoInvio NumberHi, As per Italian reporting requirement we are developing Italian AR E-Invoicing report with XML output. We have a tag called 'ProgressivoInvio', as per the customer re…
-
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…Kishan Dhongadi 197 views 9 comments 1 point Most recent by HarshithDarla Reporting and Analytics for ERP