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
-
Why Front Infolets Source to Settle it does not show any data?Summary: Analytics Source to Settle Infolets section in front not show any data (blanket) users only can see results into Expanded view. Content (required): Procurement … -
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D… -
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.… -
Index to be applied on LAST_UPDATE_DATE field of "doo_headers_all" tableSummary Index to be applied on LAST_UPDATE_DATE field of "doo_headers_all" tableContent Hi , We have a report created which fetches order,Order charge component , pricin…
-
How to find last_modified_by for reportsSummary How to find last_modified_by for reportsContent Hi Team, We have reports with multiple templates and same has been modified by someone. so would like to find the… -
Version Control for Data Models and ReportsSummary version control reports in BI PublisherContent Hello, Is there any best practice, or any way to version or tag a report or a data model in BI Publisher ? Thanks,… -
Plan to Produce Infolets are not appearing on Home PageSummary Plan to Produce Infolets are not appearing on Home PageContent Hi All, We are not able to see any infolets on Plan to Produce Infolets section. Please let us kno… -
Possibility to retrieve URL of an attachment stored in SaaS through BI PublisherSummary URL of attachments stored in UCMContent Hi, I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM. I have checked in t…
-
Supplier Registration or Profile Change Approval DetailsContent Hi , I want to prepare a SQL which will have supplier and approver details. I know we have below workflow and supplier tables: fa_fusion_soainfra.wftask fa_fusio…
-
Procurement - Purchasing Agreements Real Time created reports does not show any dataSummary when a user having only the Purchase Analysis role run a report created using the Purchasing Agreement Real Time subject Area the report does not show any result… -
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized … -
Combining Purchasing and Negotiation Subject AreaSummary Combining Purchasing and Negotiation Subject Area, does not combine join correctly.Content Hello, I want to combine Purchasing Real Time with Sourcing Negotiatio…
-
Opening Analysis from Dash Board not showing export optionSummary Opening Analysis from Dash Board not showing export optionContent Hi, I have created Dashboards with analysis, but when I am opening analysis from dashboard it i… -
I want to create costing reportSummary Costing report requiredContent I want to get UNIT_COST,SUM OF ON_HAND_QTY with ITEM_CODE and its ITEM_DESCRIPTION
-
Item Pricing informationSummary Need to extract item pricing information by locationContent Hi, We are looking for BIP report/OTBI subject areas that can extract Item pricing information. Is th…
-
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…