BI Publisher Reports
Discussion List
-
How to change PO e-mailSummary: We are trying to change the body of PO e-mail. Instead of the word "Implemented" the customer wants the word to be "Created" Content (please ensure you mask any… -
Response from Supplier Portal and Surrogate Response in oracle fusion.Summary: Hi Can you please help on the Response from Supplier Portal and Surrogate Response data are stored in which oracle table. It is possible to provide the table na…
-
Logic to separate in transit shipment on a purchase order from BIP reportSummary: Business requirement is to finally close a purchase order but system is not allowing due to in transit shipment. In report we have already added the logic for n…
-
Print PO PDF in multiple languageHi team, We have requirement where for Germany we have to print PO PDF in german and english language both. In German language for local suppliers and in english for for…
-
Can a dynamic hyperlink be programmatically embedded within text in BI publisher report?We have a requirement to print attachments links in PO PDF report. The report should have the attachment name as a text, upon hovering over the text the hyperlink to the… -
Reports for Product ManagementWhat are the Reports available for Product Management and from where we can see all that.
-
Need DocuSigned PO PDF storage details in Oracle Fusion for automation to external systemSummary: We are implementing DocuSign Signature functionality for our client, who requires all signed PO PDFs to be automatically stored in a separate system. To enable …
-
Is there a feature to calculate time spent per stage during the scoring process in Sourcing?Hi, Community, I am exploring the capabilities of Oracle Fusion Cloud Sourcing and would like to know if there is a feature that allows tracking or calculating the time …
-
PO PDF not displaying lines intermittently.PO PDF not displaying lines intermittently, it stops displaying lines for the first go and is available when PO is re-queried. We have custom PO PDF template. -
PO E-mail Subject & Body Template changes not reflecting when the PO Print PDF is generatedSummary: I have made changes to the RTF template for Purchase Order E-mail Subject and Purchase Order E-mail Body template and uploaded it on to the application. But whe…
-
PO Change order template location in fusionSummary: We are looking Change order view PDF template but unable to get the location under reports Content (please ensure you mask any confidential information): Versio…
-
Query to get Purchase order Versions with Related RequisitionSummary: I am trying to develop a BI Report where I can get each purchase order versions with related requisition , which means if a PO-1 Version 0 is created based on P…
-
How to join INV_TXN_REQUEST_HEADERS with INV_TXN_REQUEST_LINES?Summary: I want to join INV_TXN_REQUEST_HEADERS and INV_TXN_REQUEST_LINES, so I use HEADER_ID as a join key. But execution data is not be 1=1 low. Which column should I …
-
How to call pages from different moduleSummary: Hi All, I am working on a Idea to call pages from different modules. Here is how it should work Navigation>Order Management>Manage fulfilment lines. On this pag…Manohar Cheelangi Swamy 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Which SQL table stores expected receipts for interorg transfers?Summary: I'm writing an SQL and need to retrieve the expected receipts for interorg transfers. In order words, the interorg has been created at the source organization a…
-
What is the key column for joining WSH_DELIVERY_DETAILS and DOO_ tables?Summary: I would like to join WSH_DELIVERY_DETAILS with DOO_HEADERS_ALL, DOO_LINES_ALL or DOO_FULFILL_LINES_ALL. Could you teach me the key column, please? Content (plea…
-
Can we create 2 User Defined Dependent List of Values for ESS Job Parameter?Summary: Need to create an ESS job for a BIP report and a parameter will get autopopulated based on value we select for other ESS Parameter on which the parameter is dep…
-
what is the table for Movement Requests information?Hello, I would like to get some movement requiests data for report. on the report, I need quantity and subinventory colimns but I couldn't find them in WSH_PICKING_BATCH…Misato Yoda 11 views 2 comments 0 points Most recent by Santhosh Mani - Trinamix Inventory Management
-
To apply a bursting logic in Communicate Purchasing Documents Report to specific BUSummary We need to add the bursting logic for Communicate Purchasing Documents report to send the Output to many email id's including the supplier email,and is applicabl…
-
Is it possible to know the parameters used in Supplier Negotiation PDF report?Summary: We are developing a custom report for Supplier Negotiation PDF report. We want the user to be able to select the custom template for Supplier Negotiation PDF re…
-
Need clarification on customizing Negotiation Layout of the standard Supplier Negotiation PDF ReportSummary: Need clarification on customizing Negotiation Layout of the standard Supplier Negotiation PDF Report. Content (required): 1. Font change is not reflecting in th…
-
Query to find unaccounted receipt in fusionSummary: Query to find unaccounted receipt in fusion Content (please ensure you mask any confidential information): Hi Team, We are creating a custom report for PO and R…
-
PO_BIP_HELPER.get_ship_to_cust_addressSummary: Hi Team, Could you please share logic/query of PO_BIP_HELPER.get_ship_to_cust_address function, this function is used for to get ship to address of PO. Please s…
-
How to know and then set the PO Approval limits for all the Approvers in the System?Summary: We are currently using Supervisory Hierarchy for PO Approvals . There is a requirement to find out the PO Approval limits of all the Approvers in the system and…
-
We are not able to make any changes in PO view PDF template.Hi Team, We have a requirement to add project-related information to the standard View PDF report on the Purchase Order. We made the necessary changes, but the updates a…
-
How to get Item on hand quantity for backdatedBusiness wants to know the Item on hand quantity balance for the backdated, for example, the user wants to extract the on hand for the previous year i.e. Dec month 2024.…
-
Supplier Registration or Profile Change Approval DetailsContent Hi , I want to prepare a SQL which will have supplier and approver details. I know we have below workflow and supplier tables: fa_fusion_soainfra.wftask fa_fusio…Nidhi Chhajed 228 views 4 comments 1 point Most recent by Immanuel Aruldoss Reporting and Analytics for SCM
-
Want to Change seeded datamodel of Award Approval Notification Report under sourcingSummary: Hello, I want to chnage Seeded data model of Award Approval Notification Report which is Award Approval Notification Data Model when i click on it for opening i… -
How to Split Rows in Excel BI Publisher Output (Nested Rows Inside One Row)Sure, here's a more polished version of your message: Hello Community, I am working on a scenario where I need to display data in multiple rows within a single row in an…
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…