Reports
Discussion List
-
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 39 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 44 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 125 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 56 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 35 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 301 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 494 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 84 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 191 views 4 comments 1 point Most recent by Hannah Dorman Reporting and Analytics for ERP
-
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,
-
Custom Groups in BIPSummary Need to create custom grouping of Accounts in BIPContent Hello - I have a requirement to show selected account attribute values from Account dimension in an expe…Hari Thyagaraj 42 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for ERP
-
Permissions or custom roles to view only OTBI or BIP reportsSummary I need to enable a SCM roles users to just display custom financial reports which created by using BI publisher or OTBI.Content I need to enable a SCM roles user…Mohamed Mahmoud-157904 84 views 9 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
Aging ReportSummary i'm not able to genrate back dated aging report in account recivableContent not be able to generate back dated ageing reportsMahgoub S.Mohamed 92 views 4 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…Avesh Ganodwala-57885 226 views 0 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
OAC drill into ERP transactionsSummary Drill ability from OAC dashboard into ERP transactionsContent Hello - I created a Invoice report in OAC cloud with Payables Transactions subject area. Is there a…Hari Thyagaraj 55 views 0 comments 1 point Most recent by Hari Thyagaraj Reporting and Analytics for ERP
-
Edit InfoletsSummary Roles required for editing InfoletsContent Hello - I am in the ERP Cloud application and I can see the OOB inflolets and able to view them. I do not see the edit…Hari Thyagaraj 61 views 6 comments 0 points Most recent by Hari Thyagaraj Reporting and Analytics for ERP
-
BI Publisher : Setup Data Source and extract data from itContent Hi, In BI Publisher, I am looking to setup a new data source to extract specific business unit related from it in the data model. Also, Out of all the data sourc…Rinku Gautam 55 views 3 comments 0 points Most recent by Milind Dalvi Reporting and Analytics for ERP
-
Invoice Approval and Notification InformationSummary Cannot find the table name for Invoice Approval and Notification InformationContent We want to extract details of Invoice Approval and Notification Information b…User_2025-01-22-19-25-44-650 64 views 3 comments 0 points Most recent by User_2025-02-05-11-38-57-253 Reporting and Analytics for ERP
-
View future scheduled ESS jobs in SaaSSummary We have a requirement to extract the future scheduled jobs for a user.Content Test Case: Admin wants to know what are the future jobs scheduled for a user. In ca…Sumanth Kunimakki-21932 78 views 4 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
MOAC in BIP ReportsSummary Implementing MOAC in BIP ReportsContent Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been abl…
-
Bi Reports Does not Show LOV CorrectlyContent Dear , I created a user defined lov in (Manage List of Values Sources) and then defined into my reports . Reports run correctly with lov but issue is lov filed i…User_2025-02-04-12-49-58-154 26 views 11 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Invoice Line Level Account Combination (Distribution) ReportSummary Invoice Line Level Account Combination (Distribution) ReportContent Can someone tell me what Subject Area and specific Subject in Reports and Analytics should be…racheltx 109 views 4 comments 1 point Most recent by Sridhar Tumati-55392 Reporting and Analytics for ERP
-
Sub ledger Account table - Data VisibilitySummary Sub ledger Account tabl: Data Visibility for XLA_TRANSACTION_ENTITIES table.Content We are trying to build a BI Publisher report for extracting data for Sub ledg…Senthilrajan V 95 views 4 comments 1 point Most recent by Senthilrajan V Reporting and Analytics for ERP -
Parameters Appear Under Data_DS in CSV FormatSummary How to remove the Parameters appearing as fields in CSVContent Hi, We are currently working in a report and the data model is bringing through the fields require…User_2025-02-03-21-40-10-404 51 views 9 comments 2 points Most recent by Wendy Ware Reporting and Analytics for ERP