Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
Oracle Incentive - OTBI - Participant PositionI am looking for Participant Details along with his/ her POSITION from OTBI. Any pointers on which subject Area to be used. I can see Participant Details in few Incentiv… -
Excel compatibility with Oracle BI?We are using the version of Excel 1997, which is too old and is only capable of threat with 65,000 lines. Which other versions of Excel are compatible with Oracle BI Clo…
-
Estimated End Date associated with an Absence - OTBII am having trouble getting the Estimated End Date associated with the absence to pull into an OTBI report. Is there a way to pull in this value?
-
Advice needed. Got a request to create a new role for OTBI access only; no access to BIP.The role will need the following access in OTBI: Ability to create, edit, delete, archive and unarchive reports in the My Folder No Ability to create, copy, modify or de…
-
Filter results of an OTBI report based on logged in userI am creating a data model for approval transactions. Is there a way to filter the results of the approvals based on the logged in user (Approver)
-
Duplicate element entry report with entry detailsI have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on how I hav…
-
How do I get the performance tiles to aggregate properly when using multiple subject areas?Hello Experts, I've run into an issue when creating performance tiles from joined subject areas. The tile (using a simple count measure) I'm using seems to aggregate pro…
-
Report Job History defaultsHello, When searching for the reports I recently ran, by navigating to Report Job History, it defaults to 1 week ago date, slowing down the search itself. How can we cha…
-
How to move BIP report extraction output file from UCM to object storageRequest is to move the BIP report output file from UCM to object storage . Please advice if there is any configuration to be done at HCM side so that BIP output files ca…
-
Line Manager Email notification with their Employees Due and OverDue TrainingsWe have the OTBI report that sends an email to line managers with their direct reports due and overdue trainings via agents. And, we have recently found that, there is a…
-
Audit Related: Last Logon SessionSummary Last LogOn Session: Looking for a audit related report that shows last time accessing Oracle Content I am able to query HCM related tables (such as per_users) to…
-
Security and users access to OracleHi Gurus, can you please assist in what best practices available to control the below points in Oracle fusion, and is there any report from Oracle that show last activi…
-
Fixed Asset Register report returns current period date instead of selected past datesFixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation. How will…
-
How can two different teams can use a single PVO with different set of columnsHi, We have a scenario where AP team can extract ledger PVO with different column set and similarly AR team also need to extract the same PVO with different column set. …
-
Budget Distribution Data in OTBI FusionIs there any subject area in Fusion OTBI that contains data from the following budget distribution tables: xcc_budget_dist_lines xcc_budget_dist_headers Currently, I can…
-
How can I join the DOO_HEADERS_ALL table with PO tables like PO_LINES_ALL in Oracle Fusion ?I’m working on a BI report for order and item details like order number and item number and description in Oracle Fusion, and I need to join the DOO_HEADERS_ALL table wi…
-
IBAN for OTBI analysisHello experts, we want to create an OTBI analysis with the IBAN info of the employees, does anyone know which subject area and which column we need to use? Thanks a lot …
-
query find history candidate pools in its different phasesHello. In which tables or subject area we can find the status history in its different phases of candidate pools. Thanks and regards.
-
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Any Subject Area in OTBI to achieve employee wise fixed cost CTC based on selected monthHi, We have a requirement to display the sum of CTC of all employees for that particular month selected via month input parameter. Please find the below sample requireme…