Reporting and Analytics for SCM
Discussion List
-
JOB Set do not have a wait timeSummary while creating a job set for 3 job we can not provide a wait timeContent hi we need to create Job set 1. Print Min Max planning report 2. Process supply orchestr… -
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… -
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 …
-
Relate EGP_STRUCTURES_B/EGP_SYSTEM_ITEMS with Catalogue Categories.Content Hi. I made a BOM explosion using EGP_STRUCTURES_B and now I need to filter out some results based on catalogue properties of the items. I did not find meaningful…
-
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…
-
Cross posting this idea in SCM Reporting and Analytics forum - ability to Audit OTBI report configuSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t… -
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…
-
Why transfer number is blank with Reports for Supply Requests?Content When I create a Supply request analysis in BI the transfer number is blank
-
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,…
-
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 …Gabriel Alejandro Zorrilla 6 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…
-
OTBI Analysis - Results from subject area incorrect join (OR no join?)Summary OTBI Analysis on subject area Product Management - New Item Request Approval Real TimeContent Hello, I am trying to create a simple analysis on which I am intere…
-
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.…
-
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…