OTBI
Discussion List
-
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 27 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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 …
-
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… -
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 11 views 2 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
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 11 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 11 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 22 views 1 comment 0 points Most recent by Radhakrishnan Angappan-Oracle Manufacturing
-
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 375 views 9 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
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 1 view 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…
-
SHARING OF OTBI REPORTHello and good day! Dear Oracle community friends, If a user has limited access to other modules (e.g. Procurement and Inventory Management users) and one user in that m…Regie Mercado 45 views 12 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
Is there any REST API to get the details on Outbound Shipment RequestSummary: Is there any REST API to get the details on Outbound Shipment Request
-
Combining order management & Cost accounting subject area not giving data in OTBI reportSummary: How to combine order management & cost accounting subject areas in OTBI report? Content (please ensure you mask any confidential information): We have an OTBI r…Manisha Shrivastava 2 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to query the results of all generated cycle countsSummary: Our Client requires to consult through UI or some type of report the results of the all cycle counts that it has generated in order to obtain inventory reliabil…Adriana Rivera 11 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management -
What values to pass to lexical references to Physical inventory Tags Data modelSummary: We have customized the Physical Inventory Tags data model and report. Then we tried to modify a column. However, I don't know what values to pass to the 4 lexic…
-
SQL QUERY for Inventory Pending TransactionsSummary: Does anyone have a sql to query pending inventory transactions? Content (please ensure you mask any confidential information): When there are many inventory org…Adriana Rivera 31 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management
-
Inventory OTBI Report is working for some users and giving error for otherSummary: I have created OTBI report under the following subject areas (Receiving – Receipts Real Time) and (Receiving – Transactions Real Time). Using Sandbox page integ…
-
OTBI Report not showing item with Zero On-HandSummary: OTBI Report not showing item with Zero On-Hand Content (please ensure you mask any confidential information): Team, We have developed OTBI report using subject …Akancha Sinha 11 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management -
Inventory Reservations Query/ReportSummary: Need a report of the information seen in Manage Reservations and Picks (Item, Reserved Quantity, Document Number, Document Line Number) Content (please ensure y…
-
Finding interface values in final tablesHello everyone, can anyone help me? I'm having trouble identifying some fields that are loaded into the interface table to inventory transactions (INV_TRANSACTIONS_INTER…Ivan Torres NTTDATA 21 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
how to add a fiscal document status field in OTBISummary: Hi, we need to add the field fiscal document status from shipping forms to OTBI, there is a away to do this? Content (please ensure you mask any confidential in…Alex Pagliarini - Ninecon 1 view 1 comment 0 points Most recent by Vignesh Rajendhiran-Oracle Inventory Management -
Inventory Valuation OTBI Report Shows Double EntrySummary: An OTBI Report is created for Inventory Valuation according to client's need of parameters. After running the report, output shows double/duplicate entry for Co…
-
How to capture Movement Request Requested Quantity in OTBISummary: Need to capture Movement Request Requested Quantity to OTBI, we have tried with original transaction quantity column in Inventory - Inventory Transaction Real T…Navindu Amarasinghe 32 views 3 comments 0 points Most recent by Navindu Amarasinghe Inventory Management -
revision vs lot for inventory transactionsSummary: What are the pros/cons for using revision functionality in oracle vs using lots? Content (required): Hi, We have a requirement to track item revisions in certai…