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
-
Redwood: Purchase Document E-mail ReportSummary: Redwood: Purchase Document E-mail Report Content (please ensure you mask any confidential information): Hi Team, We are getting new feature in 25D :Redwood: Use… -
BICC Not showing DFF FieldsSummary: Hello Team, BICC extracts are not showing the Shipment header and line DFFs which are configured in the system for the following seeded PVOs: - FscmTopModelAM.S…
-
how to extract One Time location entered in Ship to location on Purchase Orders using BIP reportWe want One Time location entered in Ship to location on Purchase Orders. Where it is stored? How we can extract using sql query.
-
In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What …
-
FDI SCM analytics workbook newschedule option not displayingSummary: The user has Service Administrator access and Read/Write permissions on the workbook. However, while attempting to create a schedule for the workbook, the “New … -
Configuration and Roles required for Evaluate Procurement PerformanceSummary: Hi All, We are looking for details on Configuration and Roles required for 1) Evaluate Procurement Performance, 2) Evaluate Supplier Performance and perform 3) … -
Sales order report customization and availability under Action MenuSummary: How to Edit the sales order Report to include Eff Details and utilize it under Action Menu dropdown on Sales order UI? Content (please ensure you mask any confi…
-
Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …
-
How doo_headers_all and por_requisition tables are related .Summary: We need to write query to connect doo_headers and requisition to get po_number and receipt . or it can be connect from PO or RCV tables? how can i form query wi…
-
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different … -
Subject Area 'Sourcing - Supplier Negotiations Real Time' Supplier Name absentSummary: A supplier negotiation has 5 invited suppliers listed under the section Suppliers. The indicator 'Restrict to invited suppliers flag' is YES. We would like to p…
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…
-
we have requirement item import map load in UCM server and integration team take the file and loadSummary: we have requirement item import map load in UCM server and integration team take the file and load in oracle cloud Content (please ensure you mask any confident…
-
HOW TO CALCULATE GRAND TOTAL OF LINE VALUES IN MY RECEIVING PAGE ON ORACLE FUSIONSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da… -
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…
-
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…
-
Has anyone been able to edit seeded data model that uses XML file as a dataset instead of sql query?Summary: I need to edit the Electronic Record for Ship Confirm Report to include custom data. The data model for this report uses an XML file as a dataset instead of an …
-
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25D
-
The .xls output format is missing on Scheduled process Advanced Options tabHi Community, When we try to run a BIP report from Scheduled Process and use the Advanced Options tab to select Output format, the .xls format is missing and only mhtml …
-
ESS Job for BIP Report – Error During Scheduled Process ExecutionSummary: Hi Team, We have created an ESS job for the BIP report and assigned the appropriate ESS privilege to the custom role. However, when a user with this role attemp…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …
-
what is the equivalent table in Oracle fusion for wf_notification table in EBSSummary: We are looking to build a report to get approval details of delegated approvals . E.g: Workflow type, original approver , approved by , Approval Date Etc. Conte…
-
How can I determine which weekday corresponds to DAY_START_NUM and DAY_STOP_NUM(ZMM_SR_PATTERN_DTLS)Hi everyone, I have a question regarding the ZMM_SR_PATTERN_DTLS table, specifically the DAY_START_NUM and DAY_STOP_NUM columns. In my case, I have: DAY_START_NUM = 1 DA… -
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …
-
Where is Business Classifications information are stored?Summary: We want to build a custom report which shows the Supplier Registration requests where we need to display the Classifications along with the attachment names. We…
-
Clarification on PIM business Events in NIR and Change ordersSummary: Clarification on PIM business Events in NIR and Change orders Content (please ensure you mask any confidential information): We are developing the Integration w…
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…
-
How to make the report link variableSummary: Sandbox-How to make the report link variable Content (please ensure you mask any confidential information): Hi Team We have customized a report and use sandbox … -
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query…