OTBI
Discussion List
-
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 13 views 2 comments 0 points Most recent by Guthi Mallikarjun 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 12 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…
-
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 650 views 14 comments 0 points Most recent by Harish Vashist Inventory Management
-
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 481 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 71 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 12 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… -
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 it possible to see a list of immovable inventory in OTBI or in the standard functions?Is it possible to see a list of immovable inventory that has not moved from subinventory for more than a certain period of time in OTBI or in the standard functions?Takaaki Kozaki-Oracle 12 views 2 comments 0 points Most recent by Regie Mercado Inventory Management
-
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin… -
How to restrict the List of Inventory orgs from LOV on reportSummary: We have custom report for Inventory on hand. User has to select the Inventory org as a LOV Parameter. How do we restrict the list of Orgs in LOV? Currently any …Shrikant Bhavsar 12 views 1 comment 0 points Most recent by Shabbir M Tahasildar Inventory Management
-
Tabla de Oracle Cloud para sacar el bill-to y ship-to location del proveedorDears , Please help me with the Oracle Cloud Table to get the bill-to and ship-to location from the supplier.
-
MATERIALS REQUIREMENTHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI for materials requirement below, would anyone know how to create the formula for tota…
-
Economic production quantitySummary: Hello All, One of my customer follows the Quote to Cash process for building Configure to Order (CTO) items. They do not manufacture, but assemble products base…Vishnuvarth Subramanian-Oracle 21 views 1 comment 0 points Most recent by Radhakrishnan Angappan-Oracle Manufacturing
-
OTBI REPORT FOR TRACEABILITYHello and good day! Dear Oracle friends, If I will create an OTBI for Traceability, what are the possible subject areas and data fields I need? Hope to hear from the com…
-
Missing column in Subject Area for ReservationsSummary: Missing column (Subinventory) in Subject Area for Reservations Content (please ensure you mask any confidential information): I am trying to create a report, ba…IdK1992 4 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…