OTBI
Discussion List
-
Where are calculated measures housed in the catalog for OTBI ?I've created measures for different reports (not sure which ones), but want to re-use them. Where can I locate them in the catalog? -
How to create BI analysis for Sales Product and Product GroupsSummary: How to create BI analysis for Sales Product and Product Groups Content (required): Hi, We want to create a couple of analysis to show a list of product groups a…Max Prestes 34 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales -
Is There Way to Join Subledger to Payables Invoices via Query?Summary: Is there a way to join Payables Invoices - Transactions Real Time to Subledger Accounting - Journals Real Time via a SQL query? Content (please ensure you mask …hannah_barry 173 views 0 comments 0 points Most recent by hannah_barry Payables, Payments & Cash Management
-
Scheduling OTBI report with a conditionSummary: I'd like to be able to schedule an OTBI report but restrict the data that is sent to the recipient using a condition. Content (required): Our OTBI employee stru…
-
Line Managers reporting on terminated workersSummary This post provides customers a work around in OTBI to report on the terminated workers when logged in as a line manager.Content The attached document provides a …Raghavendra Raghunath-Oracle 993 views 10 comments 12 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
How to fetch actual score and mastery score of the learner for assessment which has been completedSummary: How to fetch the actual score and mastery score of the learner in OTBI report. Content (required): Version (include the version you are using, if applicable): C…
-
Aggregate all notifications from Oracle HCM Cloud into single daily email/ report.Hi all, We have a requirement in which we are looking for a way to a aggregate all notifications from Oracle HCM Cloud into a single daily email or a report, sort of lik…Ioannis Adamou 61 views 2 comments 2 points Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
Are there downloadable dashboards for Financials modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…ShailenS 52 views 2 comments 0 points Most recent by Teresa Cabrita - Capgemini UK Reporting and Analytics for ERP
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des…Anil Pillaresetty 307 views 21 comments 1 point Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages?Summary: How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages based on logged user. Content (required): We have a Dashboard; i…Ravindr-Oracle 132 views 5 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
IDR: Report to pull Invoice Account Coding HistorySummary: We would like to track account coding history as part of the invoice for reference and audit purposes. What is the best way to accomplish that? Content (require…Judy Hamner 139 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Need to have Response Answer and Response text in same columnSummary: Dear Experts, Please advise that my questionnaire consists of both response text and response answers. Some response answers will be blank when the question is …Rajeshkumar_Sekar06 11 views 2 comments 0 points Most recent by Athish shantharaman Reporting and Analytics for HCM -
Reporting on Uptake of Course across OrganisationSummary: Requirement to work out the uptake of a course and show in graph form Content (required): Hello We have a course that has been created that we expect managers t…Helen Thomas 11 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Can we change fetch First 250001 Rows Only to any other values?Summary: Can we change fetch First 250001 Rows Only to any other values? Content (required): Can we change fetch First 250001 Rows Only to any other values? It seems thi… -
Performance Issue in Workforce Management - Workforce Trend Real Time subject areaSummary Performance Issue in Workforce Management - Workforce Trend Real Time subject areaContent Hi Team, We have a line manager dashboard where for one tab we are usin…Sohan Dey 61 views 11 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…William_Johnson 16 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Inventory Valuation OTBI Report Shows Double EntrySummary: An OTBI Report is created for Inventory Valuation according to client's need of parameters. After running the report, output shows double/duplicate entry for Co…
-
Is it possible to change time zone on CURRENT_DATE SQL filter?Summary We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?Content Hi …
-
Not able to access Customer Listing Report under BI CatalogSummary: Not able to access Customer Listing Report under BI Catalog Content (required): When i try to run Customer Listing Report from BI Catalog, I am not able to see …vasanth.rao 51 views 6 comments 0 points Most recent by Jithendra-Fusion Receivables-Oracle Receivables & Collections
-
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 21 views 8 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM
-
United States Job Information Extensible Flexible Attribute not BI EnabledSummary: 2 of the attributes in United States Job Information Extensible Flexible are not BI Enabled. The flexfield is protected hence no changes can be made. Please see…
-
Implications of Editing an Analysis Report Utilized in an InitiativeSummary: What are the implications of editing OTBI Analysis Reports that are currently being used in active initiatives? Content (required): We are making edits to sever…
-
Project invoice table to subledger table joinSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):KOTTHURI ASHOKBABU 13 views 1 comment 0 points Most recent by Pradeep Balakrishnan Project Management
-
Can we create a rule to auto reject the invoices if particular account is found?We have a requirement to not allow the invoices (PO, non PO, boundary apps invoices) to be charged to 1***** account. This account can be used in other subledgers so we …KanikaGupta 21 views 1 comment 1 point Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management