Business Intelligence
Discussion List
-
OTBI subject area for complex PO work confirmation dataCan someone help me identify the subject area in OTBI for work confirmation reporting? -
Procurement contractSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables… -
Looking for Requisition FYI notification Data model and report (ReqStatusFYI notification)Summary: We are interested in knowing if there is a data model or report available for the ReqStatusFYI notification. Due to the fact that we presently have the data mod…Shashikanth Kumar P-Oracle 22 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement -
SQL for Approved requisitions not generating PO'sSummary: SQL for Approved requisitions not generating PO's Content (please ensure you mask any confidential information): Hello Will you please share with me any SQL to …Cesar Saveedra 41 views 3 comments 0 points Most recent by Ivan Pena-Oracle Self Service Procurement
-
Granting access to PO OTBI reports based on requisition BUSummary: We have multiple requisition BUs(hotels) under one procurement business unit. Each hotel controllers now need to see a report of all their department heads POs …
-
Need to know in which table the Draft Status of Purchase order is foundHi All, Could anyone please tell where can i find the table for Draft Status of Purchase Order if possible please provide the SQL query for Draft Status Navigation Path …
-
How to stop Multiple email notification to supplier.We have requirement to send 1st notification to supplier for OSP PO but afterwords if any change on promised delivery date of OSP purchase order then those notification …
-
How to create UNSPSC reportsSummary How to create UNSPSC reportsContent We have client requirement to setup the UNSPSC codes structure along with the commodity (category) codes in Oracle Procuremen… -
Unable to view Processed Orders by BuyersSummary: System is throwing an error while opening the analysis 'Processed Orders by Buyers' Content (required): Hi, when I am trying to open the analysis 'Processed Ord…
-
How to change PO title in BPM work list?Summary: In BPM work list, po approval comes as 'Approve Purchase Order 85000' we want a way to update the title like 'Approve 'BU NAME' Purchase order 85000' Content (p…
-
Corresponding PVO in BICC through which we can load the Fusion tablesSummary: Hi Team, We are trying to load the data from BICC PVO to below Fusion tables related to Purchase Orders using the Business Intelligence Cloud Connector. But we …
-
Output for ESS job 'Import Requisitions' not visible to userWhen user is submitting ESS job 'Import Requisitions', he is not getting report output to view. Which role is required to view ESS job report output.
-
we want to know the maximum characters length supported in the Purchase Order PDF ReportSummary: We are not able to find the maximum characters size that is supported in the PO PDF Report which is generated using RTF Template(PurchaseOrderLayout.rtf). Purch…
-
Need PVO that contain Source Agreement of the Purchase Order LinesSummary: We need to extract the Source Agreement from the Purchase Order Lines. Please refer to the screenshot below: We could find the field "Contract Id" in the PVO Fs…
-
Need to view who created and updated transactions.Summary: Content (required): In my organization, we want to find a way to view and analysis to know which user created or updated certain transactions such as AP Invoice…
-
Attribute fields/columns are missing in PVO PurchasingDocumentLineExtractPVOSummary: Attribute fields/columns are missing in the PVO. We need to extract a field in the PO Lines called "Sustainability Purchases". We presume this is one of the Att…
-
Procurement - Procure to Pay Real TimeSummary Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POsContent Hi, We would like to create an OTBI report using the Pro…
-
Field is missing in latest PVO for Purchase order header DocumentsSummary: The below Latest PVO for purchase document header missing important field "FROM_HEADER_ID".This field is required to find RFQ's and Draft PO's Please let us kno…
-
Receipt Number field blank on OTBI report from Procure to Pay Subject AreaSummary Receipt Number field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, we built a OTBI report based on "Procure to Pay" subject area, receipt … -
Is Cost Accounting License required for The Un-invoiced receipt accrual report?Summary: Is Cost Accounting License required for The Un-invoiced receipt accrual report? Content (required): We need the Cost Accountant role to run the Un-invoiced rece…
-
History of Requisition/ Negotiation view or download of attachment?Summary: Is there a way to get a history of a Requisition or Negotiation of the users who viewed the transaction or who downloaded a attachment of the requisition or neg…
-
What subject area has access to PO Contract Terms Deliverables?Summary: Content (required): We would like to create a report that summarizes all PO contract terms deliverables and their status. Is there any subject area that would h…Joana Falcao 31 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Enterprise Contracts -
Need the concept/logic behind why Retroactive pricing is viable only with Non-Cumulative Price BreakSummary We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.Content Hi all, Based on my research, Fo…Harshith Eshwar Shaila-145631 255 views 6 comments 0 points Most recent by Alexander Joseph Purchasing -
How to generate purchasing activity report in oracle fusion?Summary: Content (required): Purchasing activity report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) …
-
Query to See the Approver Name on Whom a PO is Pending For ApprovalSummary Query to See the Approver Name on Whom a PO is Pending For ApprovalContent Most of the time we get an SR with requirement to see or extract on which approval lev…
-
how to get Good receipt note details with procurement details on OTBI reportSummary: Content (required): Hello everyone, We have a OTBI report in the production instance related to PR details. The subject area, " Procurement - procure to pay rea…
-
Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice).Summary Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice)Content Hello Gurus, Is there seeded report or any OTBI Subject Area's to join…User_2025-02-03-21-08-45-135 180 views 5 comments 1 point Most recent by Ivan Pena-Oracle Purchasing
-
Single Requisition BU or Multiple Requisition BUSummary Single Requisition BU or Multiple Requisition BUContent Here is a business case Three Legal Entities * LE1 * LE2 and * LE3 One Requisition BU and One Procurement… -
Table for PO Acknowledgement in Oracle FusionSummary Wanted table that captures PO Acknowledgement in Oracle FusionContent Hi, We are looking for table for PO Acknowledgement in Oracle Fusion Cloud 20B version Than…
-
Real implication of Sold to LE in Purchasing Transaction - Indirect Procurement - Global LocationsSummary Real implication of Sold to LE in Purchasing Transaction - Indirect Procurement - Global LocationsContent Trying to understand a bit more on this, appreciate any…