Category 174-2
Discussion List
-
How to filter out duplicate rows with same values in BI report.Summary: I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_…Rishabh702 15 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Query to extract Change order details of PO'sSummary: Need to extract all Change orders associated to a PO in Oracle Fusion Procurement Content (please ensure you mask any confidential information): Version (includ…KalyanC 1.4K views 1 comment 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
How to calculate Location capacity in Web reportHi, We are looking for best approach to get Available location capacity in Web report. For example:- If location 30% space occupied with inventory, than we will show the…Vijay11891 32 views 1 comment 0 points Most recent by Dhavaleshchandra Sukesh-Support-Oracle Warehouse Management
-
PROCUREMENT CONTRACT REPORT CREATIONSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…kalyan gade 53 views 1 comment 0 points Most recent by Geno Hawkins- Support -Oracle Warehouse Management
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is it possible to access ATP DB table in AnalyticsSummary: Could access ATP DB table in Report Analytics catalog to build SQL Query data model Content (please ensure you mask any confidential information): Version (incl…
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 129 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How do I find the Submit Request Window to run a Buyer ListingI need to submit a Buyer Listing but I do not know how to get to the Submit Request Window?John Montgomery 1 view 2 comments 0 points Most recent by John Montgomery Reporting and Analytics for SCM
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…G.Engelmann 151 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query/Table to find the below highlighted fields Configure Supplier Outbound Synchronization ServiceCould you please in finding the above columns?Varalakshmi 11 views 1 comment 0 points Most recent by Hong Gao-Oracle Reporting and Analytics for SCM -
On Update 23.R4 SQM is noted as future roadmap itemSummary: On Update 23.R4 SQM is noted as future roadmap item. Is timeline available for this functionality? Content (please ensure you mask any confidential information)…AVorster-Oracle 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Query to get the Serial Number of Shipment number for PO in CloudNeed to find the serial number used in shipment for purchase order when we pass shipment number. select rsl.line_num, rsh.shipment_num, poh.segment1 as po_number, pol.it…User_K040A 680 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…Sukanya Mukherjee 11 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 11 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…Holly Wells 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
where can i find posting_type columns in scm tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…B V LAVAN Salivahan 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Tables related to Demand ManagementSummary: Hi, I need to extract all tables with data related to SCM Fusion Demand Management, but when I look into either data lineage or fusion PVO list I do not see any…Viswanath-Oracle 96 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Need to see BPM Approval Flow in OTBISummary: I am trying to create an OTBI report and would like to see the BPM approval flow from OTBI report. When trying to figure out who approved the requisition, since…mohamed_shahud 34 views 3 comments 0 points Most recent by Logan - HCG Reporting and Analytics for SCM
-
How to default an Inspection plan when entering inspection details ?Summary: How to default an Inspection plan when entering inspection details Content (please ensure you mask any confidential information): How to default an Inspection p…
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 51 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 319 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to restrict the Subject areas against specific Module with a roleSummary: Hi Team, We have a requirement to restrict the subject areas against each area, like inventory, procurement, and order management, using a specific role, as the…Support 21 views 4 comments 0 points Most recent by Vijay Bhaskar Koti Reporting and Analytics for SCM
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
How can we generate an OTBI report with receipt Number with received Quantity/AmountSummary: We have a requirement to create an OTBI report with Receipt Number and the corresponding Received Quantity or Amount. We tried using Purchasing Real Time data b…Asutosh Mishra 182 views 1 comment 1 point Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to add attachment column in bank account creation page of register supplier pageSummary: How to add attachment column in bank account creation page of register supplier page Content (please ensure you mask any confidential information): How to add a…Venkatesan 32 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Navigate to Installed base Assets page using action links in OTBISummary: Issue with Navigating to specific Asset summary page from OTBI analysis for IB assets Content (required): I am trying to click to view, and navigate to IB asset…Suresh Kampati 116 views 4 comments 0 points Most recent by Suresh Kampati Reporting and Analytics for SCM -
Can we create multi language records in AP_TERMS_TLSummary: Can we create multi language (i.e. English, French, German etc.) records in AP_TERMS_TL Content (please ensure you mask any confidential information): The table…YaronF 12 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM