Popular Tags
- OTBI 1,500
- Reporting 1,418
- FDI 1,290
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,015
- BI Publisher 896
- Analysis 699
- Oracle Fusion Analytics 633
- OAC 581
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 443
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 293
- Fusion Data Intelligence 274
- BIP 272
- Answers 266
- Analyses 258
- Developers 249
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 230
OTBI Reports
Discussion List
-
OTBI - How to create Drill Down with custom data model reportsHi everyone, I’m working with two custom Data Model Reports in Oracle BI Publisher, and I’d like to know if there’s a way to drill down from one report (Project) to anot…Christian Flegler 156 views 2 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum -
How do I change YTD to FYTD in a measure column?In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I u…L G 31 views 2 comments 0 points Most recent by L G Oracle Transactional Business Intelligence Forum -
2Report to record usage of ADF Desktop Integration .Hi, We recently had a business need to identify all users who use the ADF Desktop Integration plug in in Excel. It would be great if there were a report to identify user…David Fleming 1 view 0 comments 2 points Most recent by David Fleming Oracle Transactional Business Intelligence Idea Lab -
Some AP invoices are missing in the OTBI Payables ReportHi Team We have created OTBI report in Payables. In that report we have given three parameters 1) Accounting period 2) Supplier 3) Business Unit. If we download the repo…Rajesh Kushwaha 101 views 7 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
Latest data changes are not reflecting in the OTBI report immediatelyHello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employee, it so…Nusrat Shaheen 361 views 9 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
Overtime status is not showing data in workrelation subject areaHi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fix the iss…shiva G1 21 views 2 comments 0 points Most recent by shiva G1 Oracle Transactional Business Intelligence Forum -
Pivot Table incorrect totalI created a simple pivot table to count the number of accounts in a certain category. It is doing a distinct count and adding the totals at the end. What could possibly …Donna Fazio 21 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
Automating Email Recipient Updates in Oracle Fusion HCM BI Publisher: Seeking Community InsightsHello Oracle Community, Problem Statement: We frequently receive multiple tickets from the business requesting updates to the email/distribution list recipient list in B…PMDinesh 66 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
3Request to Enable Translation Editor for Item Description by Business unitWe’ve explored whether it’s possible to retrieve the item description from the child inventory organization instead of the PPIM master, but it appears that Oracle restri…Desi 11 views 0 comments 3 points Most recent by Desi Oracle Transactional Business Intelligence Idea Lab -
Issue with VAT Details Report – Cancelled and Reversed Postings Not IncludedIs it possible to obtain the VAT amounts of a cancelled posting and its reversal, as apparently the system does not support it Any insight, workaround, or confirmation o…Jose Angel RuizMen 45 views 2 comments 0 points Most recent by Syamantak Saha Oracle Transactional Business Intelligence Forum -
Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T…Sudheer YN 101 views 6 comments 0 points Most recent by Sudheer YN Oracle Transactional Business Intelligence Forum -
4ERP OTBI Archive / Unarchive ability in My Folders for UsersThis was originally reported in SR 4-0000680699. Oracle requested that we create an idea instead. Requirement: To enable the Archive / Unarchive option under "My Folders…Sam Heller 12 views 0 comments 4 points Most recent by Sam Heller Oracle Transactional Business Intelligence Idea Lab -
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…ACDC 11 views 1 comment 0 points Most recent by Subha_Tripathy-Oracle Oracle Fusion Data Intelligence Forum -
Enable custom reports centrally for all Job managers in PPM manage project financial plan analyticsWe are new to Oracle.. How can i enable list of custom report for all users/ or job manager role in the PPM manage project financial plan analytics pop up tab on the rig…ACDC 11 views 1 comment 0 points Most recent by Subha_Tripathy-Oracle Oracle Fusion Data Intelligence Forum -
How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …Anna-MariaP 25 views 1 comment 0 points Most recent by JohnW-Oracle Oracle Fusion Data Intelligence Forum -
-
Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art…Kuldipsinh Rajput 32 views 3 comments 0 points Most recent by Kuldipsinh Rajput Oracle Transactional Business Intelligence Forum -
How to get the manager assigned to the department to show in a OTBI reportHi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called …Claudia Linares L 85 views 2 comments 0 points Most recent by Claudia Linares L Oracle Transactional Business Intelligence Forum -
OTBI Parameter - formula of numeric number of the monthCould anyone help me with the formula to get the numeric number of the current month and previous month to use in parameter of OTBI Report Example: If current month is J… -
Request for Legal Employer of Manager in OTBI AnalysisHI in the subject area "Workforce Management - Worker Assignment Real Time", I need to retrieve the legal employer of the manager. Is this possible? If not, is it availa…Guido Masciello 2 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Fusion Data Intelligence Forum