BI Publisher Reports
Discussion List
-
how to get reservations against shipment line?Summary: if more than one reservation exist against one fulfilment line, delivery detail line splitted based on the reservations created. In this case, how to get the re… -
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
-
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 71 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Please provide SQL query to get UCM file name,owner and upload date based on the UCM pathSummary: Kindly provide me the SQL query to get file name, owner and upload date from UCM based on the UCM path. Need this to create a parameter based LOV for ESS job. '…Lakshmi Bandlamudi 665 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 32 views 3 comments 0 points Most recent by Lucky Sharma 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 42 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM
-
How to query PER_ADDRESSES_F table for employees using BI ReportsSummary: Line Manager is unable to access PER_ADDRESSES_F table and thus is not able to access the report based on this table. As per oracle note 2887292.1, we need to e…Sourav Parbat 71 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management
-
Purchase Order PDF Report with conditional sub templateSummary: We have a requirement for one business unit to issue 4 completely different purchase order PDF's based on shiptolocationname. We have the sub template working w…Claudia M 131 views 5 comments 0 points Most recent by Claudia M Reporting & Analytics for Fusion Service
-
DeleteDelete
-
query to get movement request attachmenti want query to get movement request attachments details
-
Supplier Negotiation PDF Report - ATTRIBUTETIMESTAMP1 -not giving date in CST TZ after conversionSummary: Our requirement is to show DFF Date field in CST Time zone but unable to do so. We understand that we can't modify query to get required date fields in CST Time…
-
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 … -
is there any possibility to customize or copy Standard Purchase Order Dashboard?Summary: How to copy/customize existing Purchase order Over view page (dashboard) for each Business Unit? Content (please ensure you mask any confidential information): …
-
Exporting data to FBDI formatI would like to be able to export data from application onto FBDI format. It looks like this is available for suppliers: https://docs.oracle.com/en/cloud/saas/procuremen…
-
Any table exist in Oracle cloud which store Purchasing Agreement details or Master contract NumberSummary Any table exist in Oracle cloud which store Purchasing Agreement details or Master contract NumberContent Hi Guru's, I am modyfing the PO PDF seeded report and o…
-
In oracle fusion which table locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…Mirza_Adeel 5.5K views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
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 438 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
Purchasing Mapping Set Details tablesSummary: Hi , How Get Purchasing Mapping Sets Details tables to query it in OTBI report Content (please ensure you mask any confidential information): Version (include t…
-
Supplier Negotiation PDF Report Table of Content Font changeWe would like to change the font for table of content in Supplier negotiation PDF. When we select TOC in RTF template and changed font to Calibri and uploaded the RTF in…
-
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 231 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized …Soumya Prakash Parhi 571 views 11 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 240 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…Sai Revanth 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
CMR_PO_ACCRUAL_AMTS_RPT dependency issue while trying to customize Uninvoiced receipt accrual reportHi Experts, We need to add some invoice line level project based columns (project name, task name, project expenditure organization) in Uninvoiced receipt accruals repor…
-
Need to display header and footer for Contract Terms and Conditions in the PO PDF based on BUSummary: Need to display header and footer for Contract Terms and Conditions in the PO PDF based on Content (please ensure you mask any confidential information): Versio…
-
How to customize the BPA/CPA Notification Layout?Summary: We'd like to customize the BPA/CPA mail notification layout. We know purchasing document layout are mostly in the Catalog>Shared Folders>Procurement>Purchasing,…