BI Publisher Reports
Discussion List
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 61 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Madhupa 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to filter out duplicate rows with same values in BI report.Summary: I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_…Rishabh702 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Query to extract Change order details of PO'sSummary: Need to extract all Change orders associated to a PO in Oracle Fusion Procurement Content (please ensure you mask any confidential information): Version (includ…KalyanC 2K views 1 comment 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
I want to pick Inspected by column on po receivingHello, I want to pick Inspected by column on po receiving as attached in screen short in inventory management oracle fusion Need to know the table which is storing this …
-
CREATE MISCELLANEOUS ISSUE AND RECEIPT BIP REPORTSummary: Hello experts, our client has a requirement to display Miscellaneous Issues through a BIP report, so we need the Oracle Fusion table names that store this infor…
-
PROCUREMENT CONTRACT REPORT CREATIONSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
R13 Financials 24A OTBI subject areas to database lineage mapping Spread SheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…vnalluri 41 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
What web service for BIPublisher to use to download output of scheduled report (ScheduleService)Summary: We use the SOAP web service interface "/xmlpserver/services/v2/ScheduleService". Using Operation "scheduleReport" it is possible to launch an execution of a BI …Renato Baietta 55 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Numbers format purchase order standard report issueDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 11 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for SCM
-
Getting null response from erpintegration when making get callSummary: We are trying to fetch the process id detail from this integration, document does say that this operation is supported however we are getting null repsonse. Con…
-
gl_date in rcv_shipment_headerSummary: gl_date column in rcv_shipment_header Table Content (please ensure you mask any confidential information): Currently we have gl_date as blank in rcv_shipment_he…Akancha Sinha 12 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Inventory Management -
Why Terms and Conditions section not displaying Image in PO report?We have configured Terms and Conditions in "Configure Procurement Business Function". But in PO Report, only text is being printed in Terms and Condition section but not…
-
Need tables that store price change history on Purchasing Agreements.We are looking to report price changes in Purchasing agreements. We need table that store price before and after changes. WE see we have tables for change order informat…
-
Can we customize the Inventory BIP reports grid and save the view for the user?Summary: Need the ability to customize the grid and query, then save the layout so it is available as a favorite layout. Content (required): Version (include the version…Hrishikesh Dahane 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 171 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can users approve Change Orders via email notification rather than bell icon?Summary: Email notifications are not being sent to Change Order Approvers the same way they do for original POs. Content (required): Users are able to approve original P… -
Does Oracle allow the modification of change order approval email for Purchase Agreement?We've received a request from a client to modify the email body for approving a change order in a purchase agreement. We want to add a deep link to the agreement number … -
How can I modify the Electronic Record for Inventory Miscellaneous Transaction Report?Summary: I need to add the Reference and Reason field to the RTF Template so that the approving user can make an informed decision without calling the user requesting th…
-
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Neha Aishwarya 11 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to get subinventory and AvailableToTransact Qty of an item in an Org using webservice/BI reportSummary: Need to fetch Sub Inventory along with Available To Transact quantity of an item in an Org using webservice/BI report Content (please ensure you mask any confid…
-
How to provide a Procurement Requester access to OTBI report creation?Summary: How to provide a Procurement Requester access to OTBI report creation? Do we create a custom role and add the BI Author role? Is there a privilege which governs…Asutosh Mishra 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…
-
Cycle countSummary: Unable to find base table for BU association and vendor details for the Inventory Cycle Count Import template. Content (please ensure you mask any confidential …
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…
-
Print PO Line Tax Rate on PO LayoutSummary: We have requirement from business to print tax rate for each PO line on PO PDF Layout. Please confirm if it is possible to achieve this requirement. Content (pl… -
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 22 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM