BI Publisher Reports
Discussion List
-
On-hand quantity on a historical dateContent We have a requirement where we need to get the inventory on-hand quantities of items by day @ 11:59:59pm since Jan 1, 2021. Is there a standard report that can b…User_2025-02-11-12-16-08-273 702 views 3 comments 2 points Most recent by Becca Edwards Inventory Management -
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 41 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM -
Can't create dynamic hyper link in PO approval notification template.Summary: I am trying to create a hyper link that takes the po number () in the po approval template and pass it to a parameter in another custom report I created . That'…KirolosMagdy 32 views 1 comment 0 points Most recent by KirolosMagdy Reporting and Analytics for ERP -
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is appliedSummary: LAST_UPDATE_DATE in PO_LINES_ARCHIVE_ALL is not updated when new change order is applied Content (please ensure you mask any confidential information): When a c…
-
How to create report future "approver details" of requisitions in "Pending Approval Status*Summary: Customer requests a report listing future approver details of requisitions with “Pending approval” status. Content (required): The intent is to answer questions…
-
Some users are not able to Download Custom PO PDFSummary: Some users are not able to Download the PO PDF and clicking View PDF. User have PO Buyer role but still not able to download. Below is the error: "The file was …
-
PO Work Confirmation report with Invoice detailsSummary: PO Work Confirmation report with Invoice details Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
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! -
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…