BI Publisher Reports
Discussion List
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 161 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
Duplicate Count SequenceSummary: In the UI, a specific sequence has one record but upon checking in BI Reports, there are two records with different items but having the same count sequence. Ho… -
Can we add custom parameters to the seeded ESS job Communicate Purchasing Documents?Summary: I'm reaching out to see if anyone has experience customizing the ESS job 'Communicate Purchasing Documents', which is responsible for distributing the PO PDF to…
-
How to query APPROVAL_GROUP_NAME FROM PO_HEADERS_ALLSummary I am looking to get approval_group_name from po_headers_all for BI reportContent Hello, I can see that APPROVAL_GROUP_NAME EXIST IN POR_AMX_ACTION TABLE, but can…
-
Want to get Negotaion number and requistion number in purchase order PDFSummary: Want to get Negotaion number and requistion number in purchase order PDF Content (please ensure you mask any confidential information): Version (include the ver…
-
Equivalent report for Israeli Localization Withholding Tax Certificates Expiry Date reportSummary: Hi, We are in middle of migration to cloud and we are looking to see the equivalent report for the 11i report "Israeli Localization Withholding Tax Certificates…Anand Balasubramanian 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to customize the "Attached Contract Preview" templateSummary: When adding contract terms to any purchasing document, there is an option to attach a document rather than add clauses/templates set up in enterprise contracts.…Gaurav Rochwani 101 views 1 comment 0 points Most recent by Andreea Gel-Support-Oracle Enterprise Contracts
-
How to club PO lines at RTF level without modifying the data model?Summary: Hello team, We have a requirement to club multiple PO lines into one (assuming the same item number) as supplier wants to see only fewer lines and consolidated … -
How to remove or customize "Attached Contract" template from PO pdf / DocuSignSummary: The "Attached Contract" standard text within the PO pdf when using uploaded terms is misleading when using DocuSign to sign and communicate contracts as the att…
-
Can Subject of a Negotiation Award Approval Bell notification be customized?Content Can Subject of a Negotiation Award Approval Bell notification be customized? Like have supplier name and description? Version Oracle Fusion 13, 19C
-
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… -
I need to design a report to export data for Inactive ItemsI need to design a report to export data for Inactive Items, please help to provide SQL to acquire column data that we need or official Inactive Items Report. Want to pr…
-
Purchase Order PDF not caching for previous revisionSummary: Hi all, Experiencing a peculiar issue regarding the PO PDF in OFC. My understanding is that when a PO or change order is approved, this kicks off a job to run t…
-
Is there is a way to export the pdf of PO and purchase agreement as word document?Summary: Is there is a way to export the pdf of PO and purchase agreement as word document? Content (please ensure you mask any confidential information): Version (inclu…
-
How to display supplier mobile number in purchase agreement pdfSummary: I cant find mobile's number pf supplier contact in purchase agreement pdf data model, i just found the phone Content (please ensure you mask any confidential in…
-
Does anyone have query in getting the mid-level Purchasing Categories?Hello, does anyone have ready query to get the list of mid-level Purchasing Categories? (Or even not an exact query but something similar for reference. Business user wa…
-
Does the ERP 24B version have a Pick Slip Report, contains status information, GIN (Issued) Date?Summary: Does the ERP 24B version have a Pick Slip Report, to view pending status and success data with GIN Date (Issued) and Pick Slip Date information? Content (please…
-
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 51 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…
-
Need PVO details from tables INV_UOM_CLASS_CONVERSIONS,INV_UOM_CONVERSIONSSummary: Hi Team, We need to extract complete data from INV_UOM_CLASS_CONVERSIONS,INV_UOM_CONVERSIONS tables and send it aws . Can you please help us with PVO details Co…
-
Join ConditionSummary: Hi All, Can anyone suggest me how to join FND_LOOKUP_VALUES table with the order management module table in fusion? Content (please ensure you mask any confiden…Md Mujtaba Alam 21 views 5 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
Showing Text Message in dependent Flexfield or Popup MessageSummary: Hello Dears, I tried to show a text message in a dependent flexfield and selected a display type as TextArea as shown below When I selected a value from the par…
-
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin…
-
Fusion Open Purchase Order as on Certain Past DateSummary: Is there a report or a way to build report which will show Open Purchase Order as on Certain Past Date. Content (please ensure you mask any confidential informa…
-
How to check the error message in Manage PO when funds status is failedHi All, Could you please let us know where does the error message of Funds Status gets stored. The ask is to show the Error message of an PO when it's Funds Status is fa…Naresh313 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
VAT Tax on the Purchase Order through VertexHi, Procurement team has leveraged Vertex tax configuration engine and applied VAT Tax on all five lines in a Purchase Order. Now, the question is to know the feasibilit…