BI Publisher Reports
Discussion List
-
Need PVO details from tables INV_UOM_CLASS_CONVERSIONS,INV_UOM_CONVERSIONSSummary: Hi Team, We need to extract complete data from INV_UOM_CLASS_CONVERSIONS,INV_UOM_CONVERSIONS tables and send it aws . Can you please help us with PVO details Co… -
Join ConditionSummary: Hi All, Can anyone suggest me how to join FND_LOOKUP_VALUES table with the order management module table in fusion? Content (please ensure you mask any confiden…Md Mujtaba Alam 21 views 5 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
Showing Text Message in dependent Flexfield or Popup MessageSummary: Hello Dears, I tried to show a text message in a dependent flexfield and selected a display type as TextArea as shown below When I selected a value from the par…
-
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin… -
Fusion Open Purchase Order as on Certain Past DateSummary: Is there a report or a way to build report which will show Open Purchase Order as on Certain Past Date. Content (please ensure you mask any confidential informa…
-
How to check the error message in Manage PO when funds status is failedHi All, Could you please let us know where does the error message of Funds Status gets stored. The ask is to show the Error message of an PO when it's Funds Status is fa…Naresh313 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
VAT Tax on the Purchase Order through VertexHi, Procurement team has leveraged Vertex tax configuration engine and applied VAT Tax on all five lines in a Purchase Order. Now, the question is to know the feasibilit…
-
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.2K 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 141 views 7 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
Can't found the "objType" deep link for SCM - Confirm Pick Slip pageWe seeking to create a deep link that connects between BI report and the "Confirm pick slip" page from the Inventory management page, also we searched through this docum…Mohammad Hussein 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
What RTF template to use to create a custom Supplier and Buyer Negotiation PDFSummary: Business needs to make changes to the Supplier and Buyer Negotiation PDF Change the texts (wordings) Move/remove tables Move/Remove section We can update the co…
-
Manage Negotiation: Supplier Transaction HistorySummary: We are trying to create a canvass sheet for the client and we would like to get this supplier information from the Transaction History > Purchase Order (please … -
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…
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
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…
-
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… -
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 63 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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… -
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 41 views 3 comments 0 points Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
Need an SQL Query to find Invited Supplier information for newly created NegotiationSummary: Need an SQL Query to find Invited Supplier information for newly created Negotiation Content (please ensure you mask any confidential information): Invited Supp… -
ESS job is running longtime in JobsetWe have created a Jobset with 2 ESS jobs. First ESS Job is completed fast and second ESS Job is running longtime and not completing. When we run the second Job independe…Lakshmi Bandlamudi 34 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for SCM