BI Publisher Reports
Discussion List
-
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! -
Customising Datamodel of (seeded) Sales Order ReportSummary: How can we customise the Datamodel of the (seeded) Sales Order Report? Content (please ensure you mask any confidential information): The Sales Order Report is …Frank.Steinjan 192 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
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…
-
How to get Integration Status column from Movement Requests?Hi, We have WMS integration and we are trying to build a report for Movement Request details in Fusion Cloud. Except 'Integration Status' field, we are able to get all t…
-
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 can we add tabs in a new page created through application composer?How can we add tabs in a new page created through application composer. I unable to find a page l layout to create tabs. There is only drill down format
-
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 21 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 1 view 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.…