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
-
Unable to access data from content serverI have a text attachment in work order operation level. I would like to print the contents of the text in work order traveler report. I would like to know how can I acce…
-
The specified criteria didn't result in any data - For Purchase Requisitions and PO Details ReportsSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …
-
Deleted contacts in AR Customer still appearing in TableSummary: Hi, I have created AR Customer and Customer Account, Site and Contact. When checking in Table using below query, it is working as expected. select * from HZ_REL…
-
BICC Not showing DFF FieldsSummary: Hello Team, BICC extracts are not showing the Shipment header and line DFFs which are configured in the system for the following seeded PVOs: - FscmTopModelAM.S…
-
How to Join 'Inventory - Inventory Transactions Real Time' & 'Shipping Real Time' subject areaSummary: Hi Gurus, We are trying to build a report which show the Inventory Transcations with the 'Waybill Number' & 'Tracking Number' field. So is there a way to join t…
-
how to trigger seeded version of the report if we have customization in BI reportswe customized Print Movement Request Pick Slip Report, and it's getting printed when we submit Pick Materials for Work Orders Report process. we have a requirement to ge…
-
Web serivce API/SOAP to retreive item current cost and transaction cost by cost elementsSummary: Is there any API/SOAP to retrieve the item current cost and transaction cost by cost elements and not only total unit cost? Also, is the below API generated by …
-
Can a dynamic hyperlink be programmatically embedded within text in BI publisher report?We have a requirement to print attachments links in PO PDF report. The report should have the attachment name as a text, upon hovering over the text the hyperlink to the…
-
Issue with Subquery/Outer Query with BOM LEVEL - Results Messed UpSummary: Hi everyone, I would greatly appreciate any suggestions or help regarding the use of outer queries or subqueries. I want to use multiple subqueries and join the…
-
Reports for Product ManagementWhat are the Reports available for Product Management and from where we can see all that.
-
OTBI report timeout error how to schedule OTBI reportHi All, In the OTBI report, we have a large number of records. It was running for 25 minutes successfully with my user credentials, but when using another user's credent…
-
How can your report on Back dated receiptsDoes anyone know how you can report on back dated receipts FIN has allowed receivers to receive into the new year on orders for the previous year. the instruction is to …
-
BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERSI'm creating report SQL, but when I executed the SQL I got an error. When I executed the SQL I got an error. There were no errors before I joined INV_TXN_REQUEST_HEADERS…
-
OTBI is not showing Safety Stock Quantity values from Supply PlanningSummary: OTBI is not showing Safety Stock Quantity values from Supply Planning when using Supply Chain Planning Real Time subject area. Content (please ensure you mask a…
-
Subject Area 'Sourcing - Supplier Negotiations Real Time' Supplier Name absentSummary: A supplier negotiation has 5 invited suppliers listed under the section Suppliers. The indicator 'Restrict to invited suppliers flag' is YES. We would like to p…
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
Query for Workflow Details of NIRHi Everyone, I am looking for the query to get workflow task details of an NIR. Please refer to highlighted part screenshot for details. I am creating a custom BIP Repor…
-
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…