OTBI
Discussion List
-
Currency field of a Requisition that is in "Procurement - Requisitions Real Time" subject area?Hi Experts, We are trying to come up with a report from the subject area of "Procurement - Requisitions Real Time", while I cannot find the correct currency code that is… -
How to use Special Handling attributes in OTBI analysis?Summary: As of the 24D update, there is the new feature to use special handling type attributes within the "Procurement - Purchasing Real Time" subject area (https://doc…
-
Work Order(WO): Requisition is approved without approval.Summary Work Order(WO): Requisition is approved without approval.Content Hi all, Work Order(WO): Requisition is approved without approval. Thanks, Dev Thota. Version 19B -
How can we obtain XML to build our reportSummary: We are trying to create a custom report that pulls data from an approval flow. In the previous SR it was recommended that the information is stored in XML. We a…
-
Our requirement is to create an OTBI report for local catalogsSummary: We want to find out the below:- Which BPA lines are not assigned to a local catalog? Which CPA/BPA are not assigned to a local catalog? Can we achieve this requ…
-
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…Shameek 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to extract requisition approval rules created in BPM as a report or CSV file.Summary: Requirement is to extract approval rules along with details/settings of the various stages, participants and the rulesets. Content (required): I have referred a…Ananda Bhargav Potluri 995 views 6 comments 1 point Most recent by B Sekhar Self Service Procurement
-
Dynamic PO PDF bodySummary: one of my customer wants the PO PDF Body message that goes to the supplier to be customized dynamically and it needs to be editable for each email that is sent …
-
Requisition PDFSummary: Is there an ESS process to run the requisition PDF? We see the BIP report and would like to be able to run it without the View PDF button from the requisition s…MBradley1910 12 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Requisition Line DFF segments not populating in the Purchase Requisition PDF reportRequisition Line (DFF) not populating in the Purchase Requisition PDF Report layout (without datamodel report) We are using investment segment number under attribute19 a…
-
On Hand at Requisition CreationSummary On Hand at Requisition CreationContent Hi All, There is a requirement to show On hand availability to buyer before creation of requisition order. Buyer should be…Mayank Pande 41 views 11 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Is it possible to find the Purchase Requisition (PR) based on projects in the approvers User accountSummary: The business wants to see the requisition and the status (Approved, rejected) based on the project filter and approver person further to see the relevant requis…
-
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 11 views 4 comments 1 point Most recent by Srinivas Reddy Reporting and Analytics for ERP -
Bare minimum roles required to view infotile dashboards for Procurement?what are the bare minimum roles required for the user to access an infotile dashboard in "Procurement Area" (Purchase Requisitions and Purchase Orders) I created a intof…mayankthakur 11 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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
-
Existing report to check the details about number of users logged into Supplier portal for SupplierSummary: Is there any existing/seeded report to check the details about number of users logged into Supplier portal for a Supplier. Content (please ensure you mask any c…Sreekanth Kuduvande 31 views 3 comments 0 points Most recent by Ravi Kumar-Oracle Supplier Management
-
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 59 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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 41 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Receipt Creation Date coumn in OTBISummary: Which column in OTBI area can we leverage to get the receipt date information in Self Service receiving. Content (please ensure you mask any confidential inform…Asutosh Mishra 1 view 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Enable Procurement Dashboard under Procurement tab in Oracle Fusion Cloud instanceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 - new 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 12 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 82 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