BI Publisher Reports
Discussion List
-
Buyer planner group summaries query forSummary: In Buyer Planning we have plan information along with Group Summaries. Can someone help us to provide the sql query or tables where group name for that supplier…balla Bhaskar 18 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle Supplier Management -
Award Notice PDF report as an email attachment to this same notificationSummary: We have a requirement in Fusion to enhance the award approval notification process. Currently, when an award approval notification is triggered, an email is sen…
-
How To restore Deleted Folder Under Shared Folders Within BI PublisherSummary: One of the users deleted a folder under Shared Folders→ Custom. Please let us know how can we retrieve the deleted folder Content (please ensure you mask any co…Susmitha Arepally-Oracle 305 views 2 comments 0 points Most recent by User_Y01RO Reporting and Analytics for SCM
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…Sarath Lakshman 11 views 7 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Any suggesstion to show the requester's department for buyers?Summary: The new redwood RSSP page does not have any information about the requester department and the new requistion PDF and notification also does not have any inform…
-
How to change the Time zone in the Negotiation Invitation emailSummary: Negotiation email invitation time reflected to users who don't have access to the system or to those email added in the Additional email field in the Negotiatio…
-
We need a report to identify all the users who have delegation set up for HCM/Procurement Approvals.Summary: We need a report to identify all the users who have delegation set up for HCM/Procurement Approvals even if that user don't have a approval notification transac…Sita Rami Reddy 291 views 3 comments 0 points Most recent by Melinda Germann-Oracle Self Service Procurement
-
Changes to PO not reflecting in PO PDF DocumentSummary: Hi, I have a PO that was approved. We then submitted a change order to change the deliver to location. This has also been approved. However the PO PDF document …
-
Query to fetch all the receivables credit memo along with origi9nal transaction detailsSummary: Need to develop one report to extract data for prior period of Oct-24. For all the receivables credit memo along with original transaction details for only nomi…
-
Custom PDF template not working on View PDF button in 25DSummary: We had a custom RTF report for PO PDF and it was working fine.. Now after 25D when we click on View PDF button in PO screen , report is being generated in stand…
-
Invoice Details Not Displaying in PO PDF - View PDF option (Fusion 25D)Hi Team, We are customizing the PO Print report as per the customer’s requirements. As part of the enhancement, we are trying to display AP Invoice details on the PO Pri… -
Receipt Number field blank on OTBI report from Procure to Pay Subject AreaSummary Receipt Number field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, we built a OTBI report based on "Procure to Pay" subject area, receipt … -
We want to stop sending this negotiation pdf attachment in email to suppliersWe have a requirement. We want to stop sending this negotiation pdf as attachment to supplier and all invitations to supplier by email must go without attachments. Can w…
-
I need an sql query where I had to fetch the main details of Requisition when it returned to buyerSummary: SQL query to get the details of requisitions returned by Buyer Content (please ensure you mask any confidential information): I have fetched all the details but…
-
How do I get all the issues listed out for "Incomplete POs"Summary: I need the ability to get a report out of Oracle Fusion showing me all the issues I have on a PO, line, locations, and distributions. I can click on each PO and…
-
Negotiation Number Hyperlink – Deep Link to Negotiation Details Page Not Working.Summary: Negotiation number hyperlink is not redirecting to the corresponding negotiation details page. Content (please ensure you mask any confidential information): In…
-
RFQ Supplier notification email attachmentHello Everyone, I am working on Oracle Fusion Sourcing (Procurement). When an RFQ is submitted and published, the system sends an invitation email to the supplier with a…
-
Need Report to show Change Details of a BPA Change OrderSummary: Looking for a report to see what details were changed in a BPA or PO Change order. Please advise if there is any OTBI report or table to create BIP report. we c…
-
Unable to find PartySiteID received in EDI850 payload in backend CML Log tables for CMK Errors.We have a requirement to display the 'PartySiteId' and 'AccountSiteUseId' fields—present in the Purchase Order Inbound EDI payload—in the Custom EDI850 Error Report when…Manish Maheshwari 21 views 3 comments 0 points Most recent by Munish Kumar Mittal-Oracle Reporting and Analytics for SCM
-
report only returns current live inspection dataWe have developed an Inspection Summary Report in Oracle Fusion (BI Publisher / OTBI) to retrieve inspection history for all items in our inventory organizations. The re…Patrick Chrabieh 2 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
Behavior in PO_ATTRIBUTE_VALUES tableSummary: Behavior in PO_ATTRIBUTE_VALUES table Content (please ensure you mask any confidential information): My question is regarding the PO_ATTRIBUTE_VALUES table. Thi…
-
Ability to have continuous page number and total page number in the PO with contract terms PDFSummary: One of the requirements for the PO and Agreement PDFs is to display the page number along with the total number of pages (e.g., Page 1 of 10) in the document fo…
-
Can we create a separate queue for some priority processes within the ESSSummary: We have few priority requests which needs to run in the system as these are dedicated for patient care , is there a way we can create a new ESS manager to run t…
-
Notification email to Procurement Manager on pending requisitions and purchase ordersSummary: We have a requirement to send the list of Requisitions pending approval as a weekly email notification with few details such as ( Requisition Number Requester N…
-
SQL Query to fetch Negotiation Lifecycle ActivitiesSummary: Hi Experts I am trying to find the tables to fetch negotiation lifecycle activities particularly below columns Technical Evaluation- Close Date Bid Opening Date…
-
Custom report to get Available to reserve column in Inventory managemntHi Team, We have a requirement to get a custom report where Available to reserve column should have the below formula Available to Reserve equals the quantity on hand mi…
-
How to Query the Available to Transact and Available to Reserve Quantity of an Item in an inventoryI need a query to get the Available to Transact and Available to Reserve quantities of an item in inventory. I request you anyone can help on getting a query. Thanks in …
-
Report to extract Review Item Supply and Demand UI detailsSummary: Hi Team, Need to build a report to extract the Review Item Supply and Demand UI details, but couldn’t find the exact schema details to do the same. Can anyone p…
-
BI SQL query to get the Review Item supply and Demand in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data …Umamaheswara Reddy Karri 56 views 4 comments 2 points Most recent by Alon Hadar Tamir Reporting and Analytics for SCM