OTBI
Discussion List
-
SQL Query to get Work Definition and resourcesSummary: Hi, Can anyone provide SQL query which will fetch Work Definition and the Resources linked to it? We have Work Definitions defined in Maintenance Cloud and want… -
list of standard reports related to Maintenance ManagementHello, can someone share a list of the available reports? many of the reports were standard in EBS R12, now I couldn't find them on Cloud. Please advise. Thank you -
How can I track changes on Maintenance Asset Notes?Summary: How can I track changes to Maintenance Asset Notes and add them to the History tab? Content (please ensure you mask any confidential information): Our client wa… -
Create/update Install base asset in ALM whenever the install base asset is created/updated in EBSSummary: We have a requirement to Create/update Install base asset in ALM whenever the install base asset is created/updated in EBS as part of the long term EBS to fusio…
-
query to join CSE_FAILURE_EVENTS with WIE_WORK_ORDERS_BHello Oracle Community, I need help finding a table or view to join the CSE_FAILURE_EVENTS table with the WIE_WORK_ORDERS_B table, rather than using WIE_WO_ASSETS. When …
-
Actual completion dates for a Maintenance work order operationSummary We would like to see actual completion date of each operation. Please let us know how it can be seen ( UI or OTBI) and not planned completion date. Content (requ… -
Table and Column to Track Printed Work Orders via ESS JobSummary: We are running the ESS job to print the Mainteance work order 'Print Maintenance Work Order Details'. I wanted to identify the column which marks the Work Order…Aravinth Elangovan-Oracle 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Maintenance
-
Estimation for Maintenance CostHello, the client requirement is to have an estimation of the Total maintenance Cost (resources + Repair) even before completing the Work order and transfer it to costr …
-
maintenance roadMapSummary maintenance roadMapContent Kindly inform me if you have these information regarding roadmap and newfeature for the Maintenance in 19D and 20AUser_2025-01-31-20-15-32-820 133 views 10 comments 0 points Most recent by Prasanth Senthivel-Oracle Maintenance -
work centerSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Risk Matrix in MaintenanceSummary: During one of the discussions with a client who has several offshore platforms, they wanted to know if Oracle has any solution for Risk Managment and scheduling…
-
Notification to be sent to the maintenance manager to start the work orderHello, can we create a report where we have the start date and system's date, we scheduled every 1 hour for example, and if the system's is very near to the start date b…
-
How to update asset meter fields in all the assets( more than 10,000 assets)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
DFF on "Issue and Return Materials from Inventory" ScreenHi Gurus, Is there any way we can create a DFF on Issue and Return Materials from Inventory in Maintenance Module in Oracle fusion. Need to capture couple of additional …
-
Inability to Retrieve "Available to Transact" Quantities from Table/ViewSummary: The inability to directly retrieve the "Available to Transact" quantity from our database tables or views significantly hampers our reporting capabilities. Accu…mohamed essa 11 views 1 comment 0 points Most recent by Bogdan Barbulescu-Oracle Inventory Management -
How to export the Full Asset details in the existing systemSummary: How to export the Full Asset details in the existing system Content (please ensure you mask any confidential information): As a part of Data Migration, we have …Goopikrishnan Jayaraman-Oracle 11 views 1 comment 0 points Most recent by SRGogula-Oracle Maintenance -
Print Maintenance Work Order Material List ParametersSummary: We want the Work Order To and Work Order From Field to be Mandatory or have the same value if Work Order From is left blank. Is there a way to do this? Content …
-
how to link one Maintenance work order to another work orderSummary: Requirement is to link work order to another work order if that is offshoot of other. Any option other than DFF? Content (please ensure you mask any confidentia…
-
Can we move an asset from one work center to another work centerSummary Can we move an asset from one work center to another work center even if the work orders have been created on the assetContent Hi, Can we move an asset from one … -
Work Order Traveler Report Customization and use standard option to printSummary Work Order Traveler Report Customization and use standard option to printContent Hi Want to know whether we can use customize maintenance work order traveler- (S…
-
How to automatically Create Asset for Non-Serialized ItemSummary: We are looking to auto create Assets for Non-Serialized Item after receiving the RMA Line Content (please ensure you mask any confidential information): We have…
-
I cant add the customized layout in maintenance work orderSummary: Customer wants to add a customized layout that has the logo and other details, The technical consultant changed the Data model with the new logo however the see… -
What table columns from Quality management can be used to join Maintenance table in oracle fusion?Summary: We have a requirement to build a custom BIP report Content (please ensure you mask any confidential information): what column from Quality management table of Q…
-
Where can i find the workOrder Approval report which is to be releasedSummary: where can i identify the below attached notification report Content (please ensure you mask any confidential information): Version (include the version you are …
-
Where are the setup information of Installed Base Asset additional fields stored ?Summary: Via Application Composer, we have defined a number of additional fields for Installed Base Asset object. We need to know via OTBI query wich attribute maps to w… -
Red Flag indicator to display Failed Preventive maintenance Inspection ResultsSummary: We have a requirement for users to be able to identify which Preventive Maintenance failed an Inspection result. This information should be accessible either th…
-
Which Subject Area does Default Maintenance Work Order type and Subtype from Asset page can be foundWhich Subject Area does Default Maintenance Work Order type and Subtype from Maintenance Assets page can be found?
-
How to pass a project parameter to an otbi or bip report from a Maintenance Work order screen?Summary: I want to show a budget report on the work order maintenance screen. The requirement is when a user enters the project number on the work order screen then show…
-
have Maintenance Management this Reports, Dashboards and infolets by deault?Summary: I need to develop with OTBI the next data information objects: Mechanist Availability (Report). MTTR (Infolet) MTBF (Infolet) Maintenance Compliance (Report) Ma… -
Maintenance history of the logical hierarchySummary: When I create a maintenance work order for a child asset within a logical hierarchy, I need it to be reflected in the history of the parent asset. Exist any way…