-
LPN to be synced in Fusion as WMS
There is no placeholder in Fusion Inventory to store the WMS LPN Details in the On-hand screen. Business needed LPN to be synced in Fusion as WMS so that corresponding report (majorly transactional) have LPN details in it. Needed Option to sync WMS LPN in Fusion
-
SFTP using Oracle BI Bursting is not working: Oracle Fusion Cloud Applications 23D (11.13.23.10.0)
Hi Team, Please advise if any one has faced issue using BI report bursting for SFTP and share the solution/idea please. We are trying to send file to SFTP location using report bursting by scheduling report but it is failing with below error message. *********ERROR MESSAGE************* Document delivery failed…
-
select count(*) should equal the # of rows select *
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Touche Tohmatsu (Deloitte Australia) Description (Required): When using OTBI the Following quieries should give back consitent results: select count(*) from EXTERNAL('ADF',…
-
Enabling County/District on OTBI Subject Area
Organization Name Deloitte Consulting LLP Description We have an address where the County/District are not supported by Person Real Time Subject Area. The values are not in Region1, for a change. When we populated the County/District for an employee, the value did not hit the Region1 but it got stored in Additional Address…
-
IDCS EPM REST API to have new and old values for audit purpose
We have a requirement to build custom audit report on EPM, wherein all events needs to be captured with following attributes Admin who performed the action User on whom action is performed Old value of the event New value of the event Currently, we're unable to identify old and new value, hence logging a idea to capture…
-
Do we have report which gives user is present in which approval workflows
Suppose any employee leaves the organization , then we need to replace him by another user. Hence we want a report which can give details of workflow and we can go ahead and make necessary changes. Example : We submit report for User A and output shows us that user is present in approval for GL ,PO etc We have several…
-
Customize standard Payables -> Invoices page to add additional content (OTBI Reports)
Organization Name Infosys Description Ability to customize standard Payables -> Invoices page Currently Oracle Fusion does not provide an option to edit the landing page for (Payables - Invoices). Use Case and Business Need Currently we have three Infolets on this page (Recents, Holds, Prepaid). Our Business is looking for…
-
OTBI Analysis - need ability to increase limit on Excel and CSV exports
Currently the limit when exporting data as excel or CSV is 75,000 lines. When analysing several months of data, this is not enough, and means that we have to limit OTBI Analysis using filters, then bring the data together outside OTBI. Please either increase the limit to 250,000 (or more), or include the ability for…
-
Lease Detail Report - need to attach multiple time
Multiple attempts required to attach the Lease Detail Report, possible to correct this bug in new release.
-
VOs missing in BICC & OTBI - Projects views mapping not available
Organization Name Archrock Services LP Description Looks like the Projects views do not have the related VOs mapping in OTBI. It will really help for creating Project reports with VOs. PJF_TASKS_V pjf_proj_all_members_v Use Case and Business Need We are working on a project of converting our EBS reports and data warehouse…
-
BICC Extract PVO's for PJO_PLAN_VERSIONS_B and PJO_PLAN_LINE_DETAILS
Description We are looking to pull all the data from ERP-SaaS associated with two Project tables: 1. PJO_PLAN_VERSIONS_B 2. PJO_PLAN_LINE_DETAILS Currently, the VO's associated with the BICC extractions for these are such that joins/filters cannot be modified, and we are seeing unexpected results. There are not VO's…
-
Capability to develop custom audit report on user management action
Currently, we need to identify tables to extract the audit information for below action items in Fusion SaaS user management screen. Password Reset Lock/Unlock users Activate/Inactivate Users Assignable/Unassignable Role Currently, this information is unavailable in any table to have a custom audit report built.
-
Need inputs on Process Supply Chain Orchestration Interface Job.
Hi Team, We have standard ESS Job Process Supply Chain Orchestration Interface. We want to make the From Supply Request Batch Number, To Supply Request Batch Number parameters as mandatory. This customization is feasible..? We have gone through the below document. If this customization is not feasible. …
-
Warning Message Before Moving Folders In BI Catalog
Description If the user has the correct permission, BI folder catalogs can mistakenly be moved from one folder to the other. This can be disruptive because users may not be able to find reports and reports/dashboards may be broken if the path to the data models/analysis is in a new location. Even with permission…
-
Restriction on Impairment reversal amount
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): OCBC Description (Required): As per current design while reversing the Impairment, system is allowing to reverse the amount more than what was charged to P/L earlier. As per statutory…
-
Need Item Revision Column in Costed BOM OTBI Report
Hi Team, We have Costed BOM Report with (Costing - Cost Rollup Details Real Time) subject area. We need Item revision column in this report. And we have created cross subject areas with (Costing - Cost Rollup Details Real Time) and (Product Management - Item Revisions Real Time) but Revison column is showing blank. Is…
-
Sensitive data audit report does not show document name also does not record payslip page's view
Sensitive data audit report, currently shows document ID of documents viewed under DOR ( Document of Record ). It does not show the document name. Same is correct for the Analytics delivered for this report ( we are able to add the document name from DOR subject area but it does not return any valid results ) Also the…
-
Make unarchiving operations visible in audit reports to ensure compliance
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Cohu Inc. Description (Required): Audit reports on OBIEE BIPublisher catalog reveal creation, modification, and deletion of objects along with calling. What is missing, though, is recording of…
-
Lease Approval - Rejected Lease notification should provide more meaningful massage.
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): OCBC Description (Required): Lease Approval - Rejected Lease notification should provide more meaningful massage. Use Case and Business Need (Required): Approval notifications related to…
-
Redirect Home page link in the Header to a Dashboard page
Ability to click on Home button and go to a Dashboard page instead of the default bieeHome page. This was possible in 11g and 12c by modifying the header.js file in the analytics.ear and deploy it. But in OAS we are not going to modify the analytics.ear file and redeploy it. Another possible solution is to allow creation…
-
We have customize the BI report notification in test, dev and PROD .
Its working as expected only in Test , but in Dev and Prod it's not working as expected . Referred the below document. Adding some steps which we followed. Fusion HCM BIP Notifications: Best Practice to Customize the Report Template, Data Model or Sub-Template (Doc ID 2647434.1) Then navigate to Manage Administrator…
-
Refinement of notification text once the Lease (Lease Accounting module) is approved by Approver
Once the Lease is approved by approver in Lease accounting module , notification text is reflecting as "“Lease xxx has been submitted for your approval” instead of "“Lease xxx has been approved”. Can we expect notification text to be updated as "“Lease xxx has been approved” in new release.
-
Report to identify terminated employees in Oracle workflow
Hi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle workflow. Suppose employee A is present in PO,AP,GL etc approval and the he leaves organization. So we want to run a report which gives list of all ex-employees and the workflows in which they are present. 2.) Oracle Report that…
-
Create a Recommended Assignments subject area (was add to existing subject area)
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): JP Morgan Chase Description (Required): Given that the process to create recommendations has shifted since 2022, I am updating this request to reflect the idea of creating a new subject area…
-
OTBI Audit Reports
Description We need reports for auditing modifications to OTBI reporting components. Only mod dates show, so we have no visibility into which user made the change or what was changed. There is finally a set of reports for BI Publisher, but we need this for OTBI as well. If all the same auditing reports could be available…
-
Restrict the display of information from a custom report to specific users through data access.
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Aseguradora Aserta, S.A. de C.V. Grupo Financiero Aserta Description (Required): Restrict access to specific information through a custom role or through data access to users. Use Case and…
-
Customer Audit Report - Extension Request
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Johnson Controls Inc Description (Required): We have an Audit Requirement specific to Customer Master Data Changes wherein Compliance team would like to trace list of all changes done at the…
-
Print Label from BI Report to Zebra Printer
We have configured Zebra printer for label printing in BI Administration. When tried to print the report which is in XML format generated as TXT file. It is failing with delivery error. Are there any documents on Printing Labels from BI Report.
-
As of Period for Project Cross Subject Area
It would be helpful if we can add a filter appropriately for as of period. We can add multiple periods, filter on accounting date, but not the accounting period. I want to add a filter as of accounting period and list project number, cost and revenue measures. I would like this to perform well too, as adding date filters…
-
SLA to GL reconciliation report for Revenue Management
Hi, We have business requirement to reconcile data from SLA to GL for Revenue Management to make sure all are posted to GL. Could you please help to create report to reconcile data from SLA to General Ledger. Akash Raj
