BI Publisher Reports
Discussion List
-
Can't found the "objType" deep link for SCM - Confirm Pick Slip pageWe seeking to create a deep link that connects between BI report and the "Confirm pick slip" page from the Inventory management page, also we searched through this docum…Mohammad Hussein 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
What RTF template to use to create a custom Supplier and Buyer Negotiation PDFSummary: Business needs to make changes to the Supplier and Buyer Negotiation PDF Change the texts (wordings) Move/remove tables Move/Remove section We can update the co… -
Manage Negotiation: Supplier Transaction HistorySummary: We are trying to create a canvass sheet for the client and we would like to get this supplier information from the Transaction History > Purchase Order (please … -
REST API for Purchase Agreements DFFSummary: We are looking for a REST API for getting DFF values on Purchase Agreements. we have already got REST API to fetch purchase agreement details but unable to find…
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
Storing Historical Pricing ChangesSummary: Looking for all options for storing and referencing historical pricing changes in the Pricing Administration Application? Content (please ensure you mask any co…
-
After a change order is created, is there a table where previous versions of taxes are stored?We are trying to create a report for when a change order is created in the Purchase Order (PO) to change the tax and it gets approved. We want to see what the tax is aft… -
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 64 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
REST API for verifying whether a Purchase Order includes a Change OrderSummary: REST API for checking PO has Change Order. Content (please ensure you mask any confidential information): Hi, Is there any REST API available for verifying whet… -
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 42 views 3 comments 0 points Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
Need an SQL Query to find Invited Supplier information for newly created NegotiationSummary: Need an SQL Query to find Invited Supplier information for newly created Negotiation Content (please ensure you mask any confidential information): Invited Supp… -
ESS job is running longtime in JobsetWe have created a Jobset with 2 ESS jobs. First ESS Job is completed fast and second ESS Job is running longtime and not completing. When we run the second Job independe…Lakshmi Bandlamudi 32 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for SCM
-
Tabla de Oracle Cloud para sacar el bill-to y ship-to location del proveedorDears , Please help me with the Oracle Cloud Table to get the bill-to and ship-to location from the supplier.
-
What is the function or package to get PO Line's Requested Delivery Date in PO PDF?Summary: In both PO PDF (Purchase Order PDF Report) as well as the Notification for approval (Purchase Order Notification Report), we would like to include each line's R…
-
How to make content of Email notifications start from left?Hi Experts, We are trying to make the content of Sourcing Email Notifications start from left by customizing the seeded template. We have tried doing it through layout a…
-
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …Rajat N 21 views 1 comment 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for SCM
-
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…
-
Requirement to add special instructions to a PDF report based on organization of a PO.Hi We have a requirement to add special instructions to a PDF report based on organization of a PO. Currently we have 20+ organizations. Which will increase in the futur…Mazher Shaikh 91 views 2 comments 0 points Most recent by Mazher Shaikh Reporting and Analytics for SCM
-
Sync INV_RESERVATIONS SaaS table to PaaS tablesWe have a use case where we need the data from INV_RESERVATIONS SaaS tables to be synced to PaaS tables. The synced data is then further used in an extension that is dev…Abhinav_Vashistha 33 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
which privilage is needed to run 'Item Txn with Average Cost report'Summary: Hello experts , Our customer wants to give access to the user for 'Item Txn with Average Cost report' . They don't want to give the entire access of inventory s…Shalini Singh-Oracle 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Extract Ship Method Data for Integration with WMSSummary: Hi Everyone, We are looking for a way to extract ship method data (Freight Carrier, Service Level, Mode of transport, Organization Assignments and DFFs) from Or…
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 1.5K views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 1 view 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Regarding reading the doc file in UCMHi Po has an doc attachment in UCM , can we read doc attachment from UCM in BIP Report ? Thanks
-
Hi All,I want Release_num column from PO_RELEASES_ALL table which is present in Oracle R12 equivalent in fusion ?In fusion we don't have any PO_RELEASES table at all. Kindly he…
-
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…