Business Intelligence
Discussion List
-
PO Work Confirmation report with Invoice detailsSummary: PO Work Confirmation report with Invoice details Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
PO email for multiple reportSummary: We are having business use case as: As per customer requirement we have created 3 reports for PO based on different category. All 3 reports are having different… -
PO PDF in Language of SupplierSummary PO PDF in Language of SupplierContent Hi, I'm looking for the functionality to have the PO PDF print depending on the Supplier (address) language. Currently I've… -
How to create value set with fixed table base data and some fixed values hard coded given?Summary: I want to create value set for purachasing in which i want to pick requsition number and with that i want to also add one fixed data "Not Applicable " which als…
-
Locate an EL Expression Value for inputComboboxListOfValuesSummary: Locate an EL Expression Value for inputComboboxListOfValues Content (please ensure you mask any confidential information): Hi , We have a requirement to write E…Hitha Harikumar 21 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How to pick po line level attachment columnHello. I want to pck an column in custom BI report of PO line level attachment on serial number attachment sign is coming when we click on that new pop up opens in which…
-
Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tabSummary Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tab What formula does the system/dashboard uses to calculate the On Time Delivery in …Maria Angelica Mendoza 22 views 2 comments 0 points Most recent by Maria Angelica Mendoza Purchasing -
Extracting Requisition and Purchase Order Rule Details defined in BPMSummary Extracting Requisition and Purchase Order Rule Details defined in BPMContent I am looking if anyone know if there is a way to run a query/report or table name wh…
-
How to get data access for a specific user through the REST APISummary: Through the REST API, we need to obtain from a given user which BUs are granted and what roles are assigned. We need to retrieve these details depending on the …
-
How to get last issued Document Number for a bank account through REST APISummary: We need to create a Manual payment through Integration (REST API). In order to create a manual payment, we need to send Payment Number in the payload. We would …
-
After a change order is created, is there a table where previous versions of taxes are stored?We are trying to create a report for when a change order is created in the Purchase Order (PO) to change the tax and it gets approved. We want to see what the tax is aft… -
OTBI Dashboard to search purchase orders and drill down to view purchase order detailsSummary OTBI Dashboard for Line of Business Users or AP Specialists to search purchase orders and drill down to view purchase orders using deep linksContent Purchasing h…
-
Do we need to apply any localization patch for 24B upgrdationSummary: Do we need to apply any localization patch for 24B upgrdation Content (please ensure you mask any confidential information): Version (include the version you ar… -
What is the Rest API to read and update Assessment level Descriptive Flex fields?Summary: We have descriptive flex fields configured at the Assessment Level (POQ_ASSESSMENTS) in Supplier Qualification. We need the REST API to read and update one of t…Anirban Nandy 61 views 3 comments 1 point Most recent by Asit Rout-Oracle Supplier Qualification Management -
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T…
-
How to enable line of business users to view purchase order informationSummary How to enable line of business users to view purchase order informationContent Business Case Line of business (LOB) users need to view purchase order details wit… -
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…Priya Ranjan Jamuar 31 views 2 comments 0 points Most recent by Priya Ranjan Jamuar Reporting and Analytics for SCM
-
Procurement DashboardSummary Out of Box Procurement Dashboard in Oracle Procurement CloudContent Hi Experts, I am looking for the Procurement Dashboard (out of the box (Update 20A)), have se…
-
How to Customize the Supplier Audit Report ?Summary: How to Customize the Supplier Audit Report ? Content (please ensure you mask any confidential information): Hello I did one Supplier Bank Account Change and aft…
-
Syntax for Item validationSummary: Syntax for Item validation during creation Content (please ensure you mask any confidential information): Version (include the version you are using, if applica… -
Users with Purchase Analysis role have access to Supplier Subject areaSummary: Business wants users to have access to Procurement - Purchasing Real time subject area in OTBI. But granting the Purchase Analysis duty role enables access to S…
-
Can we have serial and parallel approval rule for same stage in Requisition Approval RuleCurrently as per Business Requirements, we have multiple BU's wherein in one particular BU the approval flow is serially and for other BU the approval flow is parallely.…
-
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 21 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 43 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 …