Reporting and Analytics
Discussion List
-
Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobsSummary: Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobs Content (please ensure you mask any confidential information)… -
Access the standard BIP report extracts via APISummary: Hi Team, We have a requirement to fetch and place the standard BIP extracts from UCM to some file server. example, once the ap invoices import process is comple…Dipendra 73 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
how to improve the OTBI analysis export record limit?Summary: Hi Guru, we created an OTBI analysis using the standard data model, but looks like it can only support to export 250k records, is there any way to improve that …JasonZzl 41 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 24 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …KTbsa1234567 53 views 2 comments 0 points Most recent by KTbsa1234567 Reporting and Analytics for ERP
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 43 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s…Sai Sreeram Gundepudi 26 views 0 comments 0 points Started by Sai Sreeram Gundepudi Reporting and Analytics for ERP -
Where is the Organization Name on the SCM BICC Extracts?Summary: In the BICC Extracts for Sales Orders Transfer Orders Purchase Orders Shipments On Hand Installed Base We need to Find the Organisation Name but can only find a…Martin Hutchison 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Locator Name in Receiving - Purchase Receipts Real Time Subject AreaSummary: We have an OTBI report built using the subject area "Receiving - Purchase Receipts Real Time" and we have almost all the required columns except for the Locator…Rahul_M8SG8 21 views 4 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
What all standard reports are available in oracle fusion for Procurement and Supply Chain ManagementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Supplier Owned Consigned Items valuationSummary: Does Period Inventory Valluation Report consider the inventory value for consigned items those are owned by supplier? Content (please ensure you mask any confid…Anurag Kumar Pandey 31 views 2 comments 0 points Most recent by Anurag Kumar Pandey Reporting and Analytics for SCM
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …Yash Jain 116 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
System Performance Health CheckSummary: We are seeking a solution that will help us monitor the health of our ESS Jobs. Something that would alert us of long run times, threads getting hung up etc. We…Schneider.Mark 21 views 3 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
Consigned Inventory ValuationSummary Consigned Inventory ValuationContent Our healthcare organization is new to Oracle Cloud Fusion SCM. I ran inventory valuation reports (from scheduled processes) …Pattianne Belitz-Children's Hosp Omaha 60 views 3 comments 0 points Most recent by Pattianne Belitz-Children's Hosp Omaha Reporting and Analytics for SCM -
SCM seeded report including bin location and on order countI'm needing a SCM report that has the bin location, and also the on order count. Does anyone know of a report that includes these two fields or know of what table I can …JWilliamson 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Item revision for onhand analysis reportSummary: Item revision for onhand analysis report. Content (please ensure you mask any confidential information): Created an analysis report using Inventory - Inventory …Mukesh_Kr 21 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input…
-
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 5 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 12 views 3 comments 0 points Most recent by MANALI BISWAS-Oracle Reporting and Analytics for SCM
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…Mhees Mhees 157 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM
-
How to print label to printer using rest api when running the BIP report?Summary: How to print label to printer using rest api, currently I'm using the erp integration endpoint from the fusion rest api guide to generate the label in XML. Howe…mayank_tripathi 21 views 1 comment 0 points Most recent by Saranya Sounderrajan Warehouse Management
-
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 120 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
OTBI Report - Hyperlink Path Not Found ErrorI'm getting a "path not found" error when clicking a hyperlink on a graph in my OTBI report. The hyperlink is supposed to open a customer profile report when I click on …Omran Zeaiter 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 1 view 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Need to create a Job set which call Min Max Job 600 times with different parametersSummary: We need to create a Job set which will trigger the Min-Max planning report 500 times for different Inventory Organizations. We are able to create the job set th…
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want…Abdur Rehman 11 views 2 comments 2 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Is there a way to publish data from a report to an OIC service?Summary: Is there a way to publish data from a report to an OIC service? Content (please ensure you mask any confidential information): Is this architecture achievable? …Andres De la Ossa-Oracle 11 views 0 comments 0 points Started by Andres De la Ossa-Oracle Integration -
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 31 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM