Business Intelligence - BI
Discussion List
-
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 21 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…
-
For Inventory label printing which printers are supported in OracleHello, can anyone please suggest printer model for printing inventory labels(Item, Location)
-
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. https://us.v-cd…Deepali Singal 375 views 5 comments 0 points Most recent by Jayaharan Krishnamurthy Reporting and Analytics for ERP
-
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 32 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…
-
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 5.9K views 68 comments 47 points Most recent by Susheel K Raina-Oracle Self Service Procurement -
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… -
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…
-
Print Receipt Traveler ReportSummary: Does 'Print Receipt Traveler Report' ESS job auto trigger work when receipt is created from the Procurement > My Receipts (New) page? Content (please ensure you…
-
Receipt Traveler ReportSummary Receipt Traveler Report is not getting submittedContent We are integrating with RFSMART for Receiving. Though Manage Receiving Parameters has "Print receipt trav…User_2025-02-10-18-21-36-111 66 views 3 comments 0 points Most recent by Sendil10 Inventory Management -
Purchase Order Customized Layout is not visible on View PDF ButtonSummary: Purchase Order Customized Layout is not visible on View PDF, Steps 1 : Customized the Standard Report (Purchase Order PDF Report) 2 : Modified the Custom Report…
-
Expiring 24B or 25A: Configure REQ PDF Using the Extensible Oracle Analytics Publisher Data Model?Summary: Is the Configure the Purchase Requisition PDF Using the Extensible Oracle Analytics Publisher Data Model opt-in feature expiring 24B or 25A? Content (please ens…
-
AMOUNT_ORDERED column in PO_DISTRIBUTIONS_ALL table is showing NULL valueHi, I've encountered an issue where some Ordered Amount values on the distribution level are showing up as null when querying the PO_DISTRIBUTIONS_ALL table. This field …
-
¿How to identify the origin of the fields in the RTF template of the “Purchase Request PDF Report"?Summary: Difficulty identifying the source of fields in the RTF template of the standard report “Purchase Request PDF” Content (please ensure you mask any confidential i…Lynda Ramos 114 views 9 comments 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Need to fetch Allow_International_Payments_Flag for Supplier data in BIP Report.Need to fetch Allow_International_Payments_Flag column for migrating supplier data from fusion to new fusion environment. This column is in AP_SUPPLIER_SITES_ALL table s…Chaitanyadev_Functional Consultant 1 view 1 comment 0 points Most recent by Subhashini Supplier Management
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 21 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
SQL Query to extract Item LocatorsSummary: SQL Query to extract Item Locators Content (please ensure you mask any confidential information): Hi - I wondered if anyone might be able to help please, with a…
-
Auto-Printing the Receipt after submittingClient Requirement: after creating the receipt and submitting it, the client wants to auto-print a custom report we have developed for him. is this functionality standar…