-
Agent Tracking/Reporting/Log in OTBI
Description Looking for a way to create a report which can provide information on all the agents ran successfully and/or failed on a given day. Ability in OTBI Agents to manage and keep track of agents which can give information/report about the details of notification triggered each day like to whom all notifications have…
-
Please enhance to have a function or menu to display / print results horizontally
Hello Team, BIP Report has couple of fields which by default display row by row instead requirement is to show from left to right horizontally as the values get populated. Example: Currently there is no options or menu to print or display values from left to right horizontally Kindly enhance BI Publisher to have this…
-
Alternate way to Provide Access to View Private Jobs for "Report Job History"
We have a requirement to provide viewing access for Private jobs under "Report Job History" in OTBI. But currently, in order to view Private jobs, the user must be assigned the "BI Administrator Role". But in our organization, the "BI Administrator Role" is provided to only selective user, but there are some other users…
-
BICC PVO for IBY_PAYMENTS_ALL
BICC PVO is required for IBY_PAYMENTS_ALL table. We have seen many cases where there's BIP reports created for table IBY_PAYMENTS_ALL and due to unavailability of equivalent BICC PVO, we are unable to move to recommended mode of data extracts from Fusion
-
Enable email domain restriction option for OTBI report as well
Hello, We need an option to enable the email domain restriction for OTBI report. For BIP Reports we may restrict the "Allowed Email Recipient Domains" to our internal domain, the same doesn't work for OTBI. Thanks,
-
Deactivate the possibility to send an OBI report to anyone
Use Case and Business Need Hello, Currently, in OBI, it's possible to send an OBI report to anyone, even if this person is not working for our company. Indeed, you can enter anyone's email address if you click on the little green cross which is in a grey square. From a confidentiality data protection point of view, it…
-
Report 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 users who have used the service before. Regards, Dave.
-
BICC : Reset Last Extract Date at PVO Level
Organization Name World Wide Technology Description Summary:To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all offerings levelDescription:Currently there are two ways change the Last Extract Date filter within BICCC outside of the built in incremental Logic BICCC…
-
Increase in OTBI Analysis row limit
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): In Oracle OTBI Analytics, we have limitations to extract the number of record to 2,50,000. But in most of the Scenarios, there are more records to be extracted.…
-
Option to increase ACL limit
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): WM Morrisons Supermarket Limited Description (Required): After we moved to 22B earlier this year, we noticed a new restriction while adding users or roles to BI folder permissions. We get…
-
Dynamic display of sets of columns in OTBI or BIP reporting tools depending on run location
Organization Name Marriott Description Hi We have a gap in our requirements where we need the reports to only display country specific columns. We want our reports (BIP or OTBI) to have the ability to dynamically display different sets of columns or flex fields depending on the country the user is from. Requirement for the…
-
ARCS Report - Multi-Select Prompt?
Organization Name MGM Resorts International Description Would like to request an Enhancement to have a prompt for our users that would allow them to be able to have a multi-select capabilities for multiple entities for our reports in ARCS. Within the Reconciliation page, we can do various filters that allows multi-select,…
-
Report Material Transactions- Redwood Mobile App
Dear Team, We are unable to add "Report Material Transactions" page in Redwood mobile application to perform the Work order issue. Reference SR: 4-0000980544 :Report Material Transactions- Redwood Mobile App Thanks, Upender
-
Enabling DFFs on Value Set Values in OTBI
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): アクセンチュア株式会社 Description (Required): We would like the Descriptive Flexfields (DFFs) on Value Set Values to be available in Oracle Transactional Business Intelligence (OTBI). Currently, the…
-
Unable to adjust Page composer using Iframe to display BIP report
Currently I am facing issue to hide layout name in embedded iframe with page composer, From the below screenshot Supply_Straytegy is layout name. tried: _xmode=4 _xdoLayout=<Your_Layout_Name>
-
Need table access to extract the bursting details
Need tables to extract the following Job / Process ID Submitted By Submitted Date/Time Email Option Business Unit Legal Entity Company Property Job Status Report Name Subject Delivery Status Reason Recipient (To) Recipient (Cc) Sent Date/Time for bursting
-
Add "Pay Each Invoice Alone" Field to Supplier Real Time Subject Area
Organization Name Clayton Homes Description The field "Pay Each Invoice Alone" should be available in the Subject Area, Supplier Real Time. We need this for our custom report creations. In the supplier profile, this field is stored under: Site > Payments > Payment Attributes > Payment Specifications > Pay Each Invoice…
-
Last Login Report for more than 7 days
Organization Name FERGUSON Description Please add a report that can identify the last login date of a user, which goes back further than seven days. Use Case and Business Need For audit reasons we need to capture the last login for terminated user and there does not appear to ben usable report to do this. Original Idea…
-
Retaining OTBI Parameters in OTBI Output
Description (Required): Parameters in OTBI are lost once we run the OTBI Report. We enter the values in parameters in OTBI Report and click on Submit. After submit, we see the output but the parameters are not visible. Therefore we need the parameters on top of the report output so that we can update the parameters again…
-
OTBI Export to Excel or CSV limitation
Organization Name Capgemini Description Hi Team, The OTBI Report export to excel or csv limited to 25k and 75k rows.This Limit is very small for business requirements.It's better to provide some configuration to increase this limitation in OTBI. You can look at this SR (SR 3-21271633161 : OTBI Report Export Limitation) for…
-
Allow the Create Analysis feature to also access data models and not just subject areas.
Could you please extend the analysis functionality to also be able to use data models. We find when creating operational working dashboards the analysis works better for us than using reports as reordering columns, creating selections and sections gives the dash user much more flexibility. Unfortunately, where the data we…
-
OTBI Link to Payables Invoice Image
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Wincanton Description (Required): I am trying to create an OTBI Analysis for AP Invoices so that I can query specific invoices for a supplier, date range etc which is all fine but I also want…
-
BIVOs do not have AP_INVOICE_AGING_GT and AP_PAYMENT_TEMPLATES
I have checked FSCM lineage sheet in https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping-spreadsheet, but I couldn’t locate any BIVOs that contains columns from AP_INVOICE_AGING_GT and AP_PAYMENT_TEMPLATES tables. This BIVO is required for the…
-
BIVOs do not have CE_BAT_TRANSFERS
I have checked FSCM lineage sheet in https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping-spreadsheet, but I couldn’t locate any BIVOs that contains columns from CE_BAT_TRANSFERS table. This BIVO is required for the customer. Can you please…
-
FscmTopModelAM.GRCTOPBIAM.AssessmentPVO - Enable all columns for reporting
An SR was raised because the BIVO fails when all columns are enabled, returning the following error: Caused by: java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 904, message: ORA-00904:…
-
AdvancedAccessControlDetailsRefPVO and AdvancedTransactionControlDetailsRefPVO - Enable all columns
An SR was raised because the BIVO fails when all columns are enabled, returning the following error: Error: Query Failed: [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "CONTINUOUSCONTROLTRANSPEO"."REVISION_NUMBER": invalid identifier Oracle has recommended submitting an enhancement request to support…
-
FscmTopModelAM.GRCTOPBIAM.DataSourcePVO - All fields should be enabled for reporting
An SR was raised because the BIVO report fails when all columns are enabled, returning the following error: Error: Query Failed: [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "DATASOURCETYPEVERBASEPEO"."SGUID": invalid identifier Oracle has recommended submitting an enhancement request to support enabling…
-
FscmTopModelAM.GRCTOPBIAM.ControlTestPlanResultPVO - All fields should be enabled
An SR was raised because the BIVO report fails when all columns are enabled, returning the following error: [nQSError: 17001] Oracle Error code: 1445 ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table Oracle has recommended submitting an enhancement request to support enabling these…
-
OTBI Change Order Subject Areas- Column to identity the Changes
Description We have Change Order Subject areas in OTBI but there is no column to specify is the change related to Price,Quantity,Charge account etc.. and what value has been changed. It will be good to have this in this subject area. Use Case and Business Need Business performing more change orders and need to captures…
-
Translate customize column headers in several languages
Organization Name MERKAFON DE MEXICO, S.A. DE C.V. Description Hi, We need to translate customize column headers on different languages. Now If you customize a column header you always see the same label on all languages. Nowadays native column headers show correct label If you lig-in on English or Spanish, but not the…