-
General Ledger - Journals Real Time issues with filters on Journal Source & Journal Category
When you create an OTBI analysis filter using Journal Source or Journal Category, the OTBI analysis XML hard-codes the IDOF key value. Therefore, when archiving and unarchiving reports for deployment into higher level instances, the reports break. Request that functionality be incorporated so this does not occur, and…
-
Adding Additional DFF information at expenses level to OTBI Reports
We have enabled a DFF at the expense line level to capture additional information. We have a a requirement of adding the descriptive flexfield value to expenses transactions real time report. Please let us know if it is do-able.
-
Can we send any Taleo Analytics reporting output file to any FTP location
Can we send any Taleo Analytics reporting output file to any FTP location. There is no FTP in delivery option. Taleo reporting URL: https://reporting********taleo.net/analytics/saw.dll?bieehome&startPage=1
-
Ability to query BPM Configurations through OTBI
Organization Name Clayton Homes (Berkshire Subsidiary) Description Since SOA Suite audit policies are not enabled by default, we cannot rely on the audit history to be able to monitor BPM configurations. There could be instances from an internal audit and external audit perspective where it would be necessary to report on…
-
Issue with Exporting "Bank Check" Report for Printing on Specific Printer
I am experiencing an issue while trying to export the "Bank Check" report to be printed on a specific printer. The issue lies in the sizing of the report, which does not appear to be compatible with the check format used by our bank or the printer specifications. Steps to Reproduce: Open the "Bank Check" report. Attempt to…
-
Consider adding "Payment Reference Number" in a Payables Payment Subject area - OTBI
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Please consider adding "Payment Reference Number" in a subsequent release of the metadata repository database (RPD) in OTBI Use Case and Business Need (Required):…
-
Ability to Recover BI Objects (Reports, Analysis, Dashboards) that have been deleted from the BI Cat
Description We would like some sort of Recycle Bin functionality to allow us to recover reports that were deleted accidentally or by other users. At the moment we cannot find a way to recover any items deleted in the BI Catalog. Use Case and Business Need -- This is critical as users may accidentally delete a report or…
-
Make flexfield information for DOO_FULFILL_LINES_ALL available in BICC
Hello! I would like to be able to use BICC to export flexfield information from DOO_FULFILL_LINES_ALL. Currently I can only export this information using BIP.
-
Enable EVALUATE function for OTBI reporting
Organization Name City of Hollywood FL Description We have reporting needs that require us to use the EVALUATE function. Since we do not have access to the RPD and certain columns or formatting is just not available in OTBI, we need this function turned on for a select group of super-users. It is possible that other Fusion…
-
Allow editing of the default width of OTBI folders section
Please add the ability to edit the default size of the Folder section in OTBI. The out of the box width cuts off most of the folder names and causes users to manually resize the section every time the page loads. It's extremely inefficient and bothersome to have to do this each time we navigate to the Catalog. See…
-
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…
-
Do not display a particular sub inventory in LOV under RSSP
In RSSP, while updating requisition preferences, if we select destination type as Inventory and deliver to location. After this, we have the option to choose sub inventory as well. Business wants that particular sub inventory let say sub inventory "A" should not be visible in LOV although that sub inventory (A) will remain…
-
Disable Drag and Drop for Report Folders
Organization Name American Express Description We have had issues with permissions when a report folder is accidently moved by dragging and dropping to another folder. When the folder is moved back it retains the permissions from the place it was moved to. This allows users to see information that they should not have…
-
Ability to change Date Format of Prompt
Description Users need to be able to enter dates in prompts in different formats Use Case and Business Need Need the ability to change the format that a users enters a date into a run-time prompt. We have changed the format of the system date to dd-MMM-yyyy and would like to enter the date into prompts in the same format.…
-
Automatic scaling of Analytics instances OCP's either through script or inbuilt schedule
Organization Name Hartford HealthCare Description Currenlty, this is not possible for oracle managed cloud tenancy This will allow analytics instances to cater to business needs as per demand. For example we can have 8 OCPU's for an Instance when the demand is high(Usually daytime 6AM - 6PM) and have 4 OCPU's during night…
-
Allow Multiple Values for Event Trigger Parameter
As of Oracle Analytics Publisher 12.2.6.1.12, event triggers accept only one value in a parameter. If you pass multiple values to a schedule event trigger parameter, the status of the scheduled job is set to Skipped. We would like to request that trigger parameters accept multiple values to fulfill a requirement we have to…
-
OTBI - Payable Invoices Subject Areas level need to add additional Field "Notes"
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): GE Additives (Stratus Fusion Support team) Description (Required): OTBI - Payable Invoices Subject Areas level need to add additional Field "Notes". Attached field is required to include in…
-
Agent Notification In failure Case.
OTBI Report Need a Notification mail Triggered when the OTBI agent is Failed.
-
Can we increase Maximum Sample Data Size Limit in Data Model?
Hello, We have requirement to increase Data model limit beyond 1 MB to implement some custom changes. But when we are trying to increase the Size limit, we are not able to do so as the field is grey-out. Hence, Can please assist us in increasing the Sample Data Size Limit in Data Model?
-
JWT token for BIP web service calls
Can anyone let me know if there is a way to use JWT token for Fusion Applications BIP webservice calls using Soap
-
Bring back the SYSTEM - LAST QUERY functionality from EBS allowing to get the SQL query used to disp
Description Hello, in EBS the functionality to search for SYSTEM - LAST Query on any result field to get the SQL query used to display those results including the filter applied would be useful to accelerate Custom BIPublisher report or other adhoc SQL requirement easier. Use Case and Business Need This would be useful to…
-
Remove HTML tags in columns without rendering OTBI
Description I would like to have the ability to report on "comment"-columns that contain HTML without being forced to render the HTML in column properties. So I would just like to have the plain text without any html tags ... or plain text without the html formatting ... Before I have been able to use EVALUATE REGEXP…
-
Receiving Interface data into a Business Area
Include data from receiving interface header and interface tables into any of existing receiving business areas or a new business area in order to allow analisis and infolets creation, that would provide report for receiving transactions stucked in receiving open interface tables.
-
Ability to Audit the BI Administration Configration
Organization Name Supervalu Inc Description Hi Team, We are looking to audit the BI Configurations, like who has added/Updated the Delivery Channels and when it updated. and other configurations. It will help business to have control over the BI Application. Thanks Use Case and Business Need Hi Team, We are looking to…
-
Tool or query to identify reports that use a specific field as a column or filter
There have been instances where our organization changes certain workforce structures or other key components that will then need to be updated in all of our existing reports. Like most organizations, we have many custom built OTBI Analyses and BI Publisher reports (1000+). When these key organizational components are…
-
Display more than 200 rows in OTBI while running an adhoc query
We run an adhoc query in Oracle cloud ERP by using OTBI(Navigation: Reports and Analytics -> Browse Catalog -> Create New DataModel -> SQL Query). The limitation of this approach is that it can only retrieve 200 rows (unless you can complete the steps to create the report and export it to excel). If we can get to see more…
-
Include Enterprise Scheduler Job Display Name in REQUEST_HISTORY table
Organization Name Northumbria Healthcare NHS Foundation Trust Description We have a requirement to build a report to replicate the 'Schedules Processes' UI page in fusion to allow clients to view all ESS jobs ran by users in thier organisation. The REQUEST_HISTORY looks to be the only table that contains this data, however…
-
SFTP Connection to AWS S3 Bucket
For customers that are not having a separate integration platform or middleware tool when they have to send data files from Oracle HCM to AWS S3 bucket it is becoming increasingly difficult. So, it would be wonderful to have a seeded connection mechanism to connect to S3 bucket and the SFTP services from AWS (we had faced…
-
Enable PGL Deduction Start Date and End Date fields in 'Payroll - Calculation Cards Real Time' SA
Hi Team, Currently the OTBI subject area - Payroll - Calculation Cards Real Time doesn't support Post Graduate Loan Deduction start date and deduction end date attributes. Because of this we are unable to use this subject area for reporting Post Graduate Loan related information. We have verified from Deduction Developer…
-
HCM Cloud - Audit for BI Report catalog folders
We recently faced an issue in the Production environment as some users deleted one of the catalog folders by mistake and it caused a huge impact on the business. Therefore, is there a way we can track who deleted/created/modified any folders?
