Reporting and Analytics
Discussion List
-
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 4 views 0 comments 0 points Started by Martin Hutchison Reporting and Analytics for SCM -
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 …
-
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. 21 views 1 comment 0 points Most recent by SRGogula-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 23 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 Pandey 31 views 2 comments 0 points Most recent by Anurag 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 89 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 27 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 12 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 24 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 6 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 11 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 158 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig 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 12 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle 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 22 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 53 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 2 views 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 2 views 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 12 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 12 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 32 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI…Rajat Pandey 22 views 6 comments 0 points Most recent by Rajat Pandey Reporting and Analytics for SCM -
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 4 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 31 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…Naga Peddiraju Chennu 12 views 7 comments 0 points Most recent by Prassanna_Srinivasan Reporting and Analytics for SCM