OTBI
Discussion List
-
Output Manager Hierarchy in OTBI with a column for job title following each Parent Manager nameSummary: Output Manager Hierarchy in OTBI with a column for job title following each Parent Manager name Content (please ensure you mask any confidential information): H… -
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…
-
Not able to capture failure events on the maintenance work orderSummary: Not able to capture failure events on the maintenance work order Content (please ensure you mask any confidential information): We are trying to add failure eve…Abhishek Kumar Ranjan 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Maintenance
-
Is there any table that stores the IDR invoice scan details in Oracle Fusion ?Summary: I am looking for a query/table name to get the IDR invoice scan details. There is a table AP_IDR_INVOICE_TRACE_DYD but scan details doesn't get persisted for lo…Dipak Das 22 views 3 comments 0 points Most recent by Dipak Das Payables, Payments & Cash Management
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 51 views 6 comments 0 points Most recent by Abdullah Samy-Oracle Reporting and Analytics for SCM
-
If anybody worked on ZPL format for label printing can you please share the ZPL formats and outputsSummary: We need to implement zpl format to print the labels using zebra printer. So need any samples of ZPL formats which are already implemented Content (please ensure…
-
Need SQL Query to find Baselined Project Budget VersionSummary: Hi Please help us to query baselined project budget version by sql query. I want to find the Project Number, Version, Revenue Budget, and Cost Budget. Our expec…
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
-
Account Analysis Report Ledger Set returns NULLSummary: Account Analysis Report (OTBI) returns NULL for Ledger Set. Works for everything else. Content (please ensure you mask any confidential information): Hi, does a…
-
HDL for to upload the goal in librarySummary: Dear team, We are looking a HDL to upload the goal into goal library. Thank you! Content (please ensure you mask any confidential information): Version (include…
-
Workforce Performance - Performance Task Status Real Time showing incorrect assignment informationSummary: The Workforce Performance - Performance Task Status Real Time subject area seems to be displaying incorrect assignment information for employees that have had t…
-
Supplier Management Redwood Visualization Not Persisting (26A)Summary: We are attempting to configure a Redwood Supplier Management landing page and add OTBI‑based visualizations (Donut/Bar/Tables) alongside KPIs using Edit Page La…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 21 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
How to extract requisition approval rules created in BPM as a report or CSV file.Summary: Requirement is to extract approval rules along with details/settings of the various stages, participants and the rulesets. Content (required): I have referred a…Ananda Bhargav Potluri 1.8K views 10 comments 3 points Most recent by Souhardya Ranjan Das-Oracle Self Service Procurement
-
Is it possible to save my preferred filter within the dashboard?Users cannot save or retain their own personal filters in the reports or dashboards. I understand that we can only configure default report filters/parameters - this fea… -
How to get the PO number from AP Distributions in OTBI?Summary: We are creating an analysis using "Payables Invoices - Transactions Real Time" and when trying to get Purchase Order number from Invoice Lines, it appears blank…Arshad Hanif 102 views 3 comments 0 points Most recent by Raj Rathor Payables, Payments & Cash Management
-
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):…
-
Custom lovSummary: How to incorporate custom lov Content (please ensure you mask any confidential information): I have an existing audit report which has two prompts. 1. Employee …
-
Training Suppliers Details OTBI report not providing all the data in the UIHi, I have created the Training Supplier Details OTBI report from Workforce Learning - Learning Management real time subject area. However the records retrieved through …Thisara Dilshani 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to Hide/Show Analysis in Dashboard Based on a Parameter ValueHello everyone, I’m working on an OTBI dashboard and need some guidance. The dashboard contains multiple analyses, and I would like one specific analysis to display only…Andriampeno Odilon 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Why does the contact owner field unavailable in CRM-OTBI?Hello, I need a report that requires contact details that were not associated to any accounts. I am using the Sales - CRM Contacts Subject Area. However, all I can get i…Ivony Ann Paula Salango 1 view 2 comments 0 points Most recent by Ivony Ann Paula Salango Reporting & Analytics for Sales
-
Learning Initiative not using most recent version of analysisHi, We have had an issue with initiative assignments based on analyses not running correctly since our golive in June 2024. Today we did a large batch training assignmen…
-
Best practice to implement technical bulletin?Summary: Our client currently has an alert/notification process for alerts to technicians when there is a change or notice which needs to be dispatched to maintenance te…
-
How to create custom filters and infolets in redwood screenSummary: How to create custom filters and dashboard in redwood Content (please ensure you mask any confidential information): We are looking to create several other filt…Abhishek Kumar Ranjan 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Maintenance
-
Display Department Title on all levels of Department Hierarchy OTBISummary: Need to pull a report of all levels of our Functional Department Hierarchy with Department level 1,2,3,4 Name, and Associated Department Title. Content (please …
-
Credit Limit not seen on the Hierarchy members of the Organization in CDMSummary: As per the below image on the documentation https://docs.oracle.com/en/cloud/saas/financials/26a/faofc/how-the-credit-limit-is-derived-in-a-party-hierarchy.html…
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the …MDge 31 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
SQL query to fetch public holiday according to the work schedule of an employee.Summary: need a SQL query that fetches public holiday according to the work schedule of an employee. Content (please ensure you mask any confidential information): I nee…
-
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 71 views 9 comments 0 points Most recent by Surjith Kumar Reporting and Analytics for HCM
-
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 541 views 6 comments 0 points Most recent by Niru - Startek Reporting and Analytics for HCM