Get Started with Redwood for Oracle Cloud SCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
How to get FND_FLEX_VALUES and FND_FLEX_VALUES_VL via BICCSummary: FND_FLEX_VALUES and FND_FLEX_VALUES_VL not available in BICC Content (please ensure you mask any confidential information): Hello…we are in BICC version Oracle … -
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…
-
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized … -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t… -
I need the table where I can retrieve the lot number for inspection (inventory type)Summary: Select statement to retrieve the lot number of the inspection that has been created with Inventory type Content (please ensure you mask any confidential informa…
-
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…
-
Is there any standard Oracle reports for reconciling Receiving Inspection account?Summary: Content (required): We're looking to see if there's any standard Oracle reports to help reconcile receiving inspection account and review whether there are any …
-
Supplier Qualification - Qualifications and Assessments Real TimeSummary: We are trying to create a report using "OTBI - Supplier Qualification - Qualifications and Assessments Real Time Subject Area" please find the report criteria a…
-
Subject area which will give me the conversion factor for a Purchasing UOM to a Stock UOMSummary: Subject area which will give me the conversion factor for a Purchasing UOM to a Stock UOM Content (please ensure you mask any confidential information): I need …
-
Can I create a dashboard using multiple Oracle BI Publisher reports ?Can I create a dashboard in Oracle BI Publisher that combines data and visualizations from multiple BI Publisher reports? Specifically, I'd like to include graphs and ba…
-
I am looking to create an OTBI dashboard for RMAsSummary: I am looking to create an OTBI dashboard for RMAs. Want to display error messages and create alerts/agents. Content (please ensure you mask any confidential inf…
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeSummary: Hi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area … -
Query/Table to find the below highlighted fields for Configure Negotiation Award Outbound Service?Can you help me in finding the above highlighted fields? -
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…
-
Line Number and RA Document Line Number has different values in rcv_shipment_linesSummary: Line Number and RA Document Line Number has different values in rcv_shipment_lines Content (please ensure you mask any confidential information): Hello, We are …
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star… -
Missing the Attribute Column in FLEX_BI_ItemBaseDFF_VISummary: Content (please ensure you mask any confidential information): using (FscmTopModelAM.EgpItemsPublicModelAM.ItemBaseDFFBIAM.FLEX_BI_ItemBaseDFF_VI) I'm attemptin…
-
Report to show PO with its contract and RFQ detailsHello Team, I need to create a report which gives PO details and the contract / RFQ based on which those are created. I have found the below tables, please confirm if th…
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
Bare minimum roles required to view infotile dashboards for Procurement?what are the bare minimum roles required for the user to access an infotile dashboard in "Procurement Area" (Purchase Requisitions and Purchase Orders) I created a intof…
-
how to fetch historic on hand quantity correctly using new views provided?Summary: Historic On hands quantity Content (please ensure you mask any confidential information): Currently given views are not supporting historic data. Decommissioned…
-
How do people manage REACH reporting outside Oracle Cloud Fusion ERP?Summary: We are required to provide Regulatory reporting requirements such as REACH and Plastic Tax as a company. Oracle Cloud Fusion ERP has no standard solution, so we…
-
Need PVO for description column corresponding to avespdescid ID column - EFFBPricing__AttributesSummary: Need PVO details for description column corresponding to avespdescid ID column Content (please ensure you mask any confidential information): Hi Team, We need t… -
Dashboard access and rolesSummary: To start with, big thanks to all who reply. So went live with Fusion on January 2024. I have put together a dashboard using "Receiving - Purchase Receipts Real …
-
Sourcing Negotiation PDF - Tag which contains value for Allow Alternate Lines FieldSummary: Please help in Identifying if any tag pertains to "Allow Alternate Lines" field in Sourcing Negotiation PDF report. We have checked the below note but not able … -
Requirement: Receipt report that gives the end user the ability to download a PO or PR attachmentSummary: Customers have provided us with the requirement to develop a receipt BI or OTBI report that gives the end user the ability to download a PO or PR attachment if …Shashikanth Kumar P-Oracle 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle
-
Custom Report Printing PO Terms and ConditionsSummary: How to Print PO Terms and Conditions? Content (required): Is there a way to add the Terms and Conditions attached to PO to a custom report. I've checked the sta…
-
which oracle table contain po line item warning flagSummary: Hello, I am trying to build BI Publisher report for frozen POs. I need to pull PO lines that have invoices on hold. Currently we can see for such lines . yellow…
-
Average Unit & FIFO Unit Costs for the Physical Inventory Adjustment ReportHello, I am hoping that you Inventory Cloud gurus can help me. I have created a custom report that shows the Physical Inventory Adjustments. Now I have to add the follow… -
Can I compare archived versions of supply plan in OTBI?Summary: I am trying to build analytics/ reports in OTBI, where I can compare different versions of the same supply plan. Content (required): does that work similar to A…