BI Publisher Reports
Discussion List
-
Confirm ReceiptsSummary: Confirm Receipts Content (please ensure you mask any confidential information): How to modify the notification send to requestor when confirm receipts is genera… -
How to get last issued Document Number for a bank account through REST APISummary: We need to create a Manual payment through Integration (REST API). In order to create a manual payment, we need to send Payment Number in the payload. We would … -
abstract page not picking customized layout for Supplier Negotiation PDF ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Query to fetch 'Amount Changed' against change order in POSummary: We have a requirement to create a Purchase Order summary report which will give details of change order against PO. to calculate 'Amount Changed' value, we need…bhushan_sarode 1.1K views 2 comments 1 point Most recent by Rajitha Nadakudhiti-Support-Oracle Purchasing -
How to customize supplier welcome mail template?Summary: We'd like to customize the supplier email notification layout. For example, once the supplier user completes the registration flow from external. A welcome lett… -
Is it possible for a buyer to add a text like terms and condition in the PO PDF File?The buyer wanted to add a text in the PO PDF File which text is for specific PO only. Can a DFF do this? -
Query to fetch PO Change History DetailsSummary: Query to fetch PO Change History Details Content (required): We have requirement to build a report which shows original PO amount. I want to know how to fetch d… -
Uninvoiced Receipt Accrual ReportSummary: We are trying to run the report "Uninvoiced Receipt Accrual Report" for expenses but not able to get any data, though we are having lot of uninvoiced receipts w…HarshalAgrawal 130 views 7 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
REST API for Purchase Agreements DFFSummary: We are looking for a REST API for getting DFF values on Purchase Agreements. we have already got REST API to fetch purchase agreement details but unable to find… -
Storing Historical Pricing ChangesSummary: Looking for all options for storing and referencing historical pricing changes in the Pricing Administration Application? Content (please ensure you mask any co… -
Query for PO line ordered amount and line total amount based on Function for PO PDFSummary: PO PDF function is required for PO line amount and PO line total amount. Content (please ensure you mask any confidential information): On PO PDF, the PO line's… -
After a change order is created, is there a table where previous versions of taxes are stored?We are trying to create a report for when a change order is created in the Purchase Order (PO) to change the tax and it gets approved. We want to see what the tax is aft… -
REST API for verifying whether a Purchase Order includes a Change OrderSummary: REST API for checking PO has Change Order. Content (please ensure you mask any confidential information): Hi, Is there any REST API available for verifying whet… -
What is the function or package to get PO Line's Requested Delivery Date in PO PDF?Summary: In both PO PDF (Purchase Order PDF Report) as well as the Notification for approval (Purchase Order Notification Report), we would like to include each line's R… -
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO… -
Requirement to add special instructions to a PDF report based on organization of a PO.Hi We have a requirement to add special instructions to a PDF report based on organization of a PO. Currently we have 20+ organizations. Which will increase in the futur…Mazher Shaikh 93 views 2 comments 0 points Most recent by Mazher Shaikh Reporting and Analytics for SCM -
Regarding reading the doc file in UCMHi Po has an doc attachment in UCM , can we read doc attachment from UCM in BIP Report ? Thanks -
Hi All,I want Release_num column from PO_RELEASES_ALL table which is present in Oracle R12 equivalent in fusion ?In fusion we don't have any PO_RELEASES table at all. Kindly he… -
Behavior in PO_ATTRIBUTE_VALUES tableSummary: Behavior in PO_ATTRIBUTE_VALUES table Content (please ensure you mask any confidential information): My question is regarding the PO_ATTRIBUTE_VALUES table. Thi… -
Reconciliation report purchasing to GLSummary: Reconciliation report purchasing to GL Content (please ensure you mask any confidential information): Hi Could you help me with the following question please. I…Jazmin Saldierna 23 views 2 comments 0 points Most recent by Venkat Jagan Pakala-Support-Oracle Costing -
How to extract the data of Charge accounts and charge id in oracle fusionSummary: Hi Team, How to extract the data of charge accounts and account id in oracle Fusion Content (please ensure you mask any confidential information): Version (incl… -
Need Standard Report or Table details for PO approver and each approver limit detailsSummary: Need Standard Report or Table details for PO approver and each approver limit details Content (please ensure you mask any confidential information): Hi, We want… -
Is it possible to have a DFF the same function as the Text Category in PO attachment?Is there any other way to have a functionality wherein the user can add text in the PO PDF template, same as the Text Category in PO attachment? -
How to query PER_ADDRESSES_F table for employees using BI ReportsSummary: Line Manager is unable to access PER_ADDRESSES_F table and thus is not able to access the report based on this table. As per oracle note 2887292.1, we need to e…Sourav Parbat 76 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management -
Purchase Order PDF Report with conditional sub templateSummary: We have a requirement for one business unit to issue 4 completely different purchase order PDF's based on shiptolocationname. We have the sub template working w…Claudia M 123 views 5 comments 0 points Most recent by Claudia M Reporting & Analytics for Fusion Service -
Can anyone please let me know the join between the fnd_attached_documents and POR_REQUISITION_HEADERSummary: Hello, The requirement is to get the supplier negotiation notification attachment through UCM.As per the oracle document,fnd_attached_documents and POR_REQUISIT… -
DeleteDelete -
is there any possibility to customize or copy Standard Purchase Order Dashboard?Summary: How to copy/customize existing Purchase order Over view page (dashboard) for each Business Unit? Content (please ensure you mask any confidential information): … -
Exporting data to FBDI formatI would like to be able to export data from application onto FBDI format. It looks like this is available for suppliers: https://docs.oracle.com/en/cloud/saas/procuremen… -
Any table exist in Oracle cloud which store Purchasing Agreement details or Master contract NumberSummary Any table exist in Oracle cloud which store Purchasing Agreement details or Master contract NumberContent Hi Guru's, I am modyfing the PO PDF seeded report and o…