-
Allow Copy Paste on LoV based parameters
Currently the reports do not allow copy pasting values in the parameter field if the parameter type is LoV, users have to first click on the search button and then paste the values. Can we have a search functionality for reports similar to the way it works in the fusion screens.
-
Looking for option to increase the timeout for online BIP reports session and idle session timeout
Description (Required): Users are running online reports in the plant, and based on that, they do activities on the plant floor. By the time, they come back to check the next transaction BIP report online output gets a timeout within 6~8 minutes ,which causes an issue to perform the next activities and users have to keep…
-
Add 'Order Pricing' Information to OTBI Procurement Subject Areas
For proper reporting purposes, we need 'Order Pricing' Information added to a OTBI subject area: Procurement - Purchasing Agreements Real Time Field: USE_ORDER_DATE_IN_PRICING_FLAG
-
Access Output files from ESS jobs submitted by a different user without BI Administrator Role
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): Users should be able to access and download output files of scheduled processes submitted by a different user without having the BI Administrator Role. Example…
-
Include the open interface tables and the error tables in the OTBI areas
Organization Name Landsbond Christelijke Mutualiteiten Description It should be possible to report upon the open interface tables and the errors that occurred during the import processes. When building an end-2end-integration, it is needed to have an view on the transactions sent from the source application and compare…
-
Oracle Reports Output into Google Sheets
The capability to add a feature to where report outputs (BIP, OTBI, etc.) can go directly into Google Sheets instead of Excel that then can be uploaded into Google Drive.
-
How To Print Supplier Debit Memo
We have a requirement to print a Supplier Debit memo in Oracle Fusion Payables but as searched no option is available. Vendor/supplier is asking the same for their audit related requirements.
-
Password Protect Excel Files in OTBI for Scheduled Reports
Description Option to password protect excel files in OTBI for scheduled reports Use Case and Business Need With all the new and upcoming GDPR regulations, I would like the ability to secure (password protect) all the reoccurring reports that are being automatically sent to our employees inbox via OTBI. I have searched the…
-
Increase maximum size in the excel file export option for a report
There was an error rendering this rich post.
-
Add 'Requisition Preparer' Info to OTBI Procurement Subject Areas
For proper reporting purposes we need 'Requisition Preparer' information in following OTBI subject areas 1.Procurement - Purchasing Real Time 2.Procurement - Procure To Pay Real Time
-
Automating Email Recipient Updates in Oracle Fusion HCM BI Publisher: Seeking Community Insights
Problem Statement: We frequently receive multiple tickets from the business requesting updates to the email/distribution list recipient list in BI Publisher reports. This manual process of updating /editing email recipients for scheduled reports in Oracle Fusion HCM BI Publisher is inefficient and prone to errors. To…
-
BICC : Ability to combine two data stores to give single file output
Description Hello, Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import. Problem: At this stage, we send multiple files for example : For Accounts, there are two data store outputs…
-
select all columns option on drag and drop while creating report with data model
Description select all columns option on drag and drop while creating report with data model Use Case and Business Need It would be better if we have a option to select all columns on single click for drag and drop while creating reports with Data Model in BI Publisher Thanks - Thiru Original Idea Number: c4f23f2b46
-
Request to Enable Translation Editor for Item Description by Business unit
We’ve explored whether it’s possible to retrieve the item description from the child inventory organization instead of the PPIM master, but it appears that Oracle restricts access to the underlying query or logic—only the report template itself can be customized. To support multi-language reporting at the inventory org or…
-
What happens to my OTBI Deeplinks when Redwood apps are activated?
Hi, I have a tone of otbi reports that have deeplinks back to Work Orders, Purchase Orders and PO Receipts. What will happen to these links as the Redwood apps replace the classic applications? Thanks
-
Data Models: Restrict/enable access to certain data tables
We want our CMMS analyst team to have access to (and build) data models specifically for the Maintenance area. However, due to current system limitations, we are unable to restrict their access to sensitive personal data (e.g., HR information). As a result, the team is relying on OTBI, which is not ideal and is impacting…
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit Report
Organization Name Mercer (Australia) Pty Ltd Description Hi, Below mentioned two reports which are available in R12. And subsequently the seeded fusion reports are not giving these details. Unsuccessful Login Audit Report- * Report cannot be run for set period and no time stamp * Cannot track unsuccessful login attempts…
-
Fusion ERP PVO for Chart of Accounts and Projects - All segment details
Hi, Was wondering if there are existing PVOs for Fusion ERP that shows a list of all GL and Project segments and all details (codes, descriptions, relationships, etc). I raised an SR and was told to look into: FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO Unfortunately, this only lists valid…
-
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…
-
Need a BICC object for MSC_SAFETY_STOCKS
For our Fusion Reporting purposes we prefer using BICC. We could not find a PVO object corresponding to MSC_SAFETY_STOCKS. We looked through the view-object to database line-mapping in the link below and did not find one. thank you.
-
Introduce WMS Integration status column in OTBI
Organization Name MASSIMO ZANETTI BEVERAGE GROUP SPA Description We are creating a report using OTBI with the "Shipping Real Time" subject area. We couldn't find the column named Integration status that we have in Manage shipment lines in the Inventory Management screen. Customers needs it because he has to develop an…
-
New Subject Area - Maintenance Work Definitions
A subject area dedicated to work definitions and their associated operations / resource details would be very useful. At the moment, the only subject areas to pull through work definition data is for work orders. The new subject area would ideally Include columns such as file name where attachments exist at operation /…
-
MIssing PVO's in the BICC
We are implementing BICC to extract the data from ERP - Oracle Fusion. Below PVO's are not exposed in the BICC. Can you please have a look. PVO Name FscmTopModelAM.FinCeBankRelationshipsAM.BankAccountRefPVO FscmTopModelAM.BillingEventAM.BillingEventRefPVO FscmTopModelAM.FinApInvTransactionsAM.InvoiceHeaderPrepaymentPVO…
-
Add InvoiceID to InvoiceSelfAssessedTaxDistributionPVO
I had put this idea in a while ago, but it no longer seems to be listed, so here goes. All the columns from the base table AP_SELF_ASSESSED_TAX_DIST_ALL are available in the PVO except the InvoiceID, If I implement this pvo, I still need to get the Invoice ID (in this case I'm doing so via a BIP report that we also…
-
Add CHECKLIST_DISPLAY_NAME to subject area Workforce Management - Checklist Real Time
Can the column CHECKLIST_DISPLAY_NAME from table PER_ALLOCATED_CHECKLISTS_TL be added to the Subject Area "Workforce Management - Checklist Real Time" please? We have created an OTBI analysis within a dashboard using this subject area that reports the status of learning journeys (checklists) for people, but people can have…
-
Include requisitions with no applicants in Recruiting Real Time
When using the subject area Recruiting - Recruiting Real Time, you have to use a fact/measure in order to pull requisitions that do not have applicants (active or inactive). It would be great to be able to have these requisitions pull into reports with the use of a fact/measure.
-
How to increment automatically the date parameter value of a program which is scheduled
Description For a custom report there are 2 date parameters and report is schedule for every 1 hr and we want to increment the date parameter timestamp automatically for next schedule. Use Case and Business Need Business need to run the custom report for every 1hr where the date parameter time stamp need to be increment…
-
How does the "Request Read Receipt" functionality in report job works?
Customer is scheduling Fusion BIP report They have a request to send if the report they are bursting to user can have a read receipt functionality. They wanted to check if they can be notified when the Customer has received the Email or not.
-
Feature Request: Bulk Change of Logos in BIP Standard Reports
I am requesting a feature that allows for the bulk change of logos in BIP standard reports according to client requirements. Currently, logos are embedded directly within the templates as per Oracle's design. The 'Vision' logos are hardcoded in the standard reports and cannot be accessed through a sub-template without…
-
Submit a ESS Job with Submission Notes field using REST API
We see an option to tag any new "scheduled process" with "submission notes" through the UI. But we are unable to find the relevant option through the REST interface. Currently, this is not supported using API.