To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 55 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 -
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…
-
Can we run BI Analytics Report through APEXSummary Can we run BI Analytics Report through APEXContent Hi , Can we submit BI SaaS report via APEX ? If yes , can you please share some link or document for same. Reg… -
Create customised infolets in Oracle Fusion 19BSummary Create customised infolets in Oracle Fusion 19BContent Hi Can anybody tell me how to create custom infolets in Fusion Application 19B. There is a existing infole…
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…
-
Can a SaaS BI Report fetch data from PaaS datastore?Summary Can a SaaS BI Report fetch data from PaaS datastore?Content Hi, We have a custom screen in VBCS which stores data in a table. We intend to customize the PO Print…
-
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25D -
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…
-
Is there any standard Oracle reports for reconciling Receiving Inspection account?Summary: Content (required): We're looking to see if there's any standard Oracle reports to help reconcile receiving inspection account and review whether there are any …
-
we need item transaction qty with item costContent Dear , We need item transaction qty with item cost. So we used CST_TRANSACTION_COSTS ctc table to join INV_MATERIAL_TXNS imt through imt.TRANSACTION_ID = ctc.TRA… -
Need organization inventory data unit cost wiseContent Dear , We have 11 Inventory Organization in which we want inventory unit cost as per org id. so we created customized query join cst_transactions ct into inv_mat…
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
In Oracle Fusion which table have items unit costContent Dear , I want items unit cost in which i used table CST_TRANSACTION_COSTS ctc table then join into CST_INV_TRANSACTION cit through ctc.CST_INV_TRANSACTION_ID = c…
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…
-
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'… -
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data … -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…
-
Create Link to the BIP from InfoletContent We are looking for the solution where we create a custom Infolet and that infolet should have a link to open a UI screen same as Standard infolets. For example: …
-
Payables invoices items detailsSummary Payables invoices items detailsContent Dear All, I need to create new OTBI report showing all details for suppliers received invoices as follows: Item number - I…User_2025-02-10-22-13-59-726 24 views 3 comments 2 points Most recent by User_2025-02-10-22-13-59-726
-
inventory - inventory transaction real timeContent i use inventory - inventory transaction real time subject area, i need to create analysis 1- open balance for each item before specific date . 2- sum transaction…
-
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… -
Table jai_rcv_headers(R12) in Oracle FusionSummary Table jai_rcv_headers(R12) in Oracle FusionContent Hi Cloud Customer Connect, We have recently migrated to Oracle Cloud Fusion, so we have some custom reports de… -
item balance for each locator,lot and serialContent i need 3 queries. first : item balance for each locator . second : item balance for each lot. third : item balance for each serial.
-
Report for All Products in Staging with Order NumbersSummary Report for All Products in Staging with Order NumbersContent Hello, Can you please advise from which subject area we can download a report with all products in s…User_2025-02-05-12-20-44-163 29 views 2 comments 2 points Most recent by User_2025-02-05-12-20-44-163
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…
-
PO Unit Price incorrectly rounding to nearest number in PO PDFSummary PO Unit Price incorrectly rounding to nearest number in PO PDFContent Question about decimal places on PO's - even though only two digits show up, does the syste…
-
PO approval turnaround time.Summary Report that shows time elapsed for approved PO’s. i.e. Time taken/or number of days it take before PO get approved(Final approved)Content I really need help in a…
-
Need Table Name for Clause Content and Title created in Terms LibraryContent Hello, Need Table Name for Clause Content and Title created in Terms Library. I need to extract those. I searched in the Enterprise Contract Subject Area BI but …User_2025-02-07-08-53-49-914 25 views 1 comment 2 points Most recent by User_2025-02-07-08-53-49-914
-
PO line Level total is not showing in subject areaSummary PO Line Total is not available in Procure to pay - Purchasing Subject areaContent HI, PO Line Total is not available in Procure to pay - Purchasing Subject area,…Farooq Syed, CPA, PMP, CISA, TOGAF 32 views 1 comment 2 points Most recent by Gabriel Grigorie-Oracle