Reports
Discussion List
-
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 462 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 43 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 36 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 19 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 13 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 15 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 73 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 7 views 0 comments 0 points Started by Anders W. Langholm 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 36 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 611 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 26 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 62 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 363 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 406 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.…Susmitha R 2.3K views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Dynamic Legal Entity Name heading in FRS ReportSummary: Hi All, Can we have company or legal entity name derived dynamically in FRS reports based on selected legal entity at page level? Thanks, Content (required): Ve…
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 428 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Supporting Details Option Not Displaying On ReportsSummary: Upon setting the "Supporting Details Option" to display after the Parent member for my report, I am unable to see the supporting details when viewing my report …
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi…
-
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…sailesh_cloudare 34 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file … -
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F…
-
Oracle Fusion SaaS Cloud Application ManagementSummary: Looking for pre-built dashboards to monitor your entire SaaS Application like Content (required): Hi Team, We are looking for pre-built dashboards to monitor yo…Spats 46 views 2 comments 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for ERP
-
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …