OBI Answers
Discussion List
-
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 24 views 3 comments 2 points Most recent by Sushan Peiris 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 24 views 4 comments 1 point Most recent by Swapnil Kashid 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 …
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 911 views 12 comments 18 points Most recent by Matt Luscombe Reporting and Analytics for ERP -
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 80 views 7 comments 3 points Most recent by Sushan Peiris 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… -
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying …
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 63 views 1 comment 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…Bhaskar Konar-83539 54 views 2 comments 0 points Most recent by Bhaskar Konar-83539 Reporting and Analytics for ERP
-
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 35 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…Sankeerthana Anumasula 63 views 4 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1K views 8 comments 11 points Most recent by user9170237 Reporting and Analytics for ERP
-
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan…Shruthi Ramesh 21 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…
-
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…Matthew Pitkin 9 views 1 comment 1 point Most recent by Matthew Pitkin Reporting and Analytics for ERP -
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…Shiva R Krishna 44 views 2 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…Matthew Pitkin 42 views 3 comments 3 points Most recent by SimonTomey Reporting and Analytics for ERP
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 98 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 73 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 30 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…JL-JL 36 views 1 comment 0 points Most recent by Greg Jonovich-Oracle Reporting and Analytics for ERP
-
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI… -
Miscellaneous Receipts Register EBS R12Summary Do we have any standard report for the same from oracle fusion cloud.Content Hi All, Do we have any standard report for the same from oracle fusion cloud. for Mi…Amarnath 8 views 2 comments 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP
-
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 335 views 8 comments 14 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - …Shray Narula 39 views 1 comment 2 points Most recent by Anca Amarghioalei-Oracle Reporting and Analytics for ERP -
How to create custom OTBI Subject Areas in Oracle CloudSummary How to create custom OTBI Subject Areas in Oracle CloudContent Hi Experts, My client is Oracle cloud 20 C. My client have non oracle application that contain pro…Rama Pedamallu-249453 64 views 5 comments 1 point Most recent by Anca Amarghioalei-Oracle Reporting and Analytics for ERP
-
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M…Eren Göktepe-155015 16 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP