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 … -
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…
-
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…
-
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…
-
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…
-
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…
-
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… -
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…
-
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 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…
-
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…
-
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…
-
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…
-
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…
-
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 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…
-
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…
-
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…
-
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…
-
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 contract terms are merged with BPA PDF?Summary: When we add terms to purchase agreement, then click on View PDF , the Report of agreement( RFT) and Contract terms which has the transformation templates, how w…
-
Select query to fetch the PO header detailsSummary: We have a requirement to create a report to show the PO header details Content (please ensure you mask any confidential information): We have a requirement were…
-
SQL query for item master and functional catalog assignmentsSummary: We have a requirement to develop a report to fetch a list of items with catalog and category values. Content (please ensure you mask any confidential informatio…
-
Customer Recon ReportSummary: We are importing the Cutomers,parties,partisite,partisiteuses,address,site,siteuses,location,contacts details using FBDI.Is there a specific report that we can …
-
Select BIP to get the pick slip for the pending transactionsSummary: Select BIP to get the pick slip for the pending transactions of a specific item Content (please ensure you mask any confidential information): Hi All, we need a…
-
Oauth Error while invoking the SCM RODS api for the new data extract toolSummary: I am trying to invoke the RODS api for the new fusion extract tool . This URL is used to get the extract definitions, it works when using the access token from …
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
OTBI Reporting Performance issueI am using two subject areas Order Management - fulfilment lines real time & Shipping real time for oracle fusion OTBI report, as per the business requirement, inspite o…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…