BI Publisher Reports
Discussion List
-
Custom PDF template not working on View PDF button in 25DSummary: We had a custom RTF report for PO PDF and it was working fine.. Now after 25D when we click on View PDF button in PO screen , report is being generated in stand… -
Query for PO line ordered amount and line total amount based on Function for PO PDFSummary: PO PDF function is required for PO line amount and PO line total amount. Content (please ensure you mask any confidential information): On PO PDF, the PO line's…
-
PO Custom report with Total Currency Converted Ordered AmountSummary: Content (required): I am trying to write the custom query to get the PO total orderd amount , where I am using the" PO_BIP_HELPER.get_ordered_display (PHA.PO_HE…
-
How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI ReportSummary: How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI Report. Which parameters need to pass to this function. Content (please ensure you mask …
-
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin…
-
how to extract One Time location entered in Ship to location on Purchase Orders using BIP reportWe want One Time location entered in Ship to location on Purchase Orders. Where it is stored? How we can extract using sql query.
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da…Tapas_Sathua 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25DSuresh Kannan Saminathan 25 views 2 comments 2 points Most recent by SankarBalu Reporting and Analytics for SCM
-
The .xls output format is missing on Scheduled process Advanced Options tabHi Community, When we try to run a BIP report from Scheduled Process and use the Advanced Options tab to select Output format, the .xls format is missing and only mhtml …Ankana Bhattacharya 41 views 1 comment 1 point Most recent by Andrada-Oracle Reporting and Analytics for SCM
-
Deep Link for AP Invoice within BI ReportSummary: We are wanting to build a BI report (SQL based) from where we can navigate to AP Invoice page in (Manage Invoice) page or (Edit Invoice) page. We are finding in…
-
ESS Job for BIP Report – Error During Scheduled Process ExecutionSummary: Hi Team, We have created an ESS job for the BIP report and assigned the appropriate ESS privilege to the custom role. However, when a user with this role attemp…
-
Classic Template for Purchase Order Implemented FYI NotificationHi Team, We have a request to modify the template for the Implemented Document (Purchase Order) – FYI Notification. When we try to open and edit the standard template ma…
-
Need Report to show Change Details of a BPA Change OrderSummary: Looking for a report to see what details were changed in a BPA or PO Change order. Please advise if there is any OTBI report or table to create BIP report. we c…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 151 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM
-
Unable to Extract External Cost Factor (ECF) Values for Supplier Responses Using SQLSummary: We need Oracle to confirm the official and supported method to extract External Cost Factor (ECF) values for supplier responses, specifically the REST API endpo…
-
How can I determine which weekday corresponds to DAY_START_NUM and DAY_STOP_NUM(ZMM_SR_PATTERN_DTLS)Hi everyone, I have a question regarding the ZMM_SR_PATTERN_DTLS table, specifically the DAY_START_NUM and DAY_STOP_NUM columns. In my case, I have: DAY_START_NUM = 1 DA…Andriampeno Odilon 11 views 1 comment 0 points Most recent by Andriampeno Odilon Reporting and Analytics for SCM -
Custom Purchase Order PDF not attached in Email notificationSummary Custom Purchase Order PDF not attached in Email notificationContent Hi, We have developed a custom PO PDF, NOT Customised but a custom one.The Custom report is a…User_2025-02-06-19-27-02-651 234 views 7 comments 0 points Most recent by ASHWINI_9876543678 Purchasing -
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 155 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM
-
Suppress PO PDF attachment on PO email to suppliersSummary: I'm currently working with a customer who does not want to send the PO PDF attachment to the PO email that is communicated to their suppliers. Is there a way to…
-
Query to retrieve Trade Operation and corresponding PO detailsSummary: Content (required): Hi, There is a requirement to create a report that displays the following columns; Trade Operation number Trade Operation Name Created By Us…
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…MayurM 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to make the report link variableSummary: Sandbox-How to make the report link variable Content (please ensure you mask any confidential information): Hi Team We have customized a report and use sandbox …Carol Tang 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query…Deepak Bhatt 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …MayurM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which Oracle table is used to store the valueProduct Line Description under Product Line InformationSummary: Hi @everyone Can anyone have any idea that which Oracle table is used to store the exact value of below Product Line Information in the backend and how it shoul…Deepak Bhatt 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need query for Change Order History TabSummary: I need query to extract these columns as mentioned in the screenshot.Ramsha Zameer 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Where We Can Get Schedule Description From Tables ? For Complex POCan you please Advise Where Schedule Description of Complex PO Stored in Tables Right now we have one lines that splitted to different schedules with different Descripti…