BI Publisher Reports
Discussion List
-
What is the purpose of the CST_I_INCOMING_TXN_COSTS interface table in Oracle Fusion?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…mario.santiago 51 views 8 comments 0 points Most recent by Shabbir M Tahasildar Inventory Management -
Query To Get Supply Quantity from the Print Min-Max Planning Report in Oracle FusionSummary: When working with the Print Min-Max Planning Report in Oracle Fusion, you may need to extract specific information, such as the Supply Quantity. This quantity r… -
BIP Report scheduled JOB not visible to usersSummary: BIP Report scheduled JOB not visible to users other the user who schedule it " BI Administrator Role" is also assign to the users Content (please ensure you mas…
-
Move the Privilege for running HITB and Lot report from a Custom INV View only Job RoleSummary: Please help to identify the privilege for running HITB and Lot Report from a custom INV View only job role. We want to remove this privilege and transfer to ano… -
Inventory Ageing ReportSummary: We have SQL Code, regarding Aging Buckets. developed a report but for 1 item it is giving the data with in 1 sec., but it won't work out for my client. we need …Sumalatha Challa 11 views 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management -
How can I use the item keyword as a parameter in a BI Publisher reportSummary: I want to allow users to search the BI Publisher report by any word within the item description. Currently, the parameter for item description limits LOV to 30 … -
Released Amount and Release Quantity not showing in Agreement PDF ReportSummary: We have customized the Seeded Oracle Purchase Agreement report and added the 2 columns at line level "Released Amount" and "Released Quantity". Data not showing… -
Email Notification Sent out to Supplier for Purchase OrdersSummary How to Modify Email Notification Sent out to Supplier for Purchase OrdersContent Hi All, Can we add conditions to email body of po pdf notification sent out to p…User_2025-02-03-22-11-49-695 306 views 13 comments 0 points Most recent by Srinivas Reddy Purchasing -
Changes to PO not reflecting in PO PDF DocumentSummary: Hi, I have a PO that was approved. We then submitted a change order to change the deliver to location. This has also been approved. However the PO PDF document … -
LOV Parameter Disabled When Using Full Item DescriptionSummary: I'm working on a BI Publisher report in Oracle Fusion where I want to use item description as a parameter. The parameter is based on a List of Values (LOV) from… -
sql query for Response from Supplier Portal and Surrogate Response in oracle fusion Sourcing moduleHi Team, We need a table or SQL query to get the details for negotiation created Supplier Portal and Surrogate Response details in oracle fusion Sourcing module Thanks. -
Is there any Blanket Purchase Agreement Notification Report available in Oracle.Summary: We have a requirement to customise a purchase agreement approval notification, I'm unable to find the approval notification report to customize in the Notificat… -
How-to: Display Text Attachments in PO PDFContent Customers who attach many large text attachments to their purchase orders may find that the text attachment content does not appear in the purchase order PDF. To… -
Purchase Orders are not using the latest BIP PDF templateSummary: Purchase Orders are not using the latest BIP PDF template Content (required): We have updated our PO RTF template and for some reason the changes are not being … -
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …Khalid Aldosari-Oracle 125 views 2 comments 0 points Most recent by Walter Spinelli Reporting and Analytics for SCM -
CCC - Facing issue to get the Correct Source Organization and Destination Organization.Summary: Hello Folks, We have a requirement to get Source and Destination Org according to each Transaction Type and Transaction ID for Transfer Order Transactions in Re… -
Unable to view Purchase order PDF in UI on purchase orders over £9,999,999.00We have a high value purchase order of more than £10mill in our system but when trying to view the Purchase order PDF from the UI it will not load. I have tested values … -
Requisition Email Approval templateI am currently working on updating the custom requisition email approval template. As part of the testing process, I have enabled the BIP_CLIENT_REFRESH_TME profile opti… -
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T… -
Can we change email subject name of Suplliers for negotiation invitation and negotiation Award emailSummary: There is requirement from client that customized email subject name that send to supplier for negotiation invitation and negotiation Awarded email. Can this be … -
What is the character limitation to show Oracle Purchasing Text attachment on PO PDF DocumentSummary: We would like to know what is the character limitation to show the text attachment on the PO PDF Document. Content (please ensure you mask any confidential info… -
Are there available standard reports showing the return transactions?Summary: Hi Community, Would like to check if there are Oracle standard report available showing the return to vendor transactions? Thank you. Content (please ensure you… -
Query to get Requisition and Standard PO details for the respective BPASummary: Query to get Requisition and Standard PO details for the respective BPA Content (please ensure you mask any confidential information): We are developing report.… -
Query to find the approved purchase requisition based on specific rulesSummary: Hi Team, We are looking for a purchase requisition information where the specific rules are triggered as part of the approval workflow Content (please ensure yo… -
Scheduled BIP Report not Working post update to Recipients listSummary: A BIP report Scheduled to run once a week, made changes to the recipients list and observed the changes were not reflected in the next run, means recipient's li… -
Issue with HTML Tags in Excel Output from Oracle Fusion BIP ReportWe are encountering an issue in Oracle Fusion where HTML tags are appearing in the Excel output of a BIP report. This problem was observed during the creation of an RFQ …Venkatesh Babu Somalinga 34 views 2 comments 0 points Most recent by Venkatesh Babu Somalinga Reporting and Analytics for SCM -
Open Oracle Cloud Application PDFs in the browser to avoid local downloading.Summary: Open Oracle Cloud Application PDFs in the browser to avoid local downloading. Content (required): Hi, So in a normal scenario when we will click on any of the P… -
Can we create a custom dashboard for Managers to check all subordinates RFQ /Order detailsSummary: Can we create a custom dashboard for Managers to check all subordinates RFQ /Order details Content (please ensure you mask any confidential information): Need t… -
What is the logic for segregating the serial number between OnHand and Inbound quantities?Not able to segregate within the OnHand and Inbound details as we are getting the serial number based on Inventory_Item_id and because of this we see records are getting… -
AnyTable to get po status list which is used to store in document_status in po_headers_allSummary: Hi All, We have one requirement to pass the PO status as a parameter in PO details BIP Report. To create the SQL query for LOV we need distinct value of Po stat…