BI Publisher Reports
Discussion List
-
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 12 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…
-
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n…Ellen Manthei 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Bursting is not getting triggered after customizing the standard Data Model of PO PDFSummary: We want to send a PO PDF to certain SFTP Location. But when we customize data model of PO Print Document communication. The Bursting Logic is not getting execut…
-
How to link RCV_SHIPMENT_LINES and CST_TRANSACTIONSHi We need to print Consumption Transactions Information: Purchase Order Receipt Number Consumption Advice Work Order Number Work Order Transaction Type Right Now we don…
-
Table and Column details for "Agreement Amount Changed" in the CPASummary: We are developing a BI report for Change order of CPA (Contract Purchase agreement). Client to capture the Individual change order amount that is the Agreement …Surjith N K-Oracle 33 views 1 comment 1 point Most recent by Phanindra V Gollapalli-Oracle Purchasing -
Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI AnalysisSummary Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI AnalysisContent Hi All, Is there any folder/dimension where can we find the No… -
I Create a Custom Negotiation but when I select it to use the report comes emptySummary: I Created a Custom negotiation report, I put a custom layout in the path Tools > Report and Analytics > Shared folder > Procurement > Sourcing > Supplier Negoti…
-
Query to pick sourcing scoring statusSummary: Hello, I want table or query in which sourcing status is picked in collaboration team members section team mebers are coming in ACTION tab there is an option co…
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…Parth11 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM