OTBI
Discussion List
-
I need to return the latest component subinventory and locator in a work definition in an OTBI queryI'm looking to extract out the the latest version of a work definitions, the components within a work definition and the subinventory and locators. I curently have an OT… -
How to Enable Seeded Landing Page Infolet in Redwood UI for Presales ActivitySummary: We are currently working on enabling Redwood UI for presales-related activities and would like to leverage the seeded landing page infolets to provide users wit…
-
Work Order Header Descriptive Flexfield not appearing in the OTBI Subject AreaThe descriptive flexfield segment is BI enabled , But after deploying the flexfield and running ESS: Import Oracle Fusion Data Extensions for Transactional Business Inte…
-
Work Order material consumption across task in Project based SCM ManufacturingSummary: Requirement to consume items on Work order from different task apart from the Work Order task . (WO header task : Project A task 1, inventory available under Pr…Mohit Sahni - Mastek 13 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Manufacturing
-
How to Query Work Order Picks Pick Confirmed with zero QuantityWe are using Oracle discrete work order Picks. There are situations where a pick is created but picker does not find the quantity in the bin due to inventory issues. Pic…
-
Which table stores material transaction history of a work order?Summary: Which table stores material transaction history of a work order? Content (required): Hi, there! I'm building a report to get material transaction history becaus…Andres De la Ossa-Oracle 998 views 3 comments 0 points Most recent by Jose Zuria-Oracle Manufacturing -
Scheduled Work Order Traveler print process causing duplications on shop floorWe currently have an ESS job scheduled to run every hour to print all work orders in the "Released" status. The problem we are having is that it will print duplicates if…
-
Work definition query with Resource and item quantity and priceDear All, We have requirement to build a report which contains below columns Work definition name FG item (Finished goods) All RM item (Raw Material) Resources Item pric…
-
I am facing issue to generate a SO using Oracle FBDI file.Summary: I am facing issue to generate a SO using Oracle FBDI file. The Error showing below. "####[2025-01-29T07:46:49.851+00:00] [INFO] Batch Name: Wk03.2025 Source Sys…Gaurav.Deshpande90 12 views 1 comment 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
Subject areas lacks in Actual quantity usage for resources an componentsSummary: Hello, I need obtain the input work order cost as report using analysis For example, into operation 10, I used the item E010281 with a total cost of 2,768.379 p…Diego Zegarra 21 views 2 comments 6 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Cost of all make items under work orderSummary: We have a work definition for Assemble item#117474-03. Under those assembly items(Explode the bom), there are multiple make items containing the work definition…
-
We are trying to access OTBI Reports on Screen Cloud using RSS Feed optionSummary: Not able to access the OTBI reports in the screencloud or any RSS platform. Content (please ensure you mask any confidential information): RSS Feed Version (inc…Adithya Koushik 21 views 2 comments 0 points Most recent by Adithya Koushik Reporting and Analytics for ERP
-
Can we create an OTBI Audit report for work definitionSummary Audit policies setup was enabled for work definition but we didn't find any audit subject area for work definition so can you please confirm whether we can devel…Balamurugan Kulandhaivel 11 views 7 comments 0 points Most recent by Balamurugan Kulandhaivel Manufacturing
-
Join between PER_USERS and POZ_SUPPLIERSHi, we need help in creating a custom query and we need to join POZ_SUPPLIERS to the PER_USERS table. Can you please help assist? Thank you.
-
After a work order is completed, how can I query the data of the sales order and wo order details?Summary: I need SO details and WO details after completing the WO, which the direct link will be removed. And is that query available in BICC PVO? Content (please ensure…
-
Is there any report for outside processing work orders?Summary: Are there any out-of-box reports for information on outside processing work orders? Content (please ensure you mask any confidential information): Need a report…
-
How to Show Serial item attributes in Product Genealogy pageSummary: Hello All, Please let me know if you have implemented solution to show Serial item attributes in the Product Genealogy page. One of my customer wants to see the…Vishnuvarth Subramanian-Oracle 14 views 1 comment 0 points Most recent by Raj C -Oracle Manufacturing
-
Is there any way to check the work order start and completion date changes done on the work order .Summary: There has been many revisions that are seen in OSP Purchase order that are seen triggered automatically. To check this we want to see if there are any date chan…P.S.Nikhitha Muduliar 11 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Manufacturing
-
Which areas are affected when time zone is changed in the Manage Inventory Organization parametersWhich areas in the oracle fusion cloud are affected when time zone is changed in the Manage Inventory Organization parameters
-
How to add custom report when performing Release and Pick Materials in Manage Work OrdersSummary: We have a requirement where we want to trigger a custom BIP report along with Print Pick Slip report when we perform Release and Pick Materials in Manage Work O…
-
SQL query for Work Order to Customer DetailsIs there a query that can be used to join Work Order details (WIE_WORK_ORDERS_B) to customer details (HZ_PARTIES)? Thank you!
-
Requirement to Refresh OTBI Report at regular intervalsSummary: Is it possible to refresh an OTBI Report at regular intervals so that it does not require intervention from the operator? Content (please ensure you mask any co…
-
Reports and Analytics AccessSummary: Production Supervisor Role unable to see Reports and Analytics under tools Content (please ensure you mask any confidential information): Production Supervisor …AShekhar 33 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to add Batch quanity in Work DefinitionHi, We have more than 3000 work definitions in our application. means that for each and every work definition, we must add the batch quantity. is there any methods or sp…
-
Resource hour load difference report on work orders and work definitionsSummary: The business needs a report or query that shows the differences in resource hours declared in work orders and what was defined in the work definitions Content: …JOSE.GONCALVES.4458 12 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Manufacturing
-
I have a requirment to upload PDf file on released work order at header level using Rest API.Summary: I have a requirment to upload PDf file on released work order at header level using Rest API. I can find get attachment rest APIs but not able to find any API f…
-
How to use/review Oracle predefined data models ?Summary: Hi, I am facing an issue which is i am not able to see some of the predefined reports/data models. For instance "Work order material transaction e-record report…
-
Need subject area and column details for Start / Stop operationSummary: When start and Stop operations are used on Work Order - Operation, need to capture these duration in OTBI Analyses. Which column can be used to fetch this info?…Meera K Ganapathy-Oracle 31 views 4 comments 0 points Most recent by Meera K Ganapathy-Oracle Manufacturing
-
Is there a REST/SOAP API to get Production Transaction History Details?Summary: Looking for a REST/SOAP Webservice to get the Review Production Transaction History Details. Content (required): Is there a REST or SOAP service that can be use…
-
WIE_MA_MTL_ASSIGNMENTS.EXPECTED_QUANTITY source table?Summary: Is the source table for WIE_MA_MTL_ASSIGNMENTS.EXPECTED_QUANTITY INV_SUPPLY? If so which SUPPLY_TYPE_CODE values are considered? If not, which table is the sour…