BI Publisher Reports
Discussion List
-
query to get both negotiation analyze/award and recommended awardSummary: Hi everyone, I want to get both negotiation analyze/award and recommended award. Could you please help me? Regards, Sultan Content (please ensure you mask any c… -
Need a Query to build a BI report to get the details on exceptions table from supply planning cloudSummary: I am trying to build a BI publisher report to extract data from exception table as per our requirement. Could you please help to find a way to get the query/tab…NaveenBellam 22 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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…
-
where can i find receiving and inbound quantity's for on hand 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…User_3KQOD 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is it possible to transfer Inventory Aging on Transfer Orders?Summary: Capture Inventory Aging on Transfer Orders Content (please ensure you mask any confidential information): We are looking at a way to see if it is possible to ca…
-
Need to get reason code from database for backordered transfer ordersSummary: Trying to write a query from INV_MATERIAL_TXNS to inv_material_txns_exceptions and INV_TRANSACTION_REASONS_TL to get the reason code but I cannot find the link.… -
Folder Invited Supplier from Subject Area Sourcing - Supplier Negotiation Real Time no attributesSummary: The folder Invited Supplier from Subject Area Sourcing - Supplier Negotiation Real Time does not contain Supplier attributes such as Supplier name, Supplier sit… -
Item Monthly Consumption And Usage RateSummary: We have a requirement to display a report showing how items are consumed and their usage rate. Is there a seeded report that provides this information? And if y…
-
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 72 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…