Reports
Discussion List
-
How to use the "is based on the results of another analysis" filter operatorSummary: We created two analysis in OTBI and put them in a dashboard. The one report drills to the second report via action links. The second report is using the filter … -
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…Deepika Jain DJ 88 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
Can we select a range of member values in the prompts while running a FRS reportHi Team, We have a requirement to provide prompts for running an FRS report, wherein we can select a range of values, like 'From' and 'To' option while selecting account…Srishti Kedia-Oracle 62 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 21 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…raban 62 views 4 comments 0 points Most recent by SiddharthDang-Oracle Reporting and Analytics for ERP
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 261 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work… -
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…SakshiA 31 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 434 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…kalyan gade 101 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
Child account not reflecting under Parent account in Smart ViewSummary Child account not reflecting under Parent account in Smart ViewContent After creating a new account, when refreshing Smartview report I noticed Its not reflectin…
-
Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL table?Summary: We need a field that captures the accounted amount equivalent of the AMOUNT_DUE_ORIGINAL field from AR_PAYMENT_SCHEDULES_ALL table. Content (required): Hello, W…Kristelle 111 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
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 33 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 222 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 424 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 13 views 1 comment 0 points Most recent by Monika Gnanavallal-Oracle Reporting and Analytics for ERP