BI Publisher Reports
Discussion List
-
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 44 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 53 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 11 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 173 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 restore Deleted Folder Under Shared Folders Within BI PublisherSummary: One of the users deleted a folder under Shared Folders→ Custom. Please let us know how can we retrieve the deleted folder Content (please ensure you mask any co…Susmitha Arepally-Oracle 292 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 23 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
OTBI subject area for complex PO work confirmation dataCan someone help me identify the subject area in OTBI for work confirmation reporting? -
Purchase order/agreement change order new file not found in UCMSummary: Content (please ensure you mask any confidential information): Hi all, I've been working on a query to get the latest pdf file (xx_00012_0.pdf) (when clicking v… -
Simple query of "Inventory Register" is taking too much time with following tablesSummary: Hi All, As i am trying to get data for Inventory Register Report by using this simple Query its not completed yet but taking too much time (8-9) minutes because…Immanuel Aruldoss 21 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Oracle SCM reportsWe are implementing Oracle Inventory, Cost accounting, receiving and product management. Would like to now existing reports from the application and OTBI. please can you…
-
Digital signature in PO PDF report with Date and timestampHi Team, We have a requirement to display the digital signature of the final approver along with the date and timestamp in the Approved PO PDF report for standard POs. C…VENU GOPAL REDDY ADINA-Oracle 158 views 1 comment 0 points Most recent by Boyuan Zhu-Oracle Purchasing