Business Intelligence - BI
Discussion List
-
Only actual buyer should appear in dropdown in Manage Purchase Order screenSummary: Hi Folks We have a requirement as below - In Manage Purchase Order screen, there is filter parameter of buyer. In these LOVs the requirement is that only person… -
Cost Center details in Purchasing- Requisitions Real Time Subject AreaSummary: Cost Center details such as Cost Center code and Cost Center description in 'Purchasing- Requisitions Real Time' Subject Area Content (please ensure you mask an…Srinivas Reddy 21 views 4 comments 1 point Most recent by Srinivas Reddy Reporting and Analytics for ERP -
How to change Subject Line in Buyer FYI Notification Email?Summary: An email notification is sent to Buyer when a Purchase Order is Created or Changed. The client requirement is to modify it to Add Revision number in the subject…
-
Requirement: Receipt report that gives the end user the ability to download a PO or PR attachmentSummary: Customers have provided us with the requirement to develop a receipt BI or OTBI report that gives the end user the ability to download a PO or PR attachment if …Shashikanth Kumar P-Oracle 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need to Pull Final Approver on BI Report.Summary: We have a request to pull the Final Approver on a BI Report. The report has been built using SQL and is pulling from the fa_fusion_soainfra.wftask to get the ne…David Davis 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Regarding po receipt invoiced is 0I need to extract those receipt line invoiced column having 0. Could anyone please help me on that. Below screenshot for reference purpose.Banerjee Subham 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…
-
Need a BI report for Requisition and Purchase Order attachmentsContent We need a BI report to get the Requisition and Purchase order attachments. -
How to restrict items (Inventory) in requisition / PO Lines?Summary How to restrict items (Inventory) in requisition / PO Lines?Content Hi all, In Requisition / PO line-entry all inventory items are coming, We need to restrict so… -
Can we add GBPA number as a link in a BI report?Summary: We have a BI report to extract details related to Purchase Agreements. Can we have the Purchase Agreement number as a link in th report , clicking on which woul…
-
OTBI report for Subject Area Procurement - Purchasing real time giving no dataSummary: We have a custom Buyer role with BI Author and Purchase Order Transaction Analysis Duty role and the required grants on Purchase document header tables. The rol…Asutosh Mishra 345 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Can we modify the Notification "Requisition <123> Entered by <Preparer> Was Reassigned to YouSummary: We would like to modify the Notification that is sent when a Preparer of a Requisition selects Actions->Reassign, enters the "Reassign To" Person and selects "S…Francine Kipouras-Oracle 21 views 2 comments 0 points Most recent by Francine Kipouras-Oracle Self Service Procurement
-
Unable to find Purchase requisition notificationSummary: Hi Team, There is a notification generated for PR approval for approver in Oracle fusion i am unable to find the DataModel and report for this Notification in "…Immanuel Aruldoss 52 views 2 comments 0 points Most recent by Immanuel Aruldoss Self Service Procurement
-
How can we generate an OTBI report with receipt Number with received Quantity/AmountSummary: We have a requirement to create an OTBI report with Receipt Number and the corresponding Received Quantity or Amount. We tried using Purchasing Real Time data b…Asutosh Mishra 261 views 1 comment 1 point Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Deep link for lines to be PutAwaySummary: I have one report that allows all the receipt lines to be PutAway. I would like to click on Receipt Number and then the window of the PutAway will be open using…Giuseppe Galluzzo 51 views 4 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Oracle Data Retention PolicySummary: Confirmation from Oracle on the archiving and data retention policy. Procurement Operations team would like to confirm that there is no restriction on data rete… -
Requisition Approval Notification - Approval History - Submitted by is Not having the pdf linkSummary: When a requisition is submitted for approval, the Approver is receiving the notification, however that is not having the requisition pdf link attachment in the …Natarajasuthan K 103 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
How to check if requisitions have been imported in an 'Approved' status?Summary: In accordance with SOX Compliance requirements, we need to determine whether or not any users have submitted Requisitions through Req Import with an approved st…Joe Horvath 31 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Integration between OTBI and FAWSummary: Integration or Linking possible between OTBI and FAW. Content (required): There is currently an ask to integrate OTBI and Fusion Analytics Warehouse (FAW). Is t…Annika Wan Yee 61 views 5 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for SCM
-
Query to find requisition line cancel timeSummary: We have POR_REQUISITON_LINES_ALL which as cancel_Date but it doesnt have timestamp. We can join po_actions_history with por_requisition_headers_All but we do no…Nidhi Chhajed 21 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Is shipment Hyperlink is possible in BIP reports.Summary: In the BIP report, Once the user clicks on the shipment number it should take to inventory Manage shipment page in display mode. Please confirm . .Content (plea…KOTTHURI ASHOKBABU 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Inventory Management
-
Inventory Reservations Query/ReportSummary: Need a report of the information seen in Manage Reservations and Picks (Item, Reserved Quantity, Document Number, Document Line Number) Content (please ensure y…
-
Purchase Requisition PDF ReportSummary Customise seeded Requisition PDF templateContent Hi all, Does anyone have ever customised the seeded Purchase Requisition PDF Template (not PO, not approval)? I'…Luiz Mendes Jr 320 views 14 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement -
How to insert the filter on org_id in SQL query ?Summary: Hi , how can we insert a filter in a query to extract both management and financial project? We try with this expression : ORG_ID>0 but is not valid. The tables…Michela A. Morgillo 11 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement -
Adding a column similar to the DFF to a table in the UISummary: The review completed transaction user interface allows us to export every column to an Excel file. The customer asks that the review completed transaction user …Tharushi Sathsarani 31 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management
-
Requirement to restrict the access of subject areasDears, We have a requirement to restrict access to subject areas to specific users. These requirements are only for the requisitions, which means that users should only …Ejada- Adel Elsaid 71 views 5 comments 0 points Most recent by Kim, Powell-Oracle Self Service Procurement
-
Custom template for requisition PFD per business unitSummary: Custom template for requisition PFD per business unit (With diferent logos per BU) Content (required): A personalized template is created for the client and we …Marlene Villa-Oracle 437 views 11 comments 0 points Most recent by Tahir Kafadar Self Service Procurement
-
Approved Supplier List Entry Scope column tableApproved Supplier List Entry Scope column table
-
Need sum of released amount of agreement created from a Contract fulfillmentSummary: We are creating a report for spend analysis where we need the sum of released amount from agreements (BPA & CPA) created from Contract Management module. We nee…
-
How to Identify dashboard reports / infolets from Oracle Fusion UI ScreenSummary: Identify dashboard reports / infolets from Oracle Fusion UI Screen Content (required): Hi, I have a requirement to identify the dashboard reports / infolets fro…