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
-
How to call pages from different moduleSummary: Hi All, I am working on a Idea to call pages from different modules. Here is how it should work Navigation>Order Management>Manage fulfilment lines. On this pag…
-
Extract DFF/EFF for Transfer Orders/Sales OrderSummary: Hi, We have a reqiurement to extract the DFF and EFF information for Transfer Orders and Sales order using BICC. We could able to find the below PVOs for extrac…
-
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,…
-
Create OTBI analysis for Procurement Contracts based on Logged In userSummary Want to Create OTBI analysis for Procurement Contracts based on Logged In user Content (please ensure you mask any confidential information): We need to create a…
-
Where would the overview page analytics be visible in the Redwood theme page?Where would the overview page analytics be visible in the Redwood theme page? For Order Management/Procurement?
-
Requisition Counts and Year to dateSummary: Requisition Realtime Help! I am trying to create a Requisition report that will display Departments and columns Jan ct, Feb cnt etc and the last column will be …
-
Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …
-
How to rollback customized PDF templateSummary: How to rollback customized PDF template? Content (please ensure you mask any confidential information): Hi Experts, I got this requirement to rollback the custo…
-
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…
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…
-
Primary keysSummary: Is there any document listing the Primary keys to be joined in the fscm oracle pvo ? Content (please ensure you mask any confidential information): Version (inc…
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…
-
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n…
-
Item revision for onhand analysis reportSummary: Item revision for onhand analysis report. Content (please ensure you mask any confidential information): Created an analysis report using Inventory - Inventory …
-
Restrict "Edit" function on OTBISummary: Restrict "Edit" function on OTBI Content (please ensure you mask any confidential information): Hi Experts, I got this question that I am not able to restrict e…
-
Which table in Oracle fusion stores the error messages while Importing sales Order using FBDIIn which table, can I find the error messages for any error occured during the Import Sales Order using FBDI
-
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…
-
The supply plan tables could be printed in BI report?Summary: Hello, I have a custom table for supply planning, I need a BI report to print data generated into the table for the 3 measures per period while is filtering by …
-
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…
-
Supplier Statement ReportSummary: Any OTBI or Seeded Supplier Statement Summary & Details report including transactions details and opening closing balances. Content (required): Any OTBI or Seed…
-
Delete master and transaction data related to one LE from an instance (Oracle Fusion Cloud Apps).We have implemented multiple legal entities across different countries in a SaaS instance. The client now wants to split these entities into two different SaaS instances…
-
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)…
-
Capacity / Resources Requirement calculation for Phantom subassembliesSummary: Hello All, How is Capacity / Resources Requirement calculated for Phantom subassemblies in constraint supply chain planning? supply planning doesn't calculate p…
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…
-
Requisition Report errors when filtering to one BUWe have a Requisition Approved Status report that runs a report for approved Reqs for our 3 Business Units, Report runs fine when ALL BUs are selected or even 2 BUs. But…
-
Backend tables for Receipt Accounting DistributionsSummary: I need backend tables for the screen Receipt Accounting Distributions (Supply Chain Execution>Receipt Accounting> Receipt Accounting Distributions). I found tha…
-
Requisition Unprocessed daysSummary: Difference between OTBI Requisition- Unprocessed days in Line detail and Unprocessed days in the Line folder Content (please ensure you mask any confidential in…
-
Database table to get the min and max quantity for Replenishment plan type item in oracle fusionSummary: Hi all, please let us know Database table which stores min and max quantity for Replenishment plan type item in oracle fusion Content (please ensure you mask an…
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
Need SQL query to extract Agreements and the assigned Requisitioning Business unit namesSummary: Purchase agreements with assigned Requisitioning Business unit names extract Content (please ensure you mask any confidential information):Need SQL query to ext…