BI Publisher Reports
Discussion List
-
Can't create dynamic hyper link in PO approval notification template.Summary: I am trying to create a hyper link that takes the po number () in the po approval template and pass it to a parameter in another custom report I created . That'…KirolosMagdy 37 views 1 comment 0 points Most recent by KirolosMagdy Reporting and Analytics for ERP -
How to generate Open Purchase Order report in oracle fusion?Summary: Content (required): Open Purchase Order report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) …
-
LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is appliedSummary: LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is applied Content (please ensure you mask any confidential information): When a c…
-
PO email sent to supplier customizing template not workingHi, I customized the following BIP templates : PurchaseOrderEmailSubjectLayout and PurchaseOrderEmailBodyLayout. I did the setup as shown on screen "BIP Setup" (.doc att… -
How to create report future "approver details" of requisitions in "Pending Approval Status*Summary: Customer requests a report listing future approver details of requisitions with “Pending approval” status. Content (required): The intent is to answer questions…
-
Some users are not able to Download Custom PO PDFSummary: Some users are not able to Download the PO PDF and clicking View PDF. User have PO Buyer role but still not able to download. Below is the error: "The file was …
-
PO Work Confirmation report with Invoice detailsSummary: PO Work Confirmation report with Invoice details Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
Which table stores the PO fund check information?Hi all, I'd like to create a report about PO line funds check. May I know which table stores the information about PO funds check status? Thanks in advance!
-
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 74 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…