Get Started with Redwood for Oracle Cloud SCM Begin Now
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… -
Unable to add Negotiation Icon to the Springboard and Navigator.Summary Unable to add Negotiation, SQM, Catalog Icons to the Springboard and Navigator.Content Hi Fellow Practitioners, Season's greetings. I have done all the necessary… -
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…
-
OTBI Dashboard results in display errorSummary The dashboard contains an analysis with extensible flexfields. The flex field is deployed and working fine within OTBI but when deployed on OM Landing page via s…
-
JOb Scheduling which need a change of date on parameterSummary how to do change the parameter date of the ESS job when we schedule itContent we need to schedule a ESS job on daily basis on parameter we have start date and en… -
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 …
-
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,…
-
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 47 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.…
-
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 20C