OTBI
Discussion List
-
OTBI - SUBTOTALSummary: Is there a way to show only the subtotal in OTBI? Content (please ensure you mask any confidential information): Version (include the version you are using, if … -
What subject area or field to display the corrected amount for Service POs in OTBISummary: We are using the subject area Receiving - Purchase Receipts Real Time to display PO Receipt information. We are using the field Receipt Amount to display the am… -
How can we configure the date picker parameter in an ESS job to show JST instead of the default UTC?Summary: We have an ESS job where the 'Territory' is set to Japan, and the 'Time Zone' is set to (UTC+09:00) Tokyo – Japan Time (JT) in the Process Options. However, in …
-
DOR Draft Version Removing or Disable Before The request is approvedSummary: this is the DOR after approval that we want to keep it but before approval the Dor is Draft Version and this is what we need to hide or remove
-
Supply Chain Operation for MaintanenceSummary: Supply Chain Operation Dashboard ( Maintenance/Manufacturing, Inventory, Costing and Quality Content (please ensure you mask any confidential information): Orac…
-
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i…
-
Is there a field in OTBI that shows who initiated a Movement Request Transfer?Summary: I would like to create an OTBI analysis for Transaction Type = Movement Request Transfer that includes the user who initiated the request. In Manage Movement Re… -
How to know the Reservation quantity from which sub inventory and locatorSummary: Business use case is to know the reserved quantities that is in specific sub inventory and locator. Currently for any sales order reservation, sub inventory and… -
Extract System vs Counted Quantity for Physical Inventory (Before/After Approval - not yet posted)Hi, Is there a way to generate or extract a report in Oracle Fusion Cloud that shows both the system on-hand quantity and the counted quantity for a physical inventory b…
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 22 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
Perform Lot Split, Merge, and Translate transactionsSummary: Perform Lot Split, Merge, and Translate transactions Content (required): Would like to understand how to perform Lot Merge / Split transaction through front end…Jayaharan Krishnamurthy 858 views 15 comments 0 points Most recent by Mangesh Shastri Inventory Management
-
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 11 views 0 comments 0 points Started by Balaji Midhun Kumar Sanagapalli Inventory Management
-
What OTBI subject area provides PO receipt data when Inventory Management module isn't used at all?Summary: We use Procurement Cloud and create receipts for our purchase orders. However, we don't use the Inventory Management module at all. Our receipts are specific to…
-
how to find organization id(Master or any inventory org) value using OTBI or any other waySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to retrieve Manage Receipts page's "Receipt Date" from subject area?Summary: How to retrieve Manage Receipts page's "Receipt Date" from subject area? Content (please ensure you mask any confidential information): Hi Experts, Would like t…
-
DFF Value is not available in the BI Subject Areas - INV_LOT_ATTRIBUTESSummary: Do not see new DFF created in 'Inventory - Inventory Balance Real Time'. Please see attached. Content: Name Lot Attributes Flexfield Code INV_LOT_ATTRIBUTES App… -
Oracle Documentation missing Order Management Subject AreaSummary: Troubleshooting an issue when building a custom analysis in OTBI. When I navigate to the Subject Areas for Transactional Business Intelligence in SCM (link belo…Becca Edwards 13 views 1 comment 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
How to find Invalid transactions showing in "Inventory transaction pending" infotileSummary: Content (please ensure you mask any confidential information): Inventory Transaction Infotile showing 5 transaction as shown below. Since it can not be drilldow…
-
Creating Receipts from ASNsSummary: We are going to start having our suppliers sending us ASNs for products we order. We had some questions from the Buyers perspective on how to create receipts fo…
-
Tasks related to the subject area "Product Management - Item Catalog Category Hierarchy Real Time"?Summary: Tasks related to the subject area "Product Management - Item Catalog Category Hierarchy Real Time"? Content (please ensure you mask any confidential information…
-
On-hand quantity on a historical dateContent We have a requirement where we need to get the inventory on-hand quantities of items by day @ 11:59:59pm since Jan 1, 2021. Is there a standard report that can b…User_2025-02-11-12-16-08-273 548 views 3 comments 2 points Most recent by Becca Edwards Inventory Management -
PICK SLIP NUMBER SUBJECT AREAHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI report, would someone know what subject area can I find the order pick slip number? T…
-
Is there an SQL statement or Analytic in OTBI for Interorg Transfer reportingSummary: Our business users are printing out Interorg Transfers, but once the Transfer is saved the Shipment Number field is "Grayed Out" and this make reading it on the…
-
Supplier Lot to Internal Lot Report in Business IntelligenceSummary: Need to view Supplier Lots with our Internal Lots for Inventory On Hand Balance. We work with Contract Manufacturing, so keeping track of their Lot with our own…
-
How to enable Shipment DFF in Shipping Seeded Subject Area?Summary: DFF have been configured in Shipment Lines Level. Requirement is to be able to fetch the DFF in seeded Shipping subject area for configuring an OTBI report. Not…Sandip Roy 73 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
In OTBI Report Date is not displaying correctly as per the date mentioned in front endSummary: In OTBI Report Date is not displaying correctly as per the date mentioned in front end Content (please ensure you mask any confidential information): Subject Ar…Manisha Shrivastava 13 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Serial Numbers not picking in the reportWith a series of old transaction IDs. We need the data for each transaction to be extracted and displayed individually in the EBR report because we need this information…
-
DFF in manage Lot page not appearing in subject areaSummary: In OTBI Analysis we want to show lot number with the Descriptive flex fields in additional information. DFFs are deployed successfully and BI Enabled is checked…
-
Privilege required to view Uninvoiced Period End Receipt Accruals report 24BAs per 24B release notes (), one of below seeded roles is required to view the Uninvoiced Period End Receipt Accruals report in OTBI: Cost Accountant Receipt Accounting …
-
Transfer order shipping line status in otbi analysisSummary: Need to be able to extract the transfer order line status from 'Manage Shipment lines' UI Content (please ensure you mask any confidential information): Current…