BI Publisher Reports
Discussion List
-
logo in Purchase order email body template is not included in the email bodySummary: Hi All , Greetings of the day! we have customized the RTF template for Purchase Order email body template. We have included the Company logo in the custom Templ… -
Review work order cost View Detailed balance UI: Need table for Cost Allocation FactorSummary: Hello Community, I'm developing one report related to manufacturing costing for which I need table name for Cost Allocation Factor. Any leads will be helpful. P…Ramya Dev 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there an SQL statement or Analytic in OTBI for Interorg Transfer reportingSummary: Our business users are printing out Interorg Transfers, but once the Transfer is saved the Shipment Number field is "Grayed Out" and this make reading it on the…
-
PO PDF in Language of SupplierSummary PO PDF in Language of SupplierContent Hi, I'm looking for the functionality to have the PO PDF print depending on the Supplier (address) language. Currently I've… -
What is the link between Negotiation and Contracts?Summary: I want to run a OTBI report to know all the negotiations and the contracts number that were created from the RFQ , however, I could not find the correct Subject…
-
How to get document download time in purchase agreement PDFWe need to appear the date that the agreement is printed from the system, how to show the document download time? ** sysdate is not work as wanted since after approve th…
-
Generating Sheet name dynamically in excel from xml tag in rtf word with PublisherSummary: in publisher while creating an rtf in word for a multi tab excel is it possible to generate sheet name dynamically from source After loading xml, should be able…
-
REST API to fetch Invoices of the POSummary: REST API to fetch Invoices of the PO Content (please ensure you mask any confidential information): We have a requirement to fetch all the Invoices of given pur… -
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
How to access and print attachments in Quality Action/Issue ReportSummary: We have a new business requirement where they want a report that lists/print all the attachments of each Quality Action/Issue available in Attachments section. …
-
BPM Worklist : Is there a way to retrieve last 18 months approval history in procurement moduleSummary: Hello All, Need your expert advice, we are aware that oracle will purge BPM notification after 30 days of its completion, is there any way we can extract purged… -
Disable Supplier PDF creationContent Hi all, When inviting a Supplier with their Site, by default a Supplier PDF will be generated based on your Layout (BI) and the language of the Supplier Address.…
-
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 166 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 11 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 103 views 1 comment 0 points Most recent by Andreea Gel-Support-Oracle Enterprise Contracts