BI Publisher Reports
Discussion List
-
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 22 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 32 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…
-
How to know whether the PO are archived?Hi Experts, I'm drafting a SQL for a report that our end users will be able to retrieve their approval history. While there are 2 tables having the PO information: PO_HE…