BI Publisher Reports
Discussion List
-
Why Uninvoiced Receipt Accrual Report running into error after 22B Upgrade PatchSummary: Uninvoiced Receipt Accrual Report running into Error after 22B Upgrade Patch Content (required): We are trying to execute ESS Job 'Uninvoiced Receipt Accrual Re… -
Stop PO Print Document communication for certain POsSummary: Content (required): Upon Approval, PO Print Document is sent to the suppliers. We want to add a condition to NOT send certain POs. There is no bursting query or… -
Table for PO Acknowledgement in Oracle FusionSummary Wanted table that captures PO Acknowledgement in Oracle FusionContent Hi, We are looking for table for PO Acknowledgement in Oracle Fusion Cloud 20B version Than… -
How to customize PO Print Document (XSLFO style sheet)?Hello, I have a requirement to customize PO Print Document which is XSLFO style sheet. I have done few changes to it but those are not getting reflected. Can anyone plea… -
Real implication of Sold to LE in Purchasing Transaction - Indirect Procurement - Global LocationsSummary Real implication of Sold to LE in Purchasing Transaction - Indirect Procurement - Global LocationsContent Trying to understand a bit more on this, appreciate any… -
How to Configurable Notifications -Invoice Approval emails would indicate the BusinessSummary: How to Configurable Notifications -Invoice Approval emails would indicate the Business Content (required): Hello I would like on the Invoice Approval emails wou…Cesar Saveedra 44 views 1 comment 0 points Most recent by Ivan Pena-Oracle Payables, Payments & Cash Management -
Can we Add the Signature and name of the Last Approver in the PO PDF based on Approval HierarchySummary: The requirement to add the E-Signature and Name of the Last approver of the document on PO PDF Report Output. The Last Approver can be different for every PO or… -
PO PDF report is not showing the latest or current template.Summary: PO PDF report is not showing the latest or current template. Content (required): I think the issue is that I need to grant some roles on the custom folders, how… -
Need these Item Returns related columns -> Reason, Return Date, Returned By in Inventory ManagementSummary: I am trying to find tables for below highlighted columns (Reason, Return Date, Returned By) from Supply Chain Execution -> Inventory Management -> Receipts -> R…Niharika Paramkusam-Oracle 21 views 3 comments 0 points Most recent by Niharika Paramkusam-Oracle Inventory Management -
Customising Purchase Order Data ModelSummary: How to customise the purchase order data model Content (required): The Line.NOTE_TO_VENDOR column appears in the PdfArchivePurchaseOrderLine dataset but not the… -
Can we use decode or if-else in excel templateSummary: Hi Team, Can we use decode or if-else in excel template for BI report. If yes. can you please share sample example. Regards Nidhi... Content (required): Version…Nidhi Chhajed 245 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM -
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…Amit Sutar 51 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
Table containing the column for Saving amount and saving percentage as per Analyze Negotiation UISummary: I want a query or the table that contains the column for Saving amount and saving percentage as per Analyze Negotiation UI. Content (required): Hello All, I wan… -
Purchase Order layout to include Smartform/Information template detailsSummary: Is it possible the print the details from a Smartform/information template that were collated during requisition entering on a Purchase Order to allow the Suppl… -
How To Identify Orphan Material Left In Staging After Sales Order Line Closed/CancelledSummary: Want to know how to use query from doc-id 1286021.1 in Cloud. column 'Source_code' is not existing in table 'WSH_DELIVERY_DETAILS' Content (required): Client ha… -
Report services are not working post 22A upgradeSummary: REST services related to OTBI are failing in the system which worked fine until the 22A upgrade. Content (required): One of them is 'runDataModel' which we use …Goutham.Manthri 21 views 1 comment 0 points Most recent by Goutham.Manthri Reporting and Analytics for SCM -
In oracle fusion which table have Item Threshold QtyDear , I need item Threshold qty but i cant find a table in which they have. Could you please guide me where it is? For reference i attached a picture also ThanksMirza_Adeel 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
How to run a customised seeded bip report from the Report and Analytics folder/catalog folder.Summary: Greetings, Team — Is there a way to make the 'Open' hyperlink button enabled for a customised BIP Report? We customised the PO PDF Report for two different clie…User_2025-10-24-00-15-43-324 1 view 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Fusion P2P – Oracle Fusion Procure to Pay (P2P) Life Cycle with Functional and Technical flowContent The P2P cycle comprises of the following steps,01. Create Requisitions02. Approve Requisitions03. Create Purchase Orders04. Approve Purchase Orders05. Receive Go… -
Convert DATE from UTC to EST in RTF template pdf ReportSummary: Hi All, I have created PDF report using RTF template, in backend I am using BI analysis and SQL queries in data model. There are many date fields in the report …Saurabh Muthiyan 472 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM -
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…sanjam1130 11 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…User_2025-10-24-00-15-43-324 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report requiredSummary: GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required Content (required): Business wants seeded report/query to show GRN has … -
Inter Org Transfer- Intransit with Receipt RequireSummary: Content (required): Hello Friends we are doing inter-org transfer from UI and using Intransit with receipt require at destination. we are generating shipment nu… -
Knowledge Article: Link to Sourcing application pages using Deep LinksContent In the updates 20D and 21A, Oracle Sourcing Cloud delivered deep links that provide easy navigation directly to sourcing application pages. You can use these lin… -
OTBI/BIP catalog refresh/modified dateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 121 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM