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
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was… -
Data is getting filtered when Trading Partner Details column is selectedSummary Data is getting filtered when Trading Partner Details column is selectedContent Hi, We are developing an OTBI Report with Subject Area as "Product Management - T…
-
SEEDED REPORT FOR ITEMSContent WHEN WE DEFINE ITEM WE NEED A SEEDED ORACLE REPORT FOR ITEM ?
-
Custom PO Template for Approved Purchase OrderContent I FOLLOWED DOCUMENT Custom PO Template Is Picked Correctly for Draft Purchase Order but Not for Approved Purchase Order (Doc ID 2072623.1) WORK WELL FOR Draft Pu…
-
seeded report transfer order , shipment and receiptContent i want to create a report stock transfer from inventory to another inventory. so i am searching a seed report purchase requistion --> Transfer --> shipping --> r…
-
Invoice register account from PO not showing expense accountSummary When extracting the invoice register, the invoices that had a PO don't show the correct accountContent When i try to pull out a report to see our expense by supp… -
sql to get image for item and how to appear image on rtf template ?Content - i create a data model and i want to get image for each item in report , what tables to get image for item ? - after get image in data model, how i put image on…
-
PO line Level total is not showing in subject areaSummary PO Line Total is not available in Procure to pay - Purchasing Subject areaContent HI, PO Line Total is not available in Procure to pay - Purchasing Subject area,…Farooq Syed, CPA, PMP, CISA, TOGAF 32 views 1 comment 2 points Most recent by Gabriel Grigorie-Oracle -
How Charge type (Freight, Duty...) is calculated on a POSummary How Charge type (Freight, Duty...) is calculated on a PO in Landed Cost ManagementContent I need to show per unit cost of Charge (Freight, Duty, Material, Miscel…
-
Plan to Produce Infolets are not appearing on Home PageSummary Plan to Produce Infolets are not appearing on Home PageContent Hi All, We are not able to see any infolets on Plan to Produce Infolets section. Please let us kno… -
Item Where Used Real Time - Fetching No DataSummary Unable to build analysis for where used items in structuresContent Hello - We have a need to identify component items in structures before inactivating them. Is … -
Possibility to retrieve URL of an attachment stored in SaaS through BI PublisherSummary URL of attachments stored in UCMContent Hi, I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM. I have checked in t…
-
Enabling the User to Edit Reports Created by other USerSummary Enabling the User to Edit Reports Created by other USerContent Hello , I need to enable a user to edit reports for SCM created by other user i created a Custom R… -
SCM Report queriesSummary I would like to know where i can find a repository of report queries for this subject area.Content I would like to know where i can find this information for Pro…User_2025-01-25-06-03-46-894 97 views 4 comments 3 points Most recent by User_2025-01-25-06-03-46-894
-
Inventory Transaction and Costing - Cross Subject AreasSummary I need an OTBI Analysis that includes Inventory Transaction Real Time and Costing Item Cost Real TimeContent Hi, I created a cross subject area Analysis to displ…User_2025-01-28-18-00-07-296 116 views 4 comments 0 points Most recent by User_2025-01-28-18-00-07-296
-
Assign Printer to a UserSummary Assign Printer to a UserContent Hi, Can we assign a printer at user level without specifying any document. So whatever that user prints gets printed to a specifi…
-
Defaulting LOV parameter value from sysdateSummary Defaulting LOV parameter value from sysdateContent Hi All, How to default Menu Parameter, from sysdate. Say, we need to get Month and year in the format of 'Mon-…
-
Procurement Agent ReportSummary Needing Procurement Agent Report of Agents Allowed Actions and AccessContent I am looking for a report or way to find out not just which users are setup as a pro… -
Need a query to fetch all the report names and its locationSummary Need a query to fetch all the report names and its locationContent Hello All, We have a requirement like what are the reports are avilable in the system and what… -
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…
-
Net Available Item QuantitySummary Subject area for Reserved Quantity and Net Available QuantityContent Hello Team, We have to update our analysis report, please suggest which subject area in Inve…
-
Inventory OnHand Balance ReportSummary Inventory OnHand Balance Report -
Purchase Order Pending for RecevingSummary Need report for Purchase orders pending for recevingContent All PO's which delivery dates are passed, we need the report to see PO pending for delivery date. -
How to override NULL valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …User_2025-02-06-00-08-33-553 43 views 6 comments 0 points Most recent by User_2025-02-06-00-08-33-553
-
Monthly POs Received ReportSummary Monthly PO Received ReportContent Is there any POs' received report for Inventory & Expense (items & Services ) .
-
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in…
-
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 -
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 55 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553
-
SCM Item PVOsSummary SCM Item PVOs Definition or explanationContent Hi, I am using BICC to extract data from ERP Cloud for downstream integration with a client's data lake. We are in…
-
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…