BI Publisher Reports
Discussion List
-
what is the name of data model reponse PDF report in the OTBISummary: what is the name of reponse PDF report in the OTBI Content (please ensure you mask any confidential information): Version (include the version you are using, if… -
Need to know table column to fetch status of Associated Collaboration Documents on supplier siteSummary: Hi All, Business wants to have a report where they can see whether a supplier site is enabled for B2B communication and if yes, what is the status of each colla…
-
How to derive Inventory Organization on an Expense PO Line through REST APISummary: We have a client requirement for creating Expense Purchase Orders in Oracle via a REST API integration. While creating the PO Line, the API Payload needs a valu…
-
How to know whether the PO are archived?Hi Experts, I'm drafting a SQL for a report that our end users will be able to retrieve their approval history. While there are 2 tables having the PO information: PO_HE…
-
logo in Purchase order email body template is not included in the email bodySummary: Hi All , Greetings of the day! we have customized the RTF template for Purchase Order email body template. We have included the Company logo in the custom Templ…
-
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 get document download time in purchase agreement PDFWe need to appear the date that the agreement is printed from the system, how to show the document download time? ** sysdate is not work as wanted since after approve th…
-
Generating Sheet name dynamically in excel from xml tag in rtf word with PublisherSummary: in publisher while creating an rtf in word for a multi tab excel is it possible to generate sheet name dynamically from source After loading xml, should be able…
-
REST API to fetch Invoices of the POSummary: REST API to fetch Invoices of the PO Content (please ensure you mask any confidential information): We have a requirement to fetch all the Invoices of given pur… -
BPM Worklist : Is there a way to retrieve last 18 months approval history in procurement moduleSummary: Hello All, Need your expert advice, we are aware that oracle will purge BPM notification after 30 days of its completion, is there any way we can extract purged… -
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…
-
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 70 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…
-
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… -
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…
-
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 31 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…
-
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 22 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…
-
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…
-
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…
-
Confirm ReceiptsSummary: Confirm Receipts Content (please ensure you mask any confidential information): How to modify the notification send to requestor when confirm receipts is genera…
-
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 …