Business Intelligence - BI
Discussion List
-
Is it possible to add 'Destination Type' field on Purchase Requisition approval notificationSummary: Hi All, We have a requirement to add 'Destination type' field on Purchase requisition approval notification. Content (please ensure you mask any confidential in… -
Views created for the inv_material_txns table?Hi Experts, I was looking to tune my BI Report Query. I have used inv_material_txns table frequently in the query, I wanted to understand if there is any view created fo…
-
Can we Automatically trigger Label on Inventory Movement TransactionSummary: Hi Community- We have a requirement to print below 3 type of labels automatically on completing the mentioned transaction, is there any business event available…Akshay Mohan Raykar 13 views 1 comment 0 points Most recent by Akshay Mohan Raykar Inventory Management
-
API to Identify failures in INV_BALANCE_TXNS_INT post run of Manage Inventory Balances ProcessHi Team, We are processing around 20k to 50k records as part of Manage Inventory Balances Process in Fusion. Is there an API we can use to query results of the process t…
-
Error message while defaulting the value for DFF: FND-FND_VS_VALUE_INVALID, cannot be accessedSummary: Hi, While setting the default value of a DFF, facing an error: FND-FND_VS_VALUE_INVALID, can not be accessed. Attaching screenshot for the same. Content (please…Deepali Singal 415 views 6 comments 0 points Most recent by Chandan Mohanty Reporting and Analytics for ERP
-
Any options to activate the OGJ in Custom Redwood PagesAny options to activate the OGJ in Custom Redwood Pages ? To invoke the BIP Report
-
Requisition PDF Report With Data Model XML fileHi Experts, In the upcoming 25A update, the Requisition PDF XML Publisher template will no longer be available and we will need to customize the new extensible Oracle An…
-
RequisitionApprovalEmailReport customizations not reflecting in output MailSummary: I have a customized RequisitionApprovalEmailReport. Which is working fine. We can see all the customization in that report. Earlier, added few fields (DFF Value…Grab.saurabh 11 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement
-
Customization of Purchase Requisition Approval EmailI am currently trying to customize the purchase requisition approval email template. I need to add additional text to the email body and modify the subject line of this …
-
how to run the parameters for Requisition Approval E-Mail Report in selfservice procurementSummary: Requisition Approval E-Mail Report Content (please ensure you mask any confidential information): what are the mandatory paramters that needs to be given to get…
-
How to extract a Report on Purchase Requisition and Purchasing Approval RulesSummary The steps needed to produce a report of the approval rules that have been created in the system for Purchase Requisition and Purchasing related Approvals Content…Sumana-Oracle 6.7K views 72 comments 48 points Most recent by Sajid Khan Bangash Self Service Procurement -
How to run incremental extract for EFF PVO FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVOSummary: We are Unable to run incremental extract for BICC VO FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVOThere isn't a suitable column (like a last update …P3Siebel-Oracle 12 views 0 comments 0 points Started by P3Siebel-Oracle Product Master Data Management
-
Requisition View PDF not showing the custom templateHi, We received an email from Oracle stating that action is required for customers using a custom template for the "View Requisition PDF". Since we are currently using a… -
We need to find the details of a previous buyer of a PRSummary: We have a requirement to display the Buyer name, Reassigned Buyer, and Buyer Reassigned Date at the PR line level when a buyer is changed to a new buyer. We hav…Yasser J. Alas'ad 17 views 3 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement
-
For Inventory label printing which printers are supported in OracleHello, can anyone please suggest printer model for printing inventory labels(Item, Location)
-
Calculation logic required for Available to Transact and Available to ReserveSummary: We have a business requirement to show the On-hand Quantity, Available to Transact and Available to Reserve on a Part request screen. We need the Available to T…
-
Review Item Supply and DemandSummary: Hi Team, is it possible to extract all the details from "Review Item Supply and Demand" View like all the fields : date - document type - document number - sour…
-
Redwood Unable to Generate PR PDFHello, We are unable to generate PR pdf when from SSP redwood application. Below is the error. { "title" : "Bad Request", "status" : "400", "o:errorDetails" : [ { "title…Ajay Sudhir Parab 22 views 3 comments 0 points Most recent by Elena-Cristina Staniloiu-Oracle Self Service Procurement
-
Which table we can use for every day's inventory quantity onhandHi team, We are using cst_del_onhand_valuations table to get quantity_onhand and inventory valuation for our customized inventory balance BI report. But this table is a …
-
Query to retrieve Trade Operation and corresponding PO detailsSummary: Content (required): Hi, There is a requirement to create a report that displays the following columns; Trade Operation number Trade Operation Name Created By Us…
-
Negotiation Invitation Email links are not working for supplier in procurementSummary: When the supplier receive the negotiation email (Action Required: You Are Invited to Negotiation RFQ000028) When the supplier try to click the link Accept invit…
-
Requisition Approval Email Report - changes not reflectingSummary: We added Supplier Name in the Layout of Requisition Approval Email Report. The change has been done a few hours ago and changes are not reflecting when testing.…Lovely Tamba 71 views 1 comment 0 points Most recent by Raul Gheorghe-Oracle Self Service Procurement
-
PVO unavailable for the table INV_PICK_SLIP_NUMBERSI was looking for a PVO for the table INV_PICK_SLIP_NUMBERS, but figured that there's no PVO available for the table. Is there a way I can create a PVO for the table INV…
-
The SQL to export the list of BPA & PO having Master Contract which doesn't have Contract TermsSummary: Anyone please provide the SQL to export the list of BPA and PO number which have the master contract attachments and those contracts doesn't have any contract t…
-
Use Requisition Header DFF for ApprovalWe want to use Requisition header attribute to capture approver detail to whom the Requisition will be routed to approval. I tried using Requisition Header.Descriptive F…NamrataKumar 131 views 8 comments 0 points Most recent by Saravanan Subbaiya Self Service Procurement
-
Manage requisition approvals queryHi, I have a requirement to get the conditions for requisition approvals, able to see the conditions in Manage requisition approvals. But I'm unable to get the all condi…
-
Table(s) that populate when users return/ correct using Procurement > My Receipts > Manage ReceiptsSummary: We need to identify the Oracle fusion tables that are populated when users return/ correct procurement receipts using the Procurement > My Receipts > Manage Rec…
-
Multiple Entity data visible in Spend ClassificationSummary: An entity user who was given buyer access and data access to a particular Business unit is able to view or create data such as Purchase Requisition, Purchase Or…
-
Movmnt of Stock frm 1 Inv Org to Other Such That Its Current Bucket in Inv Aging Reprt isn't ChangedSummary: Business user wants to transfer two items (one item has 1 quantity and the other item has 2 quantities) from one of their inventory orgs to the other in such a …
-
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i…