Business Intelligence - BI
Discussion List
-
Restrict the access of Procurement OTBI Dashboards with respect to Inventory OrganizationsDear Team, I have developed an OTBI report with purchasing real time subject area however when I assign that otbi to the user I would like to restrict the data only with… -
pvo to link between catalog and categoryIs there any PVO to link between Purchase Catalog and Purchase Category
-
query to get negotion award approval historyHello I want sql query or fusion tables to get sourcing/negotion award approval history person name action date Below is the screen shor of form from where i want when w… -
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 13 views 4 comments 1 point Most recent by Srinivas Reddy Reporting and Analytics for ERP -
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 288 views 3 comments 0 points Most recent by MariCostache-Oracle 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 36 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 13 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
-
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 286 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 43 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 182 views 1 comment 1 point Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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 87 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 32 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 62 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 11 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
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 263 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 -
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 61 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 364 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…
-
Requisition rejection in the BPM workflowSummary: If the requisition is rejected in the BPM workflow, which table will hold the details about the rejection comment. Content (required): If the requisition is rej…
-
Query to fetch the Requisition job pending approval details in oracle fusionSummary: In purchase requisitions we have to prepare a bi report for the pending approval status and their job name Content (required): Version (include the version you …Pravallika Mamidipaka 1.3K views 0 comments 0 points Started by Pravallika Mamidipaka Reporting and Analytics for ERP