BI Publisher Reports
Discussion List
-
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 111 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 32 views 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive 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 2.1K 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 2 views 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 483 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 702 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 -
Report on approval workflow conditions and actionsSummary: Requiring to report on requisition and PO approval workflow rules setup (conditions and actions) Content (required): Is there a delivered or would anyone be wil…Bernadette Dorris 41 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM -
How to query PER_ADDRESSES_F table for employees using BI ReportsSummary: Line Manager is unable to access PER_ADDRESSES_F table and thus is not able to access the report based on this table. As per oracle note 2887292.1, we need to e…Sourav Parbat 71 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management -
Purchase Order PDF Report with conditional sub templateSummary: We have a requirement for one business unit to issue 4 completely different purchase order PDF's based on shiptolocationname. We have the sub template working w…Claudia M 143 views 5 comments 0 points Most recent by Claudia M Reporting & Analytics for Fusion Service -
DeleteDelete