OTBI
Discussion List
-
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 -
How to check "Note to buyer" before submitting of Negotiation in OTBI ReportSummary: After submitting a "Purchase Reauisition" and before creating a "Supplier Negotiation", I would like to display "Note to buyer" using OTBI Report. Content (plea…
-
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 -
BICC extract for P2PThe business wants pinpoint info that which BICC extract contains the data from these four tables: po_headers_archive_all po_lines_archive_all po_change_orders_all po_lo…
-
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
-
Unable to extract internal requisitions through requisition subject areaSummary: Want to retrieve the internal requsitions raised from the subject area Content (please ensure you mask any confidential information): When extracted, i am getti… -
Exporting OTBI dashboards in PPT FormatSummary: Content (required): Hi Team, We have a requirement to explore alternative formats to export OTBI dashboards, other than Excel and PDF. One of the potential expo…Annika Wan Yee 81 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Need to hide Add to Cart button for requisitions pageSummary: Hello Team, We are trying to hide Add to Cart button for requisitions page for particular items and these items are internally orderable. Here is the scenario: …Janardhan ACS-Oracle 31 views 4 comments 0 points Most recent by Janardhan ACS-Oracle Self Service Procurement
-
How to see DFF fields in the OTBI Subject Area : Procurement - Requisitions Real TimeSummary: New DFF fields were created in the Requsition UI but not found as a field in the OTBI Requisitions Line Detail Content (required): New DFF fields were created i…Maria Inocentes 611 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
OTBI Subject Area to be used to create report in capturing receipt details and DFFSummary: OTBI Subject Area to be used to create report in capturing receipt details and DFF in self-service receiving. Content (required): Self-service receiving Version…Cliford 62 views 5 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Create custom report for Purchase Requisition Approval HistorySummary: Our client asks for a custom report to show full approval history for Purchase Requisitions. Content (required): I search for SQL query to show all approvers , …Mohamed Faramawy dev.-Oracle 834 views 2 comments 0 points Most recent by Mohamed Faramawy dev.-Oracle Self Service Procurement
-
PRC - Unable to create Purchase Requisition with Destination Type as InventorySummary: Content (required): Hi, I am trying to create requisition with destination type as Inventory. But when I add item and click on cart system throws below error: "… -
Procurement: Unable to receive in My receiptsSummary Procurement: Unable to receive in My receiptsContent Hi All, Procurement: Unable to receive in My receipts Procurement --> My Receipts We have approved PO but we…
-
How to check ageing requisitions for a LESummary: Hello, We have multiple Legal Entity (LE) for a single BU in a region. Is there a report or UI, I can check what are the requisitions pending approval for a LE …Aqil B Shaik 22 views 3 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
what is these fields in POR_REQUISITION_LINES_ALL ?Summary: Hello, When we create a requisition and submit for approval, we are observing that the fields in the table POR_REQUISITION_LINES_ALL gets populated with the ful…
-
Knowledge Article: OTBI Related Mapping SpreadsheetSummary: How do we get OTBI related information for Self Service Procurement Content (required): Support / Customers We get this query quite often from various sources. …Ashok Sriniva-Oracle 62 views 2 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
T.nareshkumarratnakaram-Oracle 22 views 1 comment 0 points Most recent by nareshkumarratnakaram-Oracle Self Service Procurement
-
Knowledge Article: How to configure Descriptive Flexfields for use in OTBIummary: How do we configure and enable Self Service Procurement related Descriptive Flexfields for usage in Transactional Business Intelligence Content (required): Custo…Ashok Sriniva-Oracle 23 views 0 comments 2 points Started by Ashok Sriniva-Oracle Self Service Procurement
-
Fusion Self Service Procurement RolesSummary: What are the job roles that would be considered as Fusion Self Service Procurement cloud roles. I added Procurement Requestor role to a user but user can not se…Shivaji Muttarapu 33 views 3 comments 0 points Most recent by Maithily Kohale-Oracle Self Service Procurement
-
OTBI to Fetch Shopping List details.Summary OTBI to Fetch Shopping List details.Content Dear Team - Our Client is from the health care industry and they are heavily dependent on Shopping List. As of now cl… -
Requisition Approval based on one of the segment value of the Charge AccountSummary Requisition Approval based on one of the segment value of the Charge AccountContent We have a requirement as follows let us say, we have a charge account as foll…Sam Samaddar 54 views 13 comments 0 points Most recent by Aditi Surana-Oracle Self Service Procurement
-
How to convert 100 Public Shopping List from DEV to TestSummary How to convert 100 Public Shopping List from DEV to TestContent Hi, I want to know if there is a way to convert 100 PSL from DEV to Test, or if there is a way to…User_08YER 20 views 2 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Procurement Master Content DocumentSummary This document will allow you to find Oracle Procurement cloud-related KM notes which are not only distributed throughout the document from flow basis but also ar…ROHIT.R-Support-Oracle 154 views 5 comments 3 points Most recent by Saravanan Subbaiya Self Service Procurement -
How to report on req lines creation (catalog, smart form, non catalog request)Content Does OTBI allow for the ability to create a report which would allow procurement personnel to see/summarize requisition lines by how they were created (catalog, …
-
Requisition Failed Funds CheckingSummary Requisition Failed Funds CheckingContent How do I know if a requsition that was cancelled still holding the funds. example; Create Requisition 2345 for $1000 Can…
-
Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderSummary Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderContent We have been trying to create few KPI's for Purchase Requisition work area and …User_2025-02-10-05-51-05-868 57 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Need Logic to create below KPI's for Purchase RequisitionsSummary Need Logic to create below KPI's for Purchase RequisitionsContent We have been trying to create few KPI's for Purchase Requisition work area and got struck on ho…User_2025-02-10-05-51-05-868 35 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Query who is assigned the requisition approvalContent Hi, I need to create a report to find out which user is assigned the Purchase Requisition approval. Does anyone have the query or tables I need to create this vi…