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
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
How to identify Region/Location names on Transit time tables?Summary: On the transit time tables (WSH_TRANSIT_TIMES/WSH_TRANSIT_TIME_VALUES), we have the From & To Location and Region ID's. So, which tables can be used to map thes…
-
Is there a method to import RFQ data from legacy system to Oracle Cloud.Summary: When checked for FBDI option, the template to import only lines is available but not the header or RFQ as a whole. The requirement is to migrate Inprogress RFQs…
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…
-
Unable to Access OTM BISummary: I have configured my user and given the access in IDCS - Service Administrator and I`m able to access the BIP in Test environment but when I try to access BIP i…
-
What data set in OTBI will return the name of the person who completed a purchasing receiptSummary: For audit purposes we need a report that we can search by user to get a list of the Purchase Orders they performed the receipt on in Oracle. Content (please ens…
-
OTBI Graph: Maintain Same Color for Multiple Measures of the Same SupplierHi, I'm working on an OTBI Analysis in Oracle Fusion and have a requirement to display both Invoiced Quantity and % of Quantity in a stacked vertical bar chart. Currentl…
-
Report definition not found:/shared/Custom/Reports/FIN/PayablesSummary: we delivered a custom report in fusion PROD instance and auto scheduled to every friday 8am. its getting error out as per schedule and service account is used t…
-
R13 Financials 24A OTBI subject areas to database lineage mapping Spread SheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Not able to run and generate data for a Receiving Receipts Real time & Purchasing Receipts Real timeSummary: Not able to run and generate data for a Receiving Receipts Real time & Purchasing Receipts Real time OTBI report using a custom role. Currently these are added …
-
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…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
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…
-
How to convert an existing OTBI report with prompts and filter conditions to BIP reportSummary: We have requirement to convert the OTBI report to BIP report. The OTBI reports has prompts and filter condition. How can we convert the same in BIP report witho…
-
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…