BI Publisher Reports
Discussion List
-
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 95 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.6K 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…
-
How to add page break for a HTML output of BIP Report. Please Advise.Summary: Page Break not working in HTML output of BIP Report. Content (please ensure you mask any confidential information): Version (include the version you are using, …Satya.Munagala 21 views 4 comments 0 points Most recent by Satya.Munagala Reporting and Analytics for SCM
-
Report Bursting CapacitySummary: Hi Team, We have a business requirement to send an email with a PDF attachment via bursting. Here are the specifics: Delivery Method: Email via Bursting Attachm…Sai Sreeram Gundepudi 11 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Reconciliation report purchasing to GLSummary: Reconciliation report purchasing to GL Content (please ensure you mask any confidential information): Hi Could you help me with the following question please. I…Jazmin Saldierna 21 views 2 comments 0 points Most recent by Venkat Jagan Pakala-Support-Oracle Costing
-
How to extract the data of Charge accounts and charge id in oracle fusionSummary: Hi Team, How to extract the data of charge accounts and account id in oracle Fusion Content (please ensure you mask any confidential information): Version (incl…
-
Need Standard Report or Table details for PO approver and each approver limit detailsSummary: Need Standard Report or Table details for PO approver and each approver limit details Content (please ensure you mask any confidential information): Hi, We want…
-
Is it possible to have a DFF the same function as the Text Category in PO attachment?Is there any other way to have a functionality wherein the user can add text in the PO PDF template, same as the Text Category in PO attachment?
-
Optimal way to join WSH_DELIVERY_DETAILS and INV_TRANSFER_ORDER_LINESSummary: Hi Team, Is there any other way to join WSH_DELIVERY_DETAILS with INV_TRANSFER_ORDER_LINES which will give optima execution plan. We are now using the below que…Baswanth Kumar Reddy-Oracle 443 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
how to get reservations against shipment line?Summary: if more than one reservation exist against one fulfilment line, delivery detail line splitted based on the reservations created. In this case, how to get the re…
-
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 31 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 72 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Please provide SQL query to get UCM file name,owner and upload date based on the UCM pathSummary: Kindly provide me the SQL query to get file name, owner and upload date from UCM based on the UCM path. Need this to create a parameter based LOV for ESS job. '…Lakshmi Bandlamudi 587 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM