BI Publisher Reports
Discussion List
-
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 71 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Where the price break in the response line is stored?Summary: If the supplier add a price break in the response of negotation, the award negotation does not show this discount which table stores this information? Content (…
-
Sub Inventory is not Populating in manage Reservations and Picks pageSummary: Actually when we are fetching the Available to reserve value in a report based on Sub Inventory the correct values are not getting fetched in the report. When w…
-
What is the table name for price break information at negotiation response line levelSummary: What is the table name which holds information related to the price break information at negotiation response line level. We need this information to fetch data…
-
Serial Numbers not picking in the reportWith a series of old transaction IDs. We need the data for each transaction to be extracted and displayed individually in the EBR report because we need this information…
-
How to create dependent value set for BIP ESS parameterSummary: We have custom Sales Order Pick Slip Report having 2 parameters. Sales Order -Lov controlled Pick Slip Number - Here the requirement is, the LOV should show tho… -
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 164 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM
-
Duplicate Count SequenceSummary: In the UI, a specific sequence has one record but upon checking in BI Reports, there are two records with different items but having the same count sequence. Ho… -
Can we add custom parameters to the seeded ESS job Communicate Purchasing Documents?Summary: I'm reaching out to see if anyone has experience customizing the ESS job 'Communicate Purchasing Documents', which is responsible for distributing the PO PDF to…
-
How to query APPROVAL_GROUP_NAME FROM PO_HEADERS_ALLSummary I am looking to get approval_group_name from po_headers_all for BI reportContent Hello, I can see that APPROVAL_GROUP_NAME EXIST IN POR_AMX_ACTION TABLE, but can…
-
Want to get Negotaion number and requistion number in purchase order PDFSummary: Want to get Negotaion number and requistion number in purchase order PDF Content (please ensure you mask any confidential information): Version (include the ver…
-
Equivalent report for Israeli Localization Withholding Tax Certificates Expiry Date reportSummary: Hi, We are in middle of migration to cloud and we are looking to see the equivalent report for the 11i report "Israeli Localization Withholding Tax Certificates…Anand Balasubramanian 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to customize the "Attached Contract Preview" templateSummary: When adding contract terms to any purchasing document, there is an option to attach a document rather than add clauses/templates set up in enterprise contracts.…Gaurav Rochwani 101 views 1 comment 0 points Most recent by Andreea Gel-Support-Oracle Enterprise Contracts
-
How to club PO lines at RTF level without modifying the data model?Summary: Hello team, We have a requirement to club multiple PO lines into one (assuming the same item number) as supplier wants to see only fewer lines and consolidated … -
How to remove or customize "Attached Contract" template from PO pdf / DocuSignSummary: The "Attached Contract" standard text within the PO pdf when using uploaded terms is misleading when using DocuSign to sign and communicate contracts as the att…
-
Can Subject of a Negotiation Award Approval Bell notification be customized?Content Can Subject of a Negotiation Award Approval Bell notification be customized? Like have supplier name and description? Version Oracle Fusion 13, 19C
-
How to pick po line level attachment columnHello. I want to pck an column in custom BI report of PO line level attachment on serial number attachment sign is coming when we click on that new pop up opens in which… -
I need to design a report to export data for Inactive ItemsI need to design a report to export data for Inactive Items, please help to provide SQL to acquire column data that we need or official Inactive Items Report. Want to pr…
-
Purchase Order PDF not caching for previous revisionSummary: Hi all, Experiencing a peculiar issue regarding the PO PDF in OFC. My understanding is that when a PO or change order is approved, this kicks off a job to run t…
-
Is there is a way to export the pdf of PO and purchase agreement as word document?Summary: Is there is a way to export the pdf of PO and purchase agreement as word document? Content (please ensure you mask any confidential information): Version (inclu…
-
How to display supplier mobile number in purchase agreement pdfSummary: I cant find mobile's number pf supplier contact in purchase agreement pdf data model, i just found the phone Content (please ensure you mask any confidential in…
-
Does anyone have query in getting the mid-level Purchasing Categories?Hello, does anyone have ready query to get the list of mid-level Purchasing Categories? (Or even not an exact query but something similar for reference. Business user wa…
-
Does the ERP 24B version have a Pick Slip Report, contains status information, GIN (Issued) Date?Summary: Does the ERP 24B version have a Pick Slip Report, to view pending status and success data with GIN Date (Issued) and Pick Slip Date information? Content (please…
-
Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tabSummary Procure to Pay Dashboard - On Time Delivery calculation under Cross Process tab What formula does the system/dashboard uses to calculate the On Time Delivery in …Maria Angelica Mendoza 51 views 2 comments 0 points Most recent by Maria Angelica Mendoza Purchasing -
Extracting Requisition and Purchase Order Rule Details defined in BPMSummary Extracting Requisition and Purchase Order Rule Details defined in BPMContent I am looking if anyone know if there is a way to run a query/report or table name wh…