BI Publisher Reports
Discussion List
-
What is api to award supplier manuallySummary: What is api to award supplier manually after receiving the response Content (please ensure you mask any confidential information): Created RFQ. Received respons… -
Request to Replicate Oracle GET_POSTING_STATUS() FunctionalitySummary: We need to replicate the functionality of the Oracle standard function GET_POSTING_STATUS(). Requirements: Explain what GET_POSTING_STATUS() does in Oracle, inc…Guthi Mallikarjun 1 view 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management -
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… -
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 112 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… -
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… -
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… -
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… -
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 141 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…