OTBI
Discussion List
-
Do we grant Learning Reports access to specific individuals for designated business units in OTBI ?Summary:We have a requirement that we need to provide learning Reports access to specific individuals for designated business units.These reports are available on OTBI. … -
Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…Nishit Doshi 11 views 1 comment 0 points Most recent by Sunder Subramanyan-Support-Oracle Reporting and Analytics for HCM -
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…mudassirsOrc-Oracle 21 views 5 comments 1 point Most recent by Aishwarya1990 Reporting and Analytics for ERP -
Deeplink to audit expense reports pageSummary: Hi, Can anyone provide me the deeplink to audit expense reports Page? Our requirement is to drill down through OTBI to the audit Page based on expense report nu… -
Privilege required to view Uninvoiced Period End Receipt Accruals report 24BAs per 24B release notes (https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/inv/releases/24B/24B-inventory-wn.htm#T55878), one of below seeded… -
Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav… -
Receivables Concatenated Segment is not showing updated account in OTBI report.Summary: Hi, We have an OTBI report using Receivables - Transactions Real Time wherein we have added 'Receivables Concatenated Segment' column but it is showing the Reve…Rahul Kumar Gupta.-Oracle 31 views 0 comments 1 point Most recent by Rahul Kumar Gupta.-Oracle Receivables & Collections -
Need budget expense code in Parent level field in OTBI Subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
how to check schedules from past date for "Update and Close sales order"Hi , We have scheduled "Update and Close sales order" program on 25th Aug . But we have below queries , can please someone help us to find that: 1) When was last this "U…Aayush Anand 61 views 8 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management -
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP -
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Need a query to fetch planned order and demand due datesSummary: Hello, We need a query to fetch planned order due dates and corresponding pegged sales order/forecast need by dates for a certain category of items. We would li…SharathBiz 62 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 111 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 134 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 51 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
Display location segment Value description in FA OTBI ReportSummary: Hi, in the 3 subject areas related to FA, only we can see the location segment code. we have a requirement to display the code description as well. but I cannot… -
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 11 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
OLC Delivered Reports are not showing in the SystemSummary: Hi Team, The Learn Delivered Reports are not showing in the path below. /shared/Human Capital Management/Learning/Transactional Analysis Samples/Report Componen… -
how to use SQL to create otbiI have Created an sql query for BI report , but I want to convert it to OTBI analysis is there any way to achieve this ?Mohamed Abdelbar 93 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Delivered Learn Reports in OTBISummary Where are all the delivered reports?Content I seem to be missing some reports in OTBI: * Abandoned Trainings - Top 5 * Managers with Overdue Workers Details - To… -
OTBI Performance Management Summary dashboardSummary: Need path for this seeded report dashboard Content (please ensure you mask any confidential information): Our customer has this screenshot showed and mentioned …Rajkumar Subbareddi 71 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
PVO DetailSummary: Im trying to get the detail of what this PVO is including (HcmTopModelAnalyticsGlobalAM.HcmRecSrcTrackingAM.SourceTrackingViewAllPVO ) , is there a good documen… -
Scheduled OTBI reports- What happens when person who scheduled reports gets terminatedMy team has been scheduling reports for end users using their IDs (instead of a generic/master account). I was wondering what happens to the scheduler agents when the pe… -
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge… -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 148 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM -
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f… -
How to get the Pick Slip Number associated with Sales Order in Oracle Fusion?Hi, I have a requirement to write a query to get the Pick Slip Number associated with the Sales order. Is there any table in Oracle Fusion which stores the association o…