OTBI
Discussion List
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 396 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro 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 …
-
OTBI: Receivables - Transactions Real Time Subject AreaSummary OTBI: Receivables - Transactions Real Time Subject Area don't show collectionsContent I am trying to develop a report on this subject area to show the customer a…M.Adnan.Ansari 96 views 5 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
PO and Invoice Amount - OTBISummary Need to show PO and Invoice Amount in a reportContent Hello - I have a requirement to show the Invoice Amount and PO Approved amount in the same report. I can se…Hari Thyagaraj 98 views 6 comments 0 points Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
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 119 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 …Austin Cox-148352 56 views 1 comment 3 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Drill Down Facility in Reporting and AnalyticsContent Drill Down Facility required in Reporting and Analytics. can you please guide me about this task.Baskar.Chakravarthi 47 views 5 comments 0 points Most recent by Alan Rowland 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…User_AR8B9 402 views 5 comments 0 points Most recent by Veronica Dumitriu 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
-
OTBI Create Analysis with columns for different account balancesSummary Making Account a Column with Account ValueContent Hello, Is it possible to create this type of report in OTBI (I'm not having any luck)? Balancing Segment accoun…Stephen Bryant-131052 48 views 2 comments 1 point Most recent by Stephen Bryant-131052 Reporting and Analytics for ERP -
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,
-
Missing FolderSummary i missing custome folderContent Please help me to found my custom folder under share folder in custom ThanksMahgoub S.Mohamed 46 views 4 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 72 views 9 comments 0 points Most recent by Tom Strudley 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 198 views 0 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
Key Flexfields and Descriptive Flexfields Supported in OTBI FinancialsSummary The purpose of this White Paper is to help clarify the Key Flexfields and Descriptive Flexfields supported in OTBI Financials and the subject areas in which they…Veronica Dumitriu 157 views 10 comments 9 points Most recent by Sudha KOVURU 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
-
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…Dave Dengate 64 views 3 comments 0 points Most recent by Izharul Haq-163043 Reporting and Analytics for ERP
-
Unable to use 2 Subject Areas in the OTBI reportSummary OTBI error while using Payables Payments - Disbursements Real Time and Payables Invoices - Transactions Real TimeContent Team, We have created an OTBI report usi…Sathyaseelan Chandran 90 views 7 comments 1 point Most recent by Sathyaseelan Chandran 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…
-
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…User_OG8I4 109 views 4 comments 1 point Most recent by Sridhar Tumati-55392 Reporting and Analytics for ERP
-
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…
-
How to add OTBI report parameter to filter out those zero outstanding balance and date in range?Summary Add report parameters to filter those zero outstanidng balance and date in rangeContent hi all, I have two OTBI report parameters would like to add: 1) In the Su…
-
Drill Down using Invoice NumberContent Hi, I have created analytical report which has Ledger Name, Supplier Name and Invoice Number When the invoice number is clicked i would like to drill down to tra…Mohammed Rafi 84 views 10 comments 5 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
Couldn't Integrate a OTBI report including Project details and Project Contract DetailsSummary Can i Create an OTBI Report combining Project Details and Project Contract DetailsContent When i create new OTBI report add in it Projects details from subject a…Mohamed Attia-Allah 49 views 2 comments 0 points Most recent by Mohamed AttiaAllah-Oracle Reporting and Analytics for ERP -
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…Praveen Kumar-156819 92 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
OTBI RequirementSummary Setting a Flag By Updating Attribute Column in Invoice Header TableContent Hi, We designed a report which send notification for cancelled invoices to vendors sho…AnsumanM 40 views 5 comments 2 points Most recent by Manish Pesswani Reporting and Analytics for ERP