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
-
Receiving - Purchase Receipts Real Time - Returns no results when adding Amount columnsSummary: In OTBI, when adding in any purchase receipt line columns returns No Results. This has only happened after 24D, any suggestions? We have the correct Warehouse M… -
P2P Dashboard – Received Quantity Formatting IssueSummary: Received Quantity displays as currency for specific users in the P2P PO Details Dashboard. Content (please ensure you mask any confidential information): Receiv… -
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A… -
How to identify the Fusion Cloud user, how he/she has login through (REST API/OIC/URL)Summary: We used FND_Session table to identify the user, who has been logged in to cloud. but this does not tell about, how the user has been logged in. Manually( URL lo… -
Database table containing the list of custom table created in demand planningSummary: We run the Publish Data ess job via OIC integration to export the data from a custom table in Demand Planning. This ess job require to pass the table ID as para… -
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded… -
OTM/GTM - what is the size limitation for oracle BI Publisher rtf template?Summary: OTM/GTM - what is the size limitation for oracle BI Publisher rtf template? Content (please ensure you mask any confidential information): OTM/GTM Product is cu…
-
I'm struggling trying to create a BIP supply chain item master data modelAttached is a layout of a supply chain extract that I'm trying to create. The highlighted info is the data I'm still missing. Also, attached is the SQL that I have so fa… -
ARCredit Memo Comments: Attribute CreditMemoComments in view object CreditMemoHeader1 cannot be set.Summary: I'm trying to update the AR Credit Memo Comment field using REST API. It is throwing, Credit Memo Comments: Attribute CreditMemoComments in view object CreditMe… -
Oracle Fusion’s New Data Extraction Tool for SCMHi - I wanted to try the new Oracle Fusion’s New Data Extraction Tool for SCM . After config I logged in to fusion using the user which has the correct roles as per the … -
OTBI Context Sensitive DFFSummary: How to avoid context sensitive DFF show multiple times Content (please ensure you mask any confidential information): We have setup several context sensitive DF… -
Custom BIP Report Issue Resolved by Custom Report Template Name ChangeSummary: During UAT in , the customized **Purchase Document E-Mail Report** was not working correctly. (PO PDF notification Email's body did not come out) Resolution: Ou… -
While trying to create KPI for redwood landing pagesSummary: While trying to create KPI for redwood landing pages Content (please ensure you mask any confidential information): I was trying to create KPI's for landing pag… -
No analysis available while creating a visualization metricI am trying to configure a visualization in the Inventory Management Landing page using an analysis, however when trying to search for the created analysis in the Visual… -
How to identify and track any changes made to few specific Item Standard/UDA attributes Only ?Summary Of the problem scenario: As part of a data outbound from oracle cloud to boundary systems, we have to send item info whenever there is some update made to any sp… -
For an ESS Job Set can we get consolidated Output through BrustingFor an ESS Job set we have 4-5 child programs , each producing one pdf output, is there a way to consolidate these outputs in 1 zip folder and send to client, instaed of… -
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 … -
Charge Wise Total Report Producing Incorrect DataI am investigating a custom Oracle Fusion SCM query that calculates landed cost charges by charge name. The query returns correct charge totals for most receipts, but fo… -
How to join Procurement - Procure To Pay Real Time and Enterprise Contracts - Contracts Real TimeHi Team, I am currently working on joining the below two OTBI subject areas, but I am unable to establish a proper join between them: Procurement - Procure To Pay Real T… -
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
Customising Datamodel of (seeded) Sales Order ReportSummary: How can we customise the Datamodel of the (seeded) Sales Order Report? Content (please ensure you mask any confidential information): The Sales Order Report is … -
Best way to pass multi-select parameter list SQLSummary: I am working in an Oracle BI Publisher environment and ran into challenges converting a single-value parameter into a multi-select parameter, specifically for s… -
SQL Query to Retrieve Available to Transact QuantitySummary: SQL Query to Retrieve Available to Transact Quantity Content (please ensure you mask any confidential information): Hello Team, I am working on developing a SQL… -
How to retrieve APPLLOG_DIR/xxxxx.log log file using BIPSummary: We enable AFLOG and generate a log file in directory APPLLOG_DIR. Is there a way to retrieve this log file in BIP? I google and it say that we can use ULT-FILE … -
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl… -
Sales order report customization and how to get XML for current Sales orderSummary: I have to customize Sales order report of the below path. But this Data Model SQL query is not exposed. Oracle has provided the sample xml in datamodel properti… -
Passing Custom Parameters (BIP) in Report Task Type in Guided Journeys (Redwood - shipment page)BI Report on Shipment Page: We need the Guided Journey parameters available on the "Shipment" page to pass the Shipment as an input parameter required by the BI reports. -
Min-Max Planning Details Across All Orgs ReportSummary: Needs a query to fetch the Min/Max details for all the items across all the inventory organization in the application. Content (please ensure you mask any confi… -
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled … -
Exception Report for Inventory Pending TransactionsSummary: We need a query to get the details of the Inventory Pending Transactions. Content (please ensure you mask any confidential information): We are seeking a PL/SQL…