Reports
Discussion List
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…Maheedhar_Atmakuru 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Need to Convert PDF from word and merging more than one PDF documentsHi, we are planning to use BI Publisher of Oracle analytics cloud to print customer invoice out of a custom tool being developed in VBCS. we have a requirement where the…
-
Suppress Rows - Zero not working in SmartviewSummary: I am trying to Suppress rows that have HSGETVALUE formulas in them for account member in Smartview report. When the account value is zero, the rows should be su…
-
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…Donald 219 views 4 comments 0 points Most recent by Chandra Kiran Ushakoela Reporting and Analytics for ERP
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Member Selection is not showing correct value in Smart View ReportSummary: We are building a Smart View report. We have one account segment named Facility which is BSV as well. Now when we select Facility from Member selection it is no…
-
Schedule running of 'Workflow Transactions Listing'Summary: Can we schedule the running of the report 'Workflow Transactions Listing' and send an email to all the approvers included on the result of the run? Content (req…
-
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…
-
Attaching BI Report to OTBI DashboardSummary: Hello, I want to attach a BI report to OTBI Dashboard and connect it with dashboard's prompt. Question 1: Can I attach and view a report made from FSCM Tables (…
-
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…
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 415 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…User_2025-02-05-02-38-04-251 39 views 6 comments 0 points Most recent by Zehra M Reporting and Analytics for ERP -
Ctreating a report for my PPM moduleDear all I am creating a report for my PPM module I just want to list the project name - task name and number - Cost and Resource I found all the above except the Resour…Mickel.Rmeily 31 views 1 comment 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Why the condition row value is not able to sum up as expected.Summary: We have got a requirement where either of one value is nonzero consider that value for result row. Row values are Account 400000 Department 555015,Account 40000…Monika Gnanavallal-Oracle 12 views 1 comment 0 points Most recent by Monika Gnanavallal-Oracle Reporting and Analytics for ERP
-
How to make MICR bold in AP checks?Summary: Couldn't make MICR bolder using the AP checks in RTF Template. Content (required): i I have tried changing the MICR tag bold in RTF template ii I have tried add…Krishna Kumar v 11 views 0 comments 0 points Started by Krishna Kumar v Reporting and Analytics for ERP -
Why to use e-text format in BIP report when we can use default csv formatSummary: Why to use e-text format in BIP report when we can use default csv format Content (required): Why to use e-text format in BIP report when we can use default csv…ShitalRamteke 11 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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
-
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-…Anders W. Langholm 1 view 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
Is there a way to display the full content of a Text Attachment on a Purchase Order/PO PDF report?Summary: Full Text Attachment content is not being displayed on PO or PO PDF print report. Content (required): The table and column which stores the PO text attachments …Gaurav Rochwani 221 views 2 comments 1 point Most recent by Gaurav Rochwani Reporting and Analytics for ERP
-
The BIP Excel layout returns no dataSummary: I downloaded a data sample from the data model, added the fields to Excel (creating a XDO_Metadata sheet). The template with the sample data looks fine: But whe…
-
Request for Oracle User Access ReportSummary: Hi all, Thank you in advance for your help and support. I have a question regarding Oracle user access. Is it possible for us to extract a report that provides …Paul Younes 32 views 2 comments 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How to disable Edit option in OTBI Reports?Summary How to disable Edit option in OTBI ReportsContent Need to disable the Edit Option from the OTBI Analysis. Could you please suggest how we can achieve this?Srikanth Raavi 582 views 12 comments 1 point Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Where can I find the list of native reports that exist in OTBI for purchase contracts?Hello colleagues, I need to know if there is a document that specifies those native or standard reports that Oracle offers, if you have a document with this information …Fernando Chavez 21 views 2 comments 0 points Most recent by Fernando Chavez 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 -
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 312 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
Error Message from RTF Template - Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001Content Hi Please can someone assist witht the below error: Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001 This error is recvieved when running custom templ…User_2025-01-30-20-23-15-920 388 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Getting remittance message columns in OTBI before payment is madeWe want to create a report which we can use to check whether all payment details are filled correctly for large batches of payments before creating them, to prevent down… -
Table that holds ESS Job Display nameSummary: Hi We are trying to create a bip to fetch ESS job details. we looked into ess tables for display name but looks like they store only short name. fusion_ora_ess.…
-
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real…
-
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver…Abhilash K - Deloitte USI 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP