-
Item EFF Displays Multiple times in OTBI
When a UDA is assigned to multiple item classes, it displays multiple rows in OTBI. Due to the volume of item classes that Sherwin Williams have, this will result in repeating the same UDA values a lot of times and not efficient for users to select required data. The UDA should only appear once when attempting to create an…
-
Internal Requisition Line not available in OTBI Analysis after 19D (ER 30808885)
Organization Name ATCO Description OTBI requisition analysis cannot pick up lines that go through transfer order processWe created OTBI analysis to track requisition line details. After 19D when internal requisition and transfer order process became mandatory, the same analysis can no longer pick up requisition lines that…
-
External data sources support in Fusion Application BI Publisher
Organization Name Willis Towers Watson Description In order to invoke webservice from SAAS to OIC we can configure it as external data source , this feature is currently available and would be deprecated in future release as per Fusion Applications BI Publisher: External data sources are not supported (Doc ID 2003782.1) .…
-
Want to disable export ,send and Schedule option for some BI reports
We have requirements to to disable export ,send and schedule option for some BI Reports.The user who has BI consumer role is able to Schedule,export and send the reports, we want to restrict it.
-
Want to disable export ,send and Schedule option for some BI reports
We have requirements to to disable export ,send and schedule option for some BI Reports.The user who has BI consumer role is able to Schedule,export and send the reports, we want to restrict it.
-
Seamless prompt behavior between User Interfaces
Adding a 'prompt' for Order Management 'Order Number' works when running an Analysis in the 'Catalog' UI but does not work when running from the 'Edit Analysis'. Additionally, when attempting to add the 'prompt' in 'Edit Analysis', the user is shown 'error' due to the vast number of unique values for the needed 'order…
-
Tags on forum topic submission
Description Update the tags on forum topic submission Use Case and Business Need Oracle Sales Cloud Reporting and Analytics tags need updated. The current tag options are NOT relevant to developers of reports and analytics in the Oracle Sales Cloud. Neither are the tags on this idea submission form. Oracle, please update…
-
Data Purging
We understand that if an organisation would like to purge the job history (reports), every time they need to raise SR which is inadequate solution on long term. It would be helpful if there are manual workaround or self-service available to delete the job history regularly so that we are compliance with data privacy.
-
File Type as Parameter in oracle BIP online preview
File Type is a parameter in the online preview of the BIP Report. : When executing the BIP report online, the user must pick the template type in the parameter as LOV. We know that utilising bursting/ESS makes this possible. BIP online report preview should have the same features.
-
Option to restrict drilling on OBIEE
In OBIEE answers analytics it would be helpful if there were an option to disable drilling in level based hierarchies where levels that have already been expanded once. Currently if the user drills down a hierarchy made up of Country->Region->Province->City at every level of the drill down process it is possible to drill…
-
Add Receipt Status to 'Receivables- Miscellaneous Receipts Real Time' subject area
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Southern Company Description (Required): Need the Receipt Status added to 'Receivables- Miscellaneous Receipts Real Time' subject area. The Receipt Status is a part of the Receipt header and…
-
TEST
TETS
-
Ability to view attributes for a KFF value within OTBI Subject Areas such as Enabled flag etc
Our client wants to be able to see the start date of a value and whether the value is enabled/disabled from the OTBI Subject Area. They want to see the segment values and all the attributes of Key Flex Field Values in the OTBI Subject Areas of ERP. These attribute fields are not available to drag and drop for analysis. It…
-
Ability to Apply Branding to the OTBI Reporting Catalog
Organization Name Marriott International Description The ability to "brand" OTBI reporting tools to adapt to client needs would increase consistency across HCM modules and improve the perception of a seamless end user experience across HCM and reporting products. Specifically, the ability to change the Oracle logo (and to…
-
Defaulting attributes like server, security group while scheduling a report
We are trying to schedule a report and want to default the server and security groups when we add a destination and submit the job. It will be a great feature even for the PRINTERS, FTP, and CONTENT SERVERS We have raised "SR 3-32856516551 : Defaulting Server, Security group attributes on the report definition"
-
Add Position DFFs to the "Request a New Position" Notification template
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): DAZN Description (Required): We recently started using position management and we are trying to customise the CreatePositionReportRTF to add the Position DFF fields to the notification, but…
-
To have Information for Additional Information column when Action Done= Rejected
PLUS Malaysia Berhad requires the information for Additional Information column when using Subject Area= Purchasing Real time. When a Buyer build an OTBI analysis using Subject Area: Purchasing Real Time to get information for Document History, select all column belongs to Document History to track the Action Done=…
-
BICC PVO for Fusion tables AR_CONS_INV_TRX_ALL and AR_CONS_INV_TRX_LINES_ALL
Hi, Can anyone let me know the BICC PVO's for tables AR_CONS_INV_TRX_ALL and AR_CONS_INV_TRX_LINES_ALL. We are using these tables for our reporting purposes. Regards, Vinod
-
BICC Prune time setting at the Offering level or PVO level
Can I set different prune times for different offerings? for example - prune time for offering "AT&T RMCS BICC ExTract" is 1 hour and prune time for "Financials" offering is 24 hours.
-
Retain OTBI/BIP report jobs upon P2T
Organization Name Mazda Motor Europe Description Doc ID 2581724.1 states that "P2T refresh clears the scheduled information too. Hence, it requires to re-schedule all required jobs post P2T refresh." which in our case results in a hefty job since we have dozens of reports scheduled on test environment. Hence looking for an…
-
BI Publisher Security
Currently report output generated using "Make output Public" is visible to everybody but we want to restrict this Public output of the report to a particular group of people.
-
Trace in BI Catalog
Organization Name Haggar DMCC Description i stuck with big issue on 16 jun 2019 ,Missing custom Folder under Share Folder->Custom->Finance Custom Reports ,missing this folder from Test and Production , i raise a ticket 3-20382772351 to oracle support and provide me work around to check if this folder is Hide and give me…
-
Report to get details about security roles and permissions configured for all reports
Organization Name AlixPartners Description Hi, Looking for report that can provide a complete dump of all the security roles and custom permissions across all reports in the HCM application. This request was posted in the Reporting and Analytics forum and was advised to convert it into an IDEA.…
-
70+ columns in Grid View of the BIP Report Output
Currently if we have more number of columns in the Grid view output of bi publisher, its not readable. The work around is to view the output as HTML which will expand the columns based on the size. But there we can filter or do activities performed in grid view output. Hence raising this Idea
-
Need a Tool to create BI Reports through automated way
We want to have a tool that will create a BIP report by just selecting tables involved in the report. Instead of writing logical sql queries, we want a tool which will find the joins and automatically generate the query which will save time for Developers.
-
Hide a column in OTBI Report
Hello, I recommend implementing an option to hide columns in the OTBI report like the option "Exclude". With this option, unlike what is happening when columns are excluded, it is hoped that it will not be necessary to generate new information thus not end with error. Thank You, Pedro Caeiro.
-
Ability to cast varchar columns in BICC as strings
Hi team, We are setting up an automation of data from Fusion via BICC to Another Database. In the due process we have set up some offerings on the BICC end. Data types of some columns of below tables like 1.attribute23,ordernumber,transactionsourceamountcurr from cn_tp_transactions_app…
-
BICC file name on UCM are not generating with Prefix as provided in BICC Job Schedule
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Thermo Fisher Scientific Inc. Description (Required): BICC file name on UCM are not generating with Prefix as provided in BICC Job Schedule Created and executed one Job Schedule in BICC where…
-
How to Handle Duplicate Supplier Invoice Numbers in Oracle?
Business have some supplier's who sends us invoices with same invoice numbers but with different financial year dates. I am not able to enter this in AP since I get the message 'Duplicate Invoice Number'. Since this is a supplier invoice, I do not have any control over his invoice numbering. How do I handle this situation…
-
BIP - how to find fields, tables and joins in HCM - Entity Relationship Diagrams (ERDs)
Organization Name: Euroclear As confirmed to me via SRs and messaging Oracle employees, as well as by our 3 integrators, there is no documentation currently available regarding the relationships between the tables in the system. Assuming we manage to find the table which contains the field we want (more on that in a…
