BI Publisher Reports
Discussion List
-
Accrual Month End Report Query based on CMR_PO_ACCRUAL_AMTS tableSummary: Hi All, Business Background: Our business requires an automated PO Receipt Accrual Period End Process to support end-of-month activities related to purchasing. … -
New Supplier Negotiation PDF Template is not availableHi, I have enabled the feature "Configure Supplier Negotiation PDF with Oracle Analytics Publisher" on a new instance but the new negotiation pdf template is not availab…
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
How to get data access for a specific user through the REST APISummary: Through the REST API, we need to obtain from a given user which BUs are granted and what roles are assigned. We need to retrieve these details depending on the …
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 117 views 3 comments 0 points Most recent by User_2F7TP Reporting and Analytics for SCM
-
ContractTermsProcurement - Disable No-Merge TemplateProcurement Contracts: https://docs.oracle.com/en/cloud/saas/sales/fasca/contract-printing-and-layout-templates.html#Printing-of-Contract-Terms-on-Purchase-Orders-and-So…
-
Purchase Order Report through View PDF ButtonCreate a custom report for PO including PO status, when run it through View PDF button after it is approved the po not updated untill a change order is created and appro…
-
where can i get the list of standard reports available in Oracle Fusion procurement ?Hi where can i get the list of standard reports available in Oracle Fusion procurement ?
-
Query to get Purchase Order with an Approved AP InvoiceSummary: I need to write an SQL query to get Purchase Orders with Approved AP Invoice, Could anyone please help me with this? Content (please ensure you mask any confide…
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 51 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
Table to retrieve attachment of purchase ordersSummary: I need to retrieve attachment of purchase order in BI Publisher report. I am not able to get the URL of attachments in fnd_attached_documents. Is this feasible …
-
how to customize buyers negotiation PDF?Summary customize contracts section of Buyers negotiation PDFContent Hi, i am new to Fusion customizations and would like to customize Buyers negotiation PDF. I have dow…
-
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 303 views 13 comments 0 points Most recent by Srinivas Reddy Purchasing -
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 129 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…