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 31 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 171 views 0 comments 0 points Started 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 51 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 305 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 121 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 131 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 59 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 11 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 54 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
-
SQL query to extract UDT tableHello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a …Ioannis Adamou 6.3K views 8 comments 0 points Most recent by Parag Hiremath 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 11 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
-
Are the tables related to OTBI reports available to report on in OTBI?Summary Would like to monitor changes to OTBI reports at the table level until OTBI reports are being monitored via Audit PoliciesContent Would like to monitor changes t…Jeff Hare CPA CISA CIA 167 views 6 comments 3 points Most recent by User_BZ5TP Reporting and Analytics for ERP -
IS it possible to extract report on total number of self downloadable the report in employees folderSummary: HI Team, in this path Shared>Custom>employee -folder we placed the self downloadable letters so we need to extract report on total number of self downloadable. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM