BI Publisher Reports
Discussion List
-
Purchase Order Approver Email Template Changed After 25C ReleaseDear All, We are facing an urgent issue: the Purchase Order approver email template has changed after the 25C release. Note that the template is not customized. Could an… -
Which tables have review completed transaction data?Summary Hello , I want to know that which table have review completed transactions data . if any have query and know the table name please guide me. Kindly check the att…
-
PO FYI Approval notifications not printing any linesContent Hi all, We came across a very odd situation for which I already logged an SR as well. Our PO Approval flow is the following: * Start * FYI notification to an App… -
Data not available on print receipt traveler report when receipt source=SupplierSummary: Getting blank report when we run it for Supplier as a receipt source. Tested in both ways: 1. Automatic run 2. Manual Run both are getting blank report Content …
-
Transfer Orders enabled - table fieldSummary: Transfer Orders enabled - table field Content (required): I am looking for what the correct database table field is for the below highlighted field in the UI un…KDR 73 views 5 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for SCM
-
BIP Report issueSummary: Hi I am trying to extract Item master data . Count is huge and getting below error. What is way to extract all records in csv Content (please ensure you mask an…
-
Email server settings to get emails on Ship confirmation output.Summary: We have configured the Shipping Document output Preferences with the correct "From" and "To" email IDs, and set the Ship Confirmation job set accordingly. After…SIVASANKARAN GOPALAN 1 view 0 comments 0 points Started by SIVASANKARAN GOPALAN Inventory Management
-
Tracking BI Publisher Report Print/Email Status for Purchase OrdersSummary: Hi Community, We would like to raise a clarification regarding tracking BI Publisher (BIP) report usage in Oracle Fusion Applications. Business Requirement: Our… -
PO email sent to supplier customizing template not workingHi, I customized the following BIP templates : PurchaseOrderEmailSubjectLayout and PurchaseOrderEmailBodyLayout. I did the setup as shown on screen "BIP Setup" (.doc att… -
Oracle Business Network Access QuestionSummary: Hello, the client is looking for ways to perform access reviews on OBN. On ERP, we have the User to Role Membership report that will show which users have which…
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
How to show physical attribute data of Item at process requisition levelSummary: The business requires item weight details, entered under Physical Attributes in the item specification, to be visible on the Process Requisition page during PO …
-
Disable contract terms and conditions on POPDF layout?Hello We are passing Contract Terms and Conditions on PO header (Controls Tab). These Terms and Conditions are printing at the end of the PO PDF in a new page which are …
-
Can someone please provide underlying sql query for Available To ReserveSummary: Looking for underlying sql query to get "Available to Reserve" and "Available to Transact" qtys on onhand UI. I tried with joining multiple tables and condition…
-
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Graeme Gerber Inventory Management
-
Table names for the DFF , KFF, EFF in fusion.Summary what are the tables for DFF,KFF,EFF in fusion.Content Hi All, Can anybody knows the back end tables for the DFF, KFF, EFF in fusion. Thanks, Sameer A.
-
Requirement to Display Conditional Message in Requisition Approval Notification OnlyHi All, We have a requirement where the following message needs to be displayed only in the Requisition Approval notification, based on a DFF condition: "Test business m…
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 56 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM
-
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 17 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to remove the footer with auto-populated page numbers from the 'Supplier Negotiation PDF Report'Hello, I am looking for a method to remove the auto-generated page number from negotiation PDFs. I noticed that a post was created a little over a year ago on the same t…
-
Not able to see PO Header DFF on BI Subject Area "Procurement - Purchasing Real Time"Summary: I have created a DFF at PO Header level and enable BI checkbox: Then I have run the folllowing scheduled Process: Import Oracle Fusion Data Extensions for Trans… -
How to correct the Error Manual Recovery in Print Inventory Labels ESS JobSummary: We are generating the barcode labels for the Locators in our new Warehouse. However, when we run the Print Inventory Label, the Error Manual Recovery appeared i…
-
Automatically populate associated CPA terms and conditions on the Purchase Order PDFSummary: We want to force the Purchase Order PDF output to have the T&Cs from the associated CPA Source Agreement. Can this be achieved without linking the PO PDF direct…
-
How to create a query/ extract data by joining WSH : interface errors and Delivery InterfaceHow to create a query/ extract data by joining WSH : interface errors and Delivery Interface
-
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…shaikh123 85 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsNeed SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsDhilip Kumar P. 1 view 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
We are trying to Update the PJC_PROJECTS_CCW_V value set to restrict the project number'sSummary: We are trying to Update the PJC_PROJECTS_CCW_V value set to restrict the project numbers at purchase order lines based on the sold to legal entity selected at p…
-
Is there a tool or query that can scan and verify where the field is used?Summary: According to DOC ID 2749921.1, we're encountering an error when adding externally sourced requisitions to Sourcing-sourced purchase orders. The proposed solutio…
-
Local Time Conversion for PO PDF ReportWe have a requirement in our project to develop a custom PO PDF report. A header-level DFF is used to capture the appointment date and time, which is updated by a third-…