Get Started with Redwood for Oracle Cloud SCM Begin Now
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
-
P2P report. PR-PO-Receipt-InvoiceSummary I need a report on P2P process.Version 19A -
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…
-
How attachment actions in PIM can be restricted in ITEM tab for Approved Items using a Page ComposerCurrently we have used below expression builder to hide the Add/delete/Check In/Check out Component from 'Item Revisions' Tab, But the Same expression builder is not all…
-
Not able to find backing Requisition number field for Transfer Order in OTBISummary: Not able to find backing Requisition number field for Transfer Order in OTBI Content (please ensure you mask any confidential information): We are creating an O… -
Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,…
-
Review work order cost View Detailed balance UI: Need table for Cost Allocation FactorSummary: Hello Community, I'm developing one report related to manufacturing costing for which I need table name for Cost Allocation Factor. Any leads will be helpful. P…
-
extensible flexfieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
Data Not Visible in OTBI Dashboard for the userSummary: We have create a custom OTBI dashboard to show Item Information, Inventory Information , Purchasing Information, Sales order Information, Price List Information… -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 24D…Ramamurthy Shankarachetty-Oracle 14.1K views 53 comments 38 points Most recent by Praveen Kumar Akkala-Oracle
-
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
Deploying the undeployed KFF's resolved the DFF's not appearing in OTBIWe have created a new DFF for POZ_SUPPLIERS. Deployed the DFF and ran the ESS Job : Import Oracle Fusion Data Extensions for Transactional Business Intelligence. The DFF…
-
Need Unmasked Bank Account Number in Supplier PVO in BICCSummary: There are two columns in Bank Account tables, one for masked bank account number and another for unmasked bank account number. But in BICC, Supplier/Supplier Si…
-
How to enable shipment line DFF in Seeded shipping subject areaSummary: DFF have been configured in Shipment Lines Level. Requirement is to be able to fetch the DFF in seeded Shipping subject area for configuring an OTBI report. Not…
-
How to enable Shipment DFF in Shipping Seeded Subject Area?Summary: DFF have been configured in Shipment Lines Level. Requirement is to be able to fetch the DFF in seeded Shipping subject area for configuring an OTBI report. Not…
-
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…
-
How to access and print attachments in Quality Action/Issue ReportSummary: We have a new business requirement where they want a report that lists/print all the attachments of each Quality Action/Issue available in Attachments section. …
-
can you join "Fulfillment Lines Real Time" with "Receivables - Customer Real Time"Need to join those 2 subject areas to bring the "collector" from the account to the orders data. Both areas have the account number, but cant seem to find a way to join …
-
Is there any subject area with the Planned Delivery Date on the shipment?Summary: We have to create a report on the shipments and need the Planned Delivery Date that appears in the shipment. We cant seem to find it. Content (required): Versio…
-
seeded inventory reports OTBI and AnalyticsSummary: Where can i find Inventory seeded Reports 1. OTBI/BIP Seeded 2. Analytics Seeded report difference between two and navigation for both Content (please ensure yo…
-
Print Labels on Zebra Printer from Oracle FAW - BIWe have a requirement on printing labels to Zebra printer. We are sending the print command from FAW-BI to CUPS and CUPS to Printer however it is not getting printed. Po…
-
In OTBI Report Date is not displaying correctly as per the date mentioned in front endSummary: In OTBI Report Date is not displaying correctly as per the date mentioned in front end Content (please ensure you mask any confidential information): Subject Ar…
-
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…
-
The specified criteria didn't result in any data for Inventory transaction real timeSummary: receiving result "The specified criteria didn't result in any data" User has a custom role that has been assigned "Inventory Transaction Analysis Duty" and has …
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…
-
Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero (rounded down)Summary:Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero but Excel export shows correct value. Analytics > Run Standard Cost Details seeded report…Maria Angelica Mendoza 21 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle -
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 obtain xml for Supplier Negotiation PDF ReportSummary How to obtain xml for Supplier Negotiation PDF ReportContent Hi All When I look at the bip template layout for Supplier Negotation PDF Report it is not linked to…