Reporting and Analytics
Discussion List
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 26 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM -
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 9 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Table to get "Reference Type" in depletion layer?Summary: I am looking for a table that contains the "Reference Type" field in the depletion layer as in the screenshot below. thanks in advance! Content (please ensure y… -
Is it possible to see when a text field has been updated in Reports and analyticsThe usecase is to be able to make a filter on a text field where only items that have updated that specific field for the last 4 weeks are shown in the results.
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.2K views 6 comments 4 points Most recent by Gayathri Senthil Reporting and Analytics for SCM -
Will the Redwood upgrade will impact our existing Analysis reports and/or DashboardsSummary: Will the Redwood upgrade will impact our existing Analysis reports and/or Dashboards that use Analysis reports? We are trying to schedule and prioritize project…Bill Stearns at Essex Grove Consulting 33 views 4 comments 0 points Most recent by Bill Stearns at Essex Grove Consulting Reporting and Analytics for SCM
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 198 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
Custom job set not requiring custom privilegeSummary: user guide is very clear on this topic: but reality is different. Created a custom job set for cycle count alike the seeded job set but without the report. It w…Erik Jurjens-Oracle 1 view 0 comments 0 points Started by Erik Jurjens-Oracle Reporting and Analytics for SCM
-
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…
-
Adding Pending Approver to a ReportWe need to add the next approver to a Report. We are unable derive the next approver (to whom the requisition is not yet assigned for approval) for requisitions which ar…
-
Issue creating RTF Template using Non-standard SQL Data ModelSummary: Issue creating RTF Template using Non-standard SQL Data Model Content (please ensure you mask any confidential information): I have created a new Data Model in …
-
BICC Extracts: how can i find out what attributes are used for each of the fields in the data storesI am looking to find out what attributes are used for each of the fields extracted within our BICC Extract data. Our data reporting teams need to understand if a field i…Tracy Collins 1 view 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting and Analytics for SCM
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 102 views 3 comments 0 points Most recent by User_2F7TP Reporting and Analytics for SCM
-
Inventory Transaction Detail BIP Report-30 Columns-Item with Serial Control Enabled-65K LimitationSummary: Hi Everyone, We have a requirement from business to build BIP report for the Inventory transactions which they track manually at present. There are around 30 co…
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas… -
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…
-
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …Khalid Aldosari-Oracle 92 views 2 comments 0 points Most recent by Walter Spinelli Reporting and Analytics for SCM
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …
-
How to create depended LOV parameters (based on value set) in ESS jobHow to create depended LOV parameters in ESS job. The LOV parameters will be based on value sets.KabirB 81 views 6 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for ERP
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Contract - option to download supplier or procurement contract details and attachmentSummary: when we go to Contracts Manage contract - there is only option to query based on name or contract number. 1)How to export all the contracts in on go instead of …
-
What is the OTBI item for "Organization" (under PO schedules)?We are trying to create a report that pulls the Ship-to location, PO number, and receiving organization (see above) to see where we have mismatching values (Ex: NATHW sh…
-
Custom Subject Area Primary Objects for ERP and SCM CloudSummary: What are the Primary Objects that we are supposed to have access to? I am looking at creating a Custom SA for Sourcing Responses. I only see the following: Cont… -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM
-
Update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table after Ship confirmSummary: Can we update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table in Fusion after Ship Confirm business event? Content (please ensure you mask any con…Khalida Raffath 11 views 1 comment 0 points Most recent by Khalida Raffath Reporting and Analytics for SCM
-
Print Receivables transaction ReportHi team, We have requirement where for Germany we have to print AR invoice report in german and english language both. But when we run the schedule process 'Print Receiv…vikram khengare 12 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
SQL query time exceeds the limit (1800 sec).Summary: I am building a report - Accounts Payable Trial Balance. While I am scheduling the BIP report, I am getting the error - SQL query time exceeds the limit (1800 s…Ritu123 78 views 1 comment 1 point Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM