BI Publisher Reports
Discussion List
-
Query to get Purchase order Versions with Related RequisitionSummary: I am trying to develop a BI Report where I can get each purchase order versions with related requisition , which means if a PO-1 Version 0 is created based on P… -
To apply a bursting logic in Communicate Purchasing Documents Report to specific BUSummary We need to add the bursting logic for Communicate Purchasing Documents report to send the Output to many email id's including the supplier email,and is applicabl…
-
Query to find unaccounted receipt in fusionSummary: Query to find unaccounted receipt in fusion Content (please ensure you mask any confidential information): Hi Team, We are creating a custom report for PO and R…
-
PO_BIP_HELPER.get_ship_to_cust_addressSummary: Hi Team, Could you please share logic/query of PO_BIP_HELPER.get_ship_to_cust_address function, this function is used for to get ship to address of PO. Please s…
-
How to know and then set the PO Approval limits for all the Approvers in the System?Summary: We are currently using Supervisory Hierarchy for PO Approvals . There is a requirement to find out the PO Approval limits of all the Approvers in the system and…
-
We are not able to make any changes in PO view PDF template.Hi Team, We have a requirement to add project-related information to the standard View PDF report on the Purchase Order. We made the necessary changes, but the updates a…
-
Bursting is not getting triggered after customizing the standard Data Model of PO PDFSummary: We want to send a PO PDF to certain SFTP Location. But when we customize data model of PO Print Document communication. The Bursting Logic is not getting execut…
-
Table and Column details for "Agreement Amount Changed" in the CPASummary: We are developing a BI report for Change order of CPA (Contract Purchase agreement). Client to capture the Individual change order amount that is the Agreement …Surjith N K-Oracle 23 views 1 comment 1 point Most recent by Phanindra V Gollapalli-Oracle Purchasing -
Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI AnalysisSummary Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI AnalysisContent Hi All, Is there any folder/dimension where can we find the No… -
Help Locating Table Locations for Purchase Order Change FieldsSummary: We are building a report that requires Change Order History at the line level for dollar amounts + quantity changes. Content (please ensure you mask any confide…
-
How to restrict custom report using cost center management segment Label in oracle fusion CloudSummary: How to restrict custom report using cost center management segment Label in oracle Cloud fusion? What is the Purpose of Management segment Labels in Oracle fusi…Raoof Ahmed 32 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Modify a Delivered Email Template to Communicate Purchasing Documents by Procurement Business UnitSummary: Does anyone know if it is possible to modify the Purchase Document E-Mail BI Catalog object used to communicate purchasing documents to suppliers to send differ…
-
Margins and borders when print pdf agreement in arabicSummary: I want to ask if there are any arabic sites face the following issue: When you print purchase agreement or PO or contracts in arabic, with added contract and te…
-
Conditional Formatting to display field in redHi, In the PO template if the PO amount -
Need to give access to run OTBI purchasing reportsSummary: We were having a issue where a user is not able to run any OTBI reports created under custom/procurement/purchasing. We don't want to give any purchasing role/a… -
Which table having PO's Ordered, Total Tax, Total detailsSummary: Which table having PO's Ordered, Total Tax, Total details Content (please ensure you mask any confidential information): Hi Experts, Would like to seek for your…
-
What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL?Summary: What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL? Content (please ensure you mask any confidential information): Hi Experts, I found…
-
How do I get all the issues listed out for "Incomplete POs"Summary: I need the ability to get a report out of Oracle Fusion showing me all the issues I have on a PO, line, locations, and distributions. I can click on each PO and…
-
Can't create dynamic hyper link in PO approval notification template.Summary: I am trying to create a hyper link that takes the po number () in the po approval template and pass it to a parameter in another custom report I created . That'…KirolosMagdy 34 views 1 comment 0 points Most recent by KirolosMagdy Reporting and Analytics for ERP
-
LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is appliedSummary: LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is applied Content (please ensure you mask any confidential information): When a c…
-
How to create report future "approver details" of requisitions in "Pending Approval Status*Summary: Customer requests a report listing future approver details of requisitions with “Pending approval” status. Content (required): The intent is to answer questions…
-
Some users are not able to Download Custom PO PDFSummary: Some users are not able to Download the PO PDF and clicking View PDF. User have PO Buyer role but still not able to download. Below is the error: "The file was …
-
PO Work Confirmation report with Invoice detailsSummary: PO Work Confirmation report with Invoice details Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
Which table stores the PO fund check information?Hi all, I'd like to create a report about PO line funds check. May I know which table stores the information about PO funds check status? Thanks in advance!
-
what is the name of data model reponse PDF report in the OTBISummary: what is the name of reponse PDF report in the OTBI Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
Need to know table column to fetch status of Associated Collaboration Documents on supplier siteSummary: Hi All, Business wants to have a report where they can see whether a supplier site is enabled for B2B communication and if yes, what is the status of each colla…
-
How to derive Inventory Organization on an Expense PO Line through REST APISummary: We have a client requirement for creating Expense Purchase Orders in Oracle via a REST API integration. While creating the PO Line, the API Payload needs a valu…