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
-
OTBI Reporting for Received Date & Invoice InfoSummary Receiving Date issueContent Hello: We are trying to produce a report by Item number, PO, received date and quantity, along with the invoice date, number and PO M… -
Event Trigger not working with multiple selection and null value passedSummary Event Trigger not working with multiple selection and null value passedContent In bip report we using multiple selection and null value passed parameter type, fo…
-
Function in Formula Column like Report Builder(RDF)Summary Function in Formula Column like Report Builder(RDF)Content In BI Publisher do we have an option to build a function(PL/SQL) in the formula column. In RDF report …
-
get lot number queryContent i created this query select RSL.ITEM_ID, RSL.ITEM_DESCRIPTION, rct.ORGANIZATION_ID, RHI.SHIPMENT_NUM, rsh.receipt_num, rct.transaction_date receipt_date from RCV…
-
How to find last_modified_by for reportsSummary How to find last_modified_by for reportsContent Hi Team, We have reports with multiple templates and same has been modified by someone. so would like to find the… -
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…
-
Email is not going through burstingContent Hello Team, We are trying to burst the report output to email from BI publisher, but it is not working. When I schedule to report that has the bursting query to …
-
Specification for DOO_CROSS_REFERENCESummary Specification for DOO_CROSS_REFERENCEContent In the DOO, most of the views 'DOO_CROSS_REFERENCE' Pkg used to get shipment method, freight term...etc Where we can…
-
How to send the header information in email body and line information as attachment using Bursting?Summary How to send the header information in email body and line information as attachment using Bursting?Content Hello Team, I have a requirement where an email needs …
-
How to attach UCM document in email using bursting?Summary How to attach UCM document in email using bursting?Content Hello Team, I have a requirement where i need to attach an UCM document(Dynamic) or the send URL to do…
-
You cannot create a link to a child group as it is having a parent group.Summary Trouble joining more than one query to a "main" one.Content Hi. I'm trying to join two queries to another one as shown in the picture. I can join G2 or G3 to G1,…User_2025-02-07-06-48-26-537 319 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
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 27 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 63 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…
-
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 193 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163