BI Publisher Reports
Discussion List
-
What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL?Summary: What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL? Content (please ensure you mask any confidential information): Hi Experts, I found… -
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 668 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 39 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM -
How do I get all the issues listed out for "Incomplete POs"Summary: I need the ability to get a report out of Oracle Fusion showing me all the issues I have on a PO, line, locations, and distributions. I can click on each PO and…
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 42 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle 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 31 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! -
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 182 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 24 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…