-
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
-
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
-
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
-
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…
-
25C Default Time Zone is lost on Schedule Reports when the calendar is selected
Since 25C when scheduling a report, the default time zone shows the schedule tab, for us its GMT. Once the calendar is selected the default is now (UTC-11:00) Midway - Samoa Time (ST) Can the time zone default be returned. Julie
-
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…
-
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
-
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.
-
Increase maximum size in the excel file export option for a report
Is there a way to increase the max. number allowed for export? Refer to attached excel pls, even after we put one day date range, it still exceeded the max. number allowed (scroll to the last column and you can see the error given by the system)
-
Fix the .xls output limitation of 65k rows for Oracle BI Reports
Please address the .xls output limitation to 65K rows. As an ERP Cloud Report user I need to have excel reports use the newer versions of excel if possible - XLSX so that I can get more than 65k rows of data and bypass the limitation for report output data.
-
How to add User Name (Report Run Name) in OTBI Title
I want to add User Name (Report Run Name ) in OTBI Report. I need this field at Report Title Level . I have used this command "Report Run By: @{NQ_SESSION.USER} | Run Date: @{system.currentTime}" but it is not giving results for Report Run By.
-
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…
-
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…
-
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…
-
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…
-
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 /…
-
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 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.
-
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