OTBI
Discussion List
-
Include 'Comments' from Contract Risks into Subject Area "Enterprise Contracts - Contracts Real TimeContent Hello, I am wanting to include a field called 'Comments' from Contract Risks into an OTBI report that uses the Subject Area "Enterprise Contracts - Contracts Rea…Troy Collard 3 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP -
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 39 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 26 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP -
OTBI multi-language support Release 13Summary Multi-language support for OTBIContent Hi Has multi-language support been enabled for OTBI Release 13? ThanksUser_2025-01-28-07-00-38-043 74 views 7 comments 2 points Most recent by Hari Thyagaraj Reporting and Analytics for ERP
-
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at…VijayPatel 352 views 2 comments 2 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…User_2025-01-28-16-10-52-033 25 views 1 comment 3 points Most recent by User_2025-02-06-21-15-08-830 Reporting and Analytics for ERP
-
Due Date Calculation Formula based on Terms Date and Terms Name in OTBI ReportSummary Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI RepoertContent Hi All, I have a requirement to derive Invoice Due Date based …
-
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 47 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 362 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…Yordan Oliveira 19 views 4 comments 0 points Most recent by Yordan Oliveira Reporting and Analytics for ERP
-
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…Yogesh Mhalgi 808 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 65 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want …Bobby Jourdan 18 views 0 comments 1 point Most recent by Bobby Jourdan Reporting and Analytics for ERP -
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 73 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
Cross subject area - on which facts are they joined?Content Hi there I have joined two subject areas - Expenses - Expense Transaction details real time - Workforce Management - Work Relationship Real time to get level 2 d…Anders W. Langholm 36 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.1K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP
-
Risk Management Entitlements ReportSummary A listing of entitlements and the access points they are composed of.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file…Stephanie Golly-Oracle 75 views 2 comments 2 points Most recent by Matt Luscombe Reporting and Analytics for ERP -
Risk Management Results by Control Summary ExtractSummary For a specified control, show the last time it was run, by who and how many results it returned.Content * Download the zip file attached to this post * Unzip and…Stephanie Golly-Oracle 161 views 3 comments 3 points Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Subledger Details resulting in Duplicate LinesContent I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a piv…User_2025-02-11-07-08-23-440 55 views 1 comment 1 point Most recent by User_2025-02-11-07-08-23-440 Reporting and Analytics for ERP
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…User_5F4G3 507 views 10 comments 0 points Most recent by User_2025-02-11-18-46-39-346 Reporting and Analytics for ERP
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 50 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…Vinod Kumar Mohanraj 31 views 2 comments 1 point Most recent by Vinod Kumar Mohanraj Reporting and Analytics for ERP
-
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking …Dhruvjoshi23 16 views 0 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei…Henry Cabrera 36 views 0 comments 1 point Most recent by Henry Cabrera Reporting and Analytics for ERP -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an…Koteswararao Yenikepalli 46 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co…
-
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic…