OTBI
Discussion List
-
Schedule in Analytics is Greyed-OutSummary: The Schedule button is Greyed-out Content (please ensure you mask any confidential information): Please help! Version (include the version you are using, if app…Dorren Veil Laniog 143 views 2 comments 0 points Most recent by Dorren Veil Laniog Reporting and Analytics for ERP -
Replacing Project attribute with Organization name causes severe performance issueSummary: We enabled Project DFF and included the attribute as a filter as organization name in OTBI. The report runs normal if we filter for specific orgs but when submi… -
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 290 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 34 views 2 comments 0 points Most recent by Madhavi.Godbole Reporting and Analytics for ERP -
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 44 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 322 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 338 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second…Emily McAdams 190 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI Incremental Date Parameter ValuesHi, We have a requirement to run the Payables Invoice Register OTBI report with incremental date parameters. We would like to schedule the Payables Invoice Register OTBI…
-
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …SSS Song 94 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
Does OTBI Scheduler return report in non-English?Summary: When we run OTBI in UI, it returns a report with all the colums in Japanese as we set the language preference to Japanese. However, when OTBI scheduler runs, th…CHIZURU SHIGA 23 views 4 comments 0 points Most recent by CHIZURU SHIGA Reporting and Analytics for ERP
-
General Ledger - Balance Real Time OTBI Report IssueSummary: We have used below columns in the report, it is not giving the data with below combination. "Natural Account Segment"."Natural Account Segment Code" "Natural Ac…FirozahamedSK 46 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 44 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Include a row when column null in out of the box analysisI would like to use an analysis in OTBI but include the data when a column has a null value. What happens now is when I add the column and that column is null, the resul… -
OTBI - Can we have one line per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 24 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …Waqas Yousuf 272 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
PGP Encryption for RunReport SOAP Web ServiceSummary: Is there a way to encrypt the Report output when the report is extracted using the following SOAP API: Service WSDL URL: https://servername/xmlpserver/services/…Shubham Malik 12 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
Concatenating Values in a Database with 'for each' with a delimiterDear all, Is there a way to retrieve data using a 'for each' loop and insert a string between the values? For example: I have the following values in a database table: c…George Mattar 24 views 5 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Why to use FRS or Narrative reports when we have OBTI and BIP toolsHello Oracle Gurus, When we have reporting tools such as OTBI and BIP, why is there a specific need to use Narrative reporting tool or FRS tool?
-
BI Publisher - How to generate the postal bar codeSummary BI Publisher - How to generate the postal bar code and standard payment barcode on billsContent I have a requirement to generate customer correspondence that inc…RichardChan 56 views 6 comments 0 points Most recent by Sonny_Conyers Reporting and Analytics for ERP -
Is there a subject area for Chart of Accounts in OTBISummary: Is there a subject are for Chart of Accounts in OTBI? Content (required): Looking for a Chart of Accounts subject area so that I can build an OTBI report Versio…
-
What is the OTBI export limit?Summary: What is the OTBI export limit? Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23c Co…
-
Schedule Report > Dest FTP > Case When There is No Data > Ability to Not Generate Output FileSummary: BIP Report > Schedule Report > Destination FTP > Case When There is No Data > Ability to Not Generate Output File Content (please ensure you mask any confidenti…
-
Issue with migration of DashboardHi, User has migrated their own dashboard from their own folder to custom folder. Only the person who has developed is able to access but it is throwing error for others… -
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…Sasidhar_Araja 74 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…