Get Started with Redwood for Oracle Cloud SCM Begin Now
Reporting and Analytics for SCM
Discussion List
-
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…
-
Supplier Address Level Tax Classification CodeSummary: We are trying to determine the Tax classification code field at Supplier Address level in OTBI analysis Content (please ensure you mask any confidential informa… -
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 33 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…
-
How to build custom report for LCM details with receipt accounting details to recon with GLHow to build custom report for LCM details with receipt accounting details which will be reconciling with GL. We are looking to build the report which will give us Lande…
-
Supplier Recon reportSummary: We are importing the suppliers,address,site details using FBDI.Is there a specific report that we can access or generate to reconcile the imported data with the…
-
The custom report is providing blank data to the user ( Receipt and cost accounting details report)Summary: Please be informed that we have created a custom report i.e. " Receipt and cost accounting details report.", but the user is not getting any data in the report.…
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 24C…
-
movement request auto approval table in oracle fusionSummary: movement request auto approval table in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using,…
-
SQL query for Manage negotiation Template for Sourcing moduleSummary: Hi Team, We need a table where Manage negotiation Template information stores Content (please ensure you mask any confidential information): Version (include th…
-
How to filter out duplicate value for multi-rows attributes in OTBI analysisSummary: The OTBI analysis shows duplicate value for multi-rows attributes. I need a way to filter them out in analysis. Content (required): I have two multi-rows attrib…
-
Is there a way we can get the Approved by person in Definition step of NIR using OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…
-
Do we have Out of the box OTBI report specifically for Production Scheduling?Summary: We need details on the standard Out of the box reports for Production scheduling, any lead would be highly helpful. Content (please ensure you mask any confiden… -
How to setup FTP server on PDH and send files from PDH to PDH FTP serverSummary: We have a requirement of sending Item and Cost master information from PDH to CPQ via SOA middleware. We need to enable and setup FTP server on PDH so that SOA … -
Provision for electing report parameters in OTBI Agents while subscriptionSummary: Content (please ensure you mask any confidential information): Hi Oracle, We have received a requirement from client to create agent having report with prompts.…
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …