SCM
Discussion List
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 236 views 2 comments 0 points Most recent by Ripendra Kumar-Oracle Reporting and Analytics for SCM -
Need query to pull item cost details for specific transactionsSummary: Content (required): Business requirement is to pull item cost details for specific transactions from the refurbished SKUs Version (include the version you are u…kalyan gade 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3…
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 98 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 82 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor…Lucky Sharma 41 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 23 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Equivalent Oracle Cloud table/view for the EBS 11i entity MTL_INTERCOMPANY_PARAMETERS_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity MTL_INTERCOMPANY_PARAMETERS_V? Content (required): Version (in…Nagendrababu Kanuru 51 views 2 comments 0 points Most recent by Nagendrababu Kanuru Reporting and Analytics for SCM
-
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 41 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 621 views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM
-
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…Neela.Voduguru 31 views 1 comment 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Need Query to pull the item costs for the refurbished SKUsSummary: Have a requirement to find the item costs for refubrished SKUs Content (required): Query to pull the item costs for the refurbished SKUs Version (include the ve…
-
BI publisher for Demand Plan custom measures.Summary: Hi all, please I would thank for any help with the following. We need the query below this Demand Plan screens. Example 1. Example 2. We have noticed some table…Juan Jesus 63 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Item Pricing informationSummary Need to extract item pricing information by locationContent Hi, We are looking for BIP report/OTBI subject areas that can extract Item pricing information. Is th…Tiger Liu-55147 49 views 2 comments 1 point Most recent by Waleed Fetoh Reporting and Analytics for SCM
-
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c…Sai Revanth-Oracle 43 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…Hendra_innopia 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
Error while loading Sales order through FBDISummary: Getting error while loading sales order. This error occurs in source order 1103-F65660TEST, on source order line 1, source item name 846581, source item 300,000…
-
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…Sharmava 12 views 1 comment 0 points Most recent by Aravindan Sankaramurthy -Oracle Reporting and Analytics for SCM
-
Documentation on Complete list of available pre-built KPI/metrics in Fusion SCM Analytics (FAW)?Summary: Can you please let us know the link where we we can get to know the complete list of metrics/KPI available in SCM Analytics for OM, Procurement and Inventory? C…SIVA.G 281 views 4 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
What DFF's or Flex fields are we able to bring into to OTBISummary: Looking for documentation about which dimension in OTBI we can extend with flex fields. We found in finance module that not all flex fields were eligible to com…amy hardtke 41 views 3 comments 0 points Most recent by Abhijit Joshi -Oracle Reporting and Analytics for SCM -
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…Yogesh Nemchand 37 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…Amit Sutar 42 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
OTBI Report view as Transpose RowsSummary: Content (required): Hello Friends, How I can get a Transposed view display for OTBI report (based on subject Area)? For Example: Currently I am getting output a…