Procurement
Discussion List
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec… -
Is it possible to create or move the DFF fields under Product & Servies Tab in Supplier PageSummary: Business requirement is to create or move the existing Dff fields under Product & Servies Tab in Supplier Page. Please find the below screenshot for more detail…Chandana Priya-Oracle 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Prompt LOV restriction in OTBI according to user Business unit data accessSummary: We are trying to restrict the prompt LOV which returns BU names that currency configured in the system. But we want that when a particular user will try to run …Baishakhi 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to Split Rows in Excel BI Publisher Output (Nested Rows Inside One Row)Sure, here's a more polished version of your message: Hello Community, I am working on a scenario where I need to display data in multiple rows within a single row in an…
-
Query to get PO Change History details which have Been Purged.Summary: There is a requirement by the business to fetch the details of the archived history for POs Content (please ensure you mask any confidential information): To re…
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
Configure Prompt acting like a nested query?Summary: How to configure Prompt acting like a nested query? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you to…
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 928 views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 24D…Ramamurthy Shankarachetty-Oracle 14.4K views 53 comments 40 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
Locator Name in Receiving - Purchase Receipts Real Time Subject AreaSummary: We have an OTBI report built using the subject area "Receiving - Purchase Receipts Real Time" and we have almost all the required columns except for the Locator…Rahul_M8SG8 22 views 4 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
Adding more contract variation details (list of updated things) to Approval of Contract NotificationSummary: Adding more contract variation details (list of updated things) to Approval of Contract Notification Content (please ensure you mask any confidential informatio…Muhammad Amir Imran 41 views 2 comments 0 points Most recent by Muhammad Amir Imran Enterprise Contracts
-
OTBI Report for collaboration messaging historySummary: User requires an OTBI report scheduled on a daily basis for the errored out Purchase Orders and Invoices to keep him notified. Can you please suggest the subjec…Sumiran Maheswari 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
Purchase Orders Number and Requester NameSummary: What subject area to be used to create a report showing PO number and the requester name from the PO line. Content (please ensure you mask any confidential info…Ahmed Maher Kadeh 15 views 2 comments 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 338 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want…Abdur Rehman 14 views 2 comments 2 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI…Rajat Pandey 21 views 6 comments 0 points Most recent by Rajat Pandey Reporting and Analytics for SCM -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 31 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
Report on approval workflow conditions and actionsSummary: Requiring to report on requisition and PO approval workflow rules setup (conditions and actions) Content (required): Is there a delivered or would anyone be wil…Bernadette Dorris 41 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM
-
Behavior in PO_HEADERS_ARCHIVE_ALL recordsSummary: Behavior in PO_HEADERS_ARCHIVE_ALL records Content (please ensure you mask any confidential information): I am looking for an explanation of PO_HEADERS_ARCHIVE_…KDR 23 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …
-
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 38 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
I am looking to create an OTBI dashboard for RMAsSummary: I am looking to create an OTBI dashboard for RMAs. Want to display error messages and create alerts/agents. Content (please ensure you mask any confidential inf…sanjam1130 1 view 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeSummary: Hi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area … -
Custom Report Printing PO Terms and ConditionsSummary: How to Print PO Terms and Conditions? Content (required): Is there a way to add the Terms and Conditions attached to PO to a custom report. I've checked the sta…Mr H 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to filter out duplicate rows with same values in BI report.Summary: I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_…Rishabh702 11 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM