-
Ability to Add and Save Notes to an OTBI Report
Description Ability to add and save notes to an OTBI report, similar to a write-back feature, where you do not have to configure/update a DFF through the UI and are not restricted to the 150 character limitation that DFFs have. Use Case and Business Need We have several reports that get generated and sent to external…
-
OTBI report to get Fusion business object wise audit trails
Organization Name Virtusa Pvt. ltd Description Hi Everyone, We want to explore any possibility to have business object wise audit trails to a single OTBI report for below fusion modules. Global Human Resources Oracle Middleware Extensions for Applications Compensation Product Hub Recruiting Global Payroll Profile…
-
OTBI report to get Fusion business object wise audit trails
Organization Name Virtusa Pvt. ltd Description Hi Everyone, We want to explore any possibility to have business object wise audit trails to a single OTBI report for below fusion modules. Global Human Resources Oracle Middleware Extensions for Applications Compensation Product Hub Recruiting Global Payroll Profile…
-
Restricting data access in OTBI and BIP Reports using AoR's
Organization Name Tesco Description Hi Oracle Team, We have a requirement where we need to restrict the employees data related displayed in the OTBI Analysis by specific AoR's.. If the employee has 3 different AoR's then the OTBI Analysis currently displays data based on all the 3 AoR's and displays a huge set of…
-
Support ODBC connection using Snowflake and OBIEE 12C
Organization Name FMR LLC Description We would like an enhancement for OBI 12C to support the Snowflake ODBC driver. Use Case and Business Need Instead of using the JDBC we will be able to directly use the ODBC when connecting to snowflake database for obi reporting. More details We are integrating snowflake DB with OBIEE…
-
API Extract of OTBI Catalog Elements
Organization Name Oracle Description I am able to extract the CATALOG elements for BIP elements (data models, reports, templates) using this SOAP WSDL: https://eolh-dev3.fa.us2.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl . However, I can only extract the BIP elements. In order to provide seamless and…
-
Rejection Comments column not available in Payables Invoices - Transactions Real Time SA
Organization Name National Westminster Bank Plc Description We have a business requirement to capture comments added at the time of Rejection/Approval of an Invoice. We have created a Custom OTBI report for Invoice Rejection details. We could not find any column for Rejection comments/Approval comments in Payables Invoices…
-
otbi installment report
Description through otbi analysis and the subject area “receivables payment_schedules real time” I am trying to extract the information about the installments present in an invoice; at the moment, however, it is not possible to have an analysis with the history of the dates present for the installments; it would be useful…
-
User Audit Internal and External Report
Organization Name SKY Airline S.A. Description Hello to all, we suggest a report with de follows: user name, email, employee name, position area or department, status of the account, creation date, last modification date, delete date, last connection on the system. this will help us on our AUDIT process Use Case and…
-
Add Enable Flag field to all the Chart of Accounts folder in all the General Ledger related Subject
Organization Name Williams Information Technlogogy LLC Description Enable Flag Field is missing in all the Chart of Accounts folders in General Ledger related Subject Area. Use Case and Business Need Enable Flag field in all eight Chart of Account segment folders will help in determining if the values are enabled or not.…
-
Receiving - Purchase Receipts real time doesn't fetch the quantity details with the user having BI a
Organization Name TITAN Description Receiving - Purchase Receipts real time doesn't fetch the quantity details with the user having BI admin access . Bug 28130197 Use Case and Business Need User having BI Admin access not able to fetch the data from Receiving - Purchase Receipts real time Original Idea Number: e689f23072
-
track or pull and report any such schedule which has been active but not necessarily running in the
Description Hi Team, We have a requirement to find out or track or pull the report job details for any scheduled BI job which has been active but not necessarily running in the required intervals. Thanks, Arul Iyyadurai Use Case and Business Need Hi Team, We have a requirement to find out or track or pull the report job…
-
track or pull and report any such schedule which has been active but not necessarily running in the
Description Hi Team, We have a requirement to find out or track or pull the report job details for any scheduled BI job which has been active but not necessarily running in the required intervals. Thanks, Arul Iyyadurai Use Case and Business Need Hi Team, We have a requirement to find out or track or pull the report job…
-
OKTO SSO authentication for Smartview OTBI extension
Description For the 'standard' smartview the integration with OKTA SSO authtenticaiton is up and running. We are also using the OTBI extension in Smartview. The login screen to connect to Fusion is not using OKTA SSO (but asks for username and password). Use Case and Business Need Extension is useless since authentication…
-
Ability to display repeating section across the page (from left to right) in OTBI report.
Description Currently in OTBI report (BI Publisher Report) we can only display the repeating section from top to bottom, need an option to display the repeating section from left to right. Use Case and Business Need Business needs a report to display the product build quantity at product group, yearly/quarterly level. For…
-
Ability to override Oracle set NLS_DATE_LANGUAGE default value of NUMERIC_DATE_LANGUAGE
Organization Name Rutgers, The State University Of New Jersey Description To conform to I18N standards, Oracle has recently made changes to the NLS_DATE_LANGUAGE. This means that where ever to_char function is used on the date field for reformatting, it will be required to include NLS_DATE_LANGUAGE. Can Oracle provide a…
-
Ability to override Oracle set NLS_DATE_LANGUAGE default value of NUMERIC_DATE_LANGUAGE
Organization Name Rutgers, The State University Of New Jersey Description To conform to I18N standards, Oracle has recently made changes to the NLS_DATE_LANGUAGE. This means that where ever to_char function is used on the date field for reformatting, it will be required to include NLS_DATE_LANGUAGE. Can Oracle provide a…
-
Allow option to keep Report Job History when report run via webservices in Synchronous mode
Organization Name Rutgers, The State University Of New Jersey Description When using runReport() in ExternalReportWSSService the report is not logged as a job in BI. SR 3-26120452191 was logged, but Oracle confirmed that runReport is like running the report interactively. There is no log in the report run history. There…
-
OTBI Deeplinks in SCM and Finance
Organization Name ResMed Pvt Ltd Description Deeplinks required for below Modules. 1. Allocations 2. Cash Management 3. Cost Accounting 4. Purchasing 5. Receipt Accounting 6. Expenses 7. Global Intercompany 8. Revenue Management 9. Channel Revenue Use Case and Business Need To develop a OTBI GL Analysis tool to drill from…
-
OTBI Catalog object auditing.
Organization Name MTN Group Management Services (Pty) Lt Description OTBI Reporting is centralized. It has multiple custom reports and it has multiple folders which are spinned across multiple countries using the same instance. In some cases users are moving the reports /folders/dashboards from one custom folder to another…
-
Ability to More Easily display correct decimal separator in OTBI Reports
Description Different countries and regions have different decimal seperators. For example - We have a need to display values using the ., and ,. separator depending on the country running the report. In Italy a number should be 1.000.000,00 where in the US it would be 1,000,000.00. This is not specific to currencies but…
-
Forward and Backward Button in BI Answers
Description Currently, the challenge is that you can't reset changes in BI Answers. Accordingly, a deleted field or a changed expression cannot be reset, but must be created again. The browser-based forward and back buttons do not work. Such a function would be very helpful. Use Case and Business Need Increased efficiency…
-
Forward and Backward Button in BI Answers
Description Currently, the challenge is that you can't reset changes in BI Answers. Accordingly, a deleted field or a changed expression cannot be reset, but must be created again. The browser-based forward and back buttons do not work. Such a function would be very helpful. Use Case and Business Need Increased efficiency…
-
HCM VOs missing in BICC & OTBI - HCM/Pay Cost tables mapping not available
Organization Name Archrock Services LP Description Looks like the pay cost tables do not have the related VOs mapping in OTBI. These tables need the related VOs for some of critical HCM reports. HR_OPERATING_UNITS pay_cost_allocation_keyflex pay_cost_allocations_f Use Case and Business Need Business Case : We have some of…
-
OTBI Field for Manager Work Email
Description Add an OTBI Field in the Worker -> Manager Folder for Manager Work Email. Currently there is the E-Mail Address for a Manager but that is based on the Primary Flag not the Work Email. Employees can make changes to what email is the Primary Email. Use Case and Business Need We have many types of reports that…
-
Budgetary Control - Transactions Real Time Subject Area to include Chart of Account Segment Values
Organization Name NatureScot Description I want to use the OTBI subject areas to create analysis reports that can be used in the organisation. However, the "Budgetary Control - Transactions Real Time" subject area only includes the concatenated segments of the chart of accounts or the Department, fund or object (inour case…
-
Reporting and Analytics: Matrix Manager email address and username
Description OTBI Subject Areas related to Workforce contain few attributes describing Matrix Manager - Type, Level, Name and Person Number. These columns can be found in Matrix Manager dimension. Is it possible to have an Email address and username of a Top Manager added to the Matrix Manager dimension? Use Case and…
-
Add Segment Level metadata to the OTBI Subject Areas: Fund, Account, etc.
Organization Name UCSD Description We have a need for reporting based on metadata like values on our segments, e.g.: FUND status, created/started date, end date ACCOUNT posting enabled, status, created/started date Currently the only way to expose this data (that I can find) is through BI Publisher. But we lose a lot of…
-
On OTBI report permissions option should be available to override the data security profile values a
Organization Name Persistent Systems Limited Description Since the OTBI strictly follows all security profile setting of roles to show the data in reports of all subject area. This is causing issue in Learn module to show Instructor details to learners in any OTBI report and similar way to Instructors to show the list of…
-
Ability to show USD Amount in a user-specified conversion rate type in OTBI Report
Description We're building an OTBI report using subject area: Procurement - Purchasing Real time, the requirement is to pull the PO amount in USD currency based on the exchange rate on PO creation date (exchange rate type is 'Spot'). We pulled column - Purchase Order Distribution Amount in US Dollar Currency, and US Dollar…
