OTBI
Discussion List
-
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 13 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 15 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…
-
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 737 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Manufacturing -
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 32 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…
-
How to View the Oracle Manufacturing Seeded Infolets And Get The Queries Behind Them?Summary: How to view details of Manufacturing seeded Infolets? Content (required): We need to edit/view details of oracle seeded infolets, currently we are unable to vie… -
How to create an Excel report which would provide complete information for all Work Definitions?There is a requirement to generate an excel file that would consist of complete information regarding all the active Work definitions in a specific Manufacturing Plant. …
-
Is there a REST webservice to create Work Definitions DFFSummary Looking for a REST webservice to create a work definitions DFFContent Hello, Is there a REST webservice to create Work definitions DFF. if there is can share wit…
-
SCM – Using Manufacturing Cloud’s Library of REST Services, 13 January 2021, 8 a.m PT - Submit QuestContent Submit your questions for the SCM – Using Manufacturing Cloud’s Library of REST Services session to have them answered during the live event. Post your questions…
-
How to prevent closing of work order depends on the PR/PO stausSummary How to prevent closing of work order depends on the PR/PO stausContent Hi Everyone, We are implementing manufacturing process for one of our client and we are us… -
How to link existing SSP PR/PO with work ordersSummary How to link existing SSP PR/PO with work ordersContent Hi, We are implementing the manufacturing module for one of our customer in this we are using PO link with…
-
How to establish relation between OSP PO quantity and WO quantitySummary How to establish relation between OSP PO quantity and WO quantityContent Hi, Currently when we are creating the work order for quantity 1 it is creating a PO for…
-
Unable to view work order number in purchase requisition screenSummary Unable to view work order number in purchase requisition screenContent Hi, We are using PO link to work order process to one of our inventory organization, when …
-
How PO requested delivery derived while creating OSP PO?Summary How PO requested delivery derived while creating OSP PO?Content Hi, Currently when we are creating an OSP PO the requested delivery date on the PO is current dat…