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
-
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… -
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…
-
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… -
Inventory report.Summary Trying to use OTBI but some columns like cost are missing.Content A report that shows the following below; I.) Item number II.) Item description )On hand quantit…
-
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 …
-
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…
-
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 find or differentiate Internal/External Drop shipmentsSummary How to find or differentiate Internal/External Drop shipmentsContent Can you please share the query for the Internal/External Drop shipments sales order? This wi…
-
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…
-
Query for Sales Order Contact at header and line levelSummary Query for Sales Order Contact at header and line levelContent Can you please share the query to get the customer Bill_to and Ship_to contact details at header an…
-
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 349 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?
-
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 …
-
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…
-
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
-
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,… -
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…
-
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 …
-
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… -
![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
-
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… -
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…
-
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.
-
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