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
-
RSUM not giving expected results.Content Hi. I made an OTBI report (check attached image) using the Cash Management - Bank Statements Real Time, Subject Area I want to do a RSUM of each bank account to …User_2025-02-07-06-48-26-537 45 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle -
Customer Data DumpSummary Seeded Customer dump reportContent All - Is there a seeded out of the box report that can create a dump of all customer related attributes? -
Complex Inventory Stock Ageing Report by Original PO Receipt DateSummary Require feasibility check on a complex Inventory Stock Ageing Report (Across Multiple Inventory Orgs)Content We have an unique report requirement for customer re…
-
Version Control for Data Models and ReportsSummary version control reports in BI PublisherContent Hello, Is there any best practice, or any way to version or tag a report or a data model in BI Publisher ? Thanks,… -
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in…
-
query for item balance in each inventory or for itemContent i want to get balance for each item item_id , available_qty , reserved_qty , balance_qty i want to get balance for each item in each inventory item_id , requisit…
-
Missing Create Infolet tile iconSummary Missing Analytics tab and Create Infolet optionContent Hello, I am interested in creating an Infolet based on information that is present in Product Information …
-
Bursting sending duplicated reports.Summary Some outputs are being sent duplicted (or more!) by mailContent I have a report to get the hand quantity for each subinventory. The output is like: SUB ITEM QTY.…User_2025-02-07-06-48-26-537 28 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
CST_INV_DISTRIBUTION_v Oracle R12 table in Oracle Fusion.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We… -
![Wim Bos [MLE]](https://us.v-cdn.net/6034893/uploads/userpics/ODSF2MJMJI4P/nCCCSR0CHH1FE.jpg)
Possible to retain OTBI/BIP report jobs upon P2TSummary Don't like having to reschedule the same report jobs after every P2TContent As stated in Doc ID 2581724.1 "P2T refresh clears the scheduled information too. Henc… -
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0
-
Generating a indented BOM list report.Content Hey there, I'm trying to generate a report with the indented list of a BOM. In Oracle 10 we had fields to build the structure based on a starting node and then j…
-
BICC ExtractSummary How to Extract Sales Order DFF's using BICCContent How to Extract Sales Order DFF's using BICC Version 20CUser_2025-02-07-13-19-02-936 65 views 2 comments 0 points Most recent by User_2025-02-07-13-19-02-936
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p… -
How to derive NEW_COST for Raw Material Consumption For Production Query.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We…
-
Oracle R12 table jai_om_wsh_lines_all in Oracle Fusion.Content Hi, Please help me with this Oracle R12 table jai_om_wsh_lines_all in Oracle Fusion. Regards, Sriram G.
-
Use text box for user in analysisContent Hi, I am trying to create analysis that return data for selected reference designator. I succeeded to create analysis that let the user to select reference desig…
-
Query for Contract Review is not fetching rows.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We…
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 194 views 8 comments 0 points Most recent by User_2025-02-05-12-20-44-163
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…User_2025-02-05-12-20-44-163 195 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163
-
How to join Procurement - Procure To Pay Real Time and Procurement - Purchasing Real Time without "OSummary Ability to display PO Line DFF with Procure to Pay information and Logical SQLContent We would like to display the PO Line DFF with Procure to Pay information an…
-
OM tables in Oracle Fusion.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We…
-
Fusion BI Publisher Report - How To Get Last Run DateSummary Fusion BI Publisher Report - How To Get Last Run DateContent We are working on creating BI Reports (SaaS BIP) and use bursting and scheduling to send the notific…
-
Oracle Fusion Cloud Audit Reports - Changes in Static Data (Before and After Values)Summary Audit Reports - Additional Functionality (Before and After Values)Content Hi, My client wishes to have a more detailed Audit Report functionality Currently the A…
-
Some Oracle R12 Inventory tables in Oracle FusionContent Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We…
-
Duplicate records while retrieving data - Goods Inward Note.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We…
-
Duplicate records while retrieving dataContent Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We…
-
mtl_transaction_types in Oracle Fusion.Summary In Oracle R12 table mtl_transaction_types, what table is in Oracle Fusion.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed som…
-
INV_MATERIAL_TXNS table.Summary In INV_MATERIAL_TXNS table NEW_COST field show no data.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have custom reports in our Old Oracle…
-
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…