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 … -
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
CSV report output from OAC/BIP missing double quotes on string valuesHi Team, There are some csv reports setup in OTM BIP server. Every 2 hours, OIC pulls these csv reports and fetches the output and places them at another external locati…
-
Unable to View XML Data from Seeded Print Packing Slip Data ModelSummary: Hi Team, I am trying to view the XML data from the seeded Print Packing Slip Report data model in Oracle Fusion. However, when I try to view the data by providi… -
Our SQL Query only show Account Alias Receipt TransactionsSummary: Our SQL Query only show Account Alias Receipt Transactions Content (please ensure you mask any confidential information): Hi I want to create SQL query that can…
-
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…