To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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… -
Non - standard SQL data model bind to different templatesSummary Non - standard SQL data model bind to different templatesContent Hi there I was wondering if it was possible to bind a non-standard SQL query parameter to a Repo…
-
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… -
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 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…
-
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…
-
Aging ReportSummary i'm not able to genrate back dated aging report in account recivableContent not be able to generate back dated ageing reports
-
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…
-
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… -
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…
-
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…
-
Report that shows Payables Invoice Approver name, Initiated by , Validated by valuesSummary We are trying to build a report in Payables that shows Invoice details along with Approver name, Initiated by, Validated by ValuesContent We are trying to build … -
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…
-
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…
-
Supplier Audit Report - OTBI or (ideally) SQLContent Hi, I have the attached file but was wondering if anyone has done a SQL report rather than what is documented in the attached. We are looking for: I am looking f… -
How to add a value source LedgerPVOSummary Need to use a list of values in ESS Job Parameter that will display Ledger Name and pass ledger_id to BIP reportContent I was looking to instruction to add list …
-
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…
-
ERP – Accounting Automation: A Path Ahead - March 22, 2018, 9:00 a.m. PT - Submit QuestionsContent Submit your questions for the ERP – Accounting Automation: A Path Ahead session to have them answered during the live event. Post your questions by posting a new…
-
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…
-
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…
-
BIP Report ParamtersSummary BIP Output via ScheduleContent Hello - I scheduled a BIP report and the export output shows the parameters as columns in the excel file. The requirement is such …
-
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… -
Inventory List of Stored ProceduresSummary Looking for documentation on delivered stored proceduresContent Where can I find more information about the stored procedures that can be called from BI Publishe… -
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…
-
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… -
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… -
Database table details for content stored in UCMSummary Need to extrat details of UCM content in BIPContent Hi Experts , UCM contents has some properties like comments, owner , account , security group etc. Do we have…