Reports
Discussion List
-
Report to show all invoices, amounts, VAT and attachmentsSummary A report that will identify all invoices, with invoice amount and VAT amount along with a field that pick up the file attached name (including extension i.e. .pd… -
Report Data Size exceeds limitSummary Report errors due to too many rowsContent I am creating an Oracle BI report to extract journal details however when I execute for a particular entity i get the e…Dave Sherrard 395 views 4 comments 0 points Most recent by Dave Sherrard Reporting and Analytics for ERP -
FR Web StudioSummary FR Web Studio Too Slow To Build ReportsContent Hi, We are trying to build reports in our ERP environment(s). When we open FR Web Studio the lag is too slow; it t…
-
BI Cloud Connector (BICC) White paper or DocumentsSummary Looking for Information on How to create Extract using BICCContent Hi, I need to send incremental feed of Data such as Customer , Supplier, GRN and POs to anothe…Prateek Parasar - GTUK, ACE Pro 239 views 6 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…User_2025-02-05-07-37-39-271 88 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they…User_2025-01-30-22-31-23-162 42 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162 Reporting and Analytics for ERP
-
How to set/enable the menu "Reports and Analytics" regardless of responsibilitySummary We’ve created the BI reports to General Ledger but is not possible see the “Reports and Analytics” option on the responsibility menu area, is possible enable thi… -
No response after import sample XML data into excel through BI PublisherSummary No response after import sample XML data into excel through BI PublisherContent Hi all, I have export xml data and want to create xml template in BI publisher in…User_2025-02-04-05-26-22-197 47 views 6 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line…
-
Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsSummary Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsContent Hi all, This is 19c new function, "Drill Down from OTBI Subledger Acc…User_2025-02-04-05-26-22-197 77 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 Reporting and Analytics for ERP
-
Begin/End Balance for Accumulated depreciation of an AssetSummary Begin/End Balance for Accumulated depreciation of an AssetContent Customer asks: We're building a Fixed Asset Balances report out of Subject area Fixed Asset Bal…Z-Man-Oracle 44 views 0 comments 2 points Most recent by Z-Man-Oracle Reporting and Analytics for ERP
-
rtf template - display constant text on every pageContent Hi All, I have a rtf template which contains nothing but a (row*column) table. I need to display a constant text like "Hello" at the bottom of every page, other …Rinku Gautam 86 views 12 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
How to save a report output with date suffix?Summary How to save a BIP report output with date suffix.Content I managed to get a complete XML output using select query with XMLELEMENT () tag using Data Model. Now I… -
Subledger Distributions to General LedgerSummary Subledger Distributions to General LedgerContent All-> Need to show the amounts of Invoice distributions/Matched/not matched POs related to Payables payments/rec…
-
How can user hide, add or remove content from Dashboard PagesSummary Dashboard Page seem to allow you to remove content but no way to add the report backContent I am in 19B/R13. Looking at the Payable Dashboard, I can click on x t…Prateek Parasar - GTUK, ACE Pro 29 views 0 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
Monitoring approval errors in Financial CloudContent We are trying to create a BIP report that will be scheduled to run to collect all workflow instances that have erred while/during approval. This is required for …User_2025-02-05-11-44-44-738 37 views 2 comments 1 point Most recent by User_2025-02-05-11-44-44-738 Reporting and Analytics for ERP
-
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…Elliot Hall-Walker 43 views 3 comments 0 points Most recent by Elliot Hall-Walker Reporting and Analytics for ERP
-
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,…
-
Logical SQL Error - OTBISummary When attempting to create a new Analysis using simple Logical SQLContent I am attempting to create a new analysis using the logical SQL below; however, whenever …
-
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…Mukund Kudrimoti-144443 27 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
OTBI Project Reporting - ForecastsSummary Unable to locate any measures that relate to past versions of forecasts in OTBIContent Hi, I am in then process of building an in-year expenditure/budget/forecas…StuartHibbert 118 views 1 comment 0 points Most recent by User10772173-Oracle Reporting and Analytics for ERP
-
Manager Email AddressSummary I need to know how to add a field which includes manager's email addressesContent Using the Expense - Expense Transactions Real Time subject area, I need to add …User_2025-02-04-18-47-46-124 57 views 1 comment 3 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Schedule and distribute a report to specific usersSummary Schedule and distribute a report to specific usersContent Hello Friends, I need to schedule and distribute a report to specific users. I clicked the "More" optio…Mukund Kudrimoti-144443 36 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Process name not filled for bip job in 'scheduled processes'Summary Process name not filled for bip job report in 'scheduled processes'Content Hello, When we schedule bip report (manually or via web services), a process is execut…Médéric Chauvin 331 views 3 comments 3 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Fusion table which store all Data Model SQL?Content Hi, Can anyone share Fusion table(s) which stores SQL's of all data models? Thanks, RinkuRinku Gautam 293 views 5 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Deep Link for AR Invoice creationSummary Deep Link for AR Invoice creationContent We were going through document 'Drill down from OTBI adhoc reports to Receivables' and there is Deep link for AR invoice…Rakesh Ramesh-Oracle 472 views 5 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Summary How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Content Can anyone guide us on how to generate and view the DB trace fi…Umamaheswara Reddy Karri 81 views 5 comments 2 points Most recent by Hannah Dorman Reporting and Analytics for ERP -
How to have dashboard at My dashboard specific to userSummary How to have dashboard at My dashboard specific to userContent Users can be from different departments, we want to have user specific dashboard at My dashboard li…Usman Ul Haq 193 views 4 comments 1 point Most recent by Hannah Dorman Reporting and Analytics for ERP