OTBI
Discussion List
-
How to run current effective structure (BOM) explosion reportSummary: I have item structure which has been redlined components and effective-date as future date. I try to run OTBI report to see current structure, not future revisi…
-
OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning valuesSummary: We have. a dashboard that contains an analysis and a prompt. The prompt is based on the following sql query: SELECT 0 s_0, "Product Management - Trading Partner…Hassan El Bouihi-Oracle 31 views 3 comments 0 points Most recent by Wim Bos [MLE] Product Master Data Management
-
Is there any alert or similar thing to notify when a Item created?Summary: Content (required): Hi Friends, Users would like get notified whenever a new Item is created. Is there any alert or similar thing to notify when a Item created?…
-
Can OTBI analysis be triggered based on an event?Summary: We have a requirement to send NIR Completion FYI Notification to users of other modules (Costing, Pricing, Manufacturing etc) so that they can begin their setup…
-
Table Name and Column name required error while writing a CASE Function in OTBI AnalysisSummary: Requirement is to populate the data in a EFF attribute column based on the other column in OTBI analysis. Trying to get condition establish using CASE function.…sudheer.movva 1 view 1 comment 0 points Most recent by Magesh Kesavapillai-Oracle Product Master Data Management
-
OTBI Subject Area/Table to pull the NIR Workflow steps 'Assigned To/Pending with'Content Hi Friends, I need to create OTBI Report/Analysis to pull all the NIRs which are in Definition/Approval step and currently the NIR workflow is pending with whom.…Ram Oduru 41 views 3 comments 1 point Most recent by Ruma Bhatnagar-Oracle Product Master Data Management
-
Item Pack Details Report using OTBIContent Will Subject areas relating to Structures and components real time provide the Item Pack Structure details ? Requirement is to fetch the complete Item Pack struc…Sudheer Movva-193114 1 view 1 comment 0 points Most recent by Magesh Kesavapillai-Oracle Product Master Data Management
-
Item Master MDM in HealthcareContent Hello, Brand new here and still not sure I understand how to review the forums, so sorry if this is an existing topic: We are a healthcare provider system (hospi…User_IBZ1J 3 views 1 comment 1 point Most recent by Shyam Lakshman-Oracle Product Master Data Management
-
Database table's name that contains EFF attributes data for items in a Change OrderContent Hi all, I'm looking for the database table's name that contains EFF attributes data for items in a Change Order. The table EGO_CHANGE_LINES_B seems to contain on…Carlos Benassi 7 views 1 comment 0 points Most recent by ManjuH-Oracle Product Master Data Management
-
In PIM Work Area, Change History is not accessible from Item, change history functionality is not uSummary In PIM Work Area, Change History is not accessible from Item, change history functionality is not user friendlyContent Users can not quickly see the history of a…Saikumar Prabhakar 8 views 3 comments 0 points Most recent by Shyam Lakshman-Oracle Product Master Data Management
-
Spoke System List of ValuesSummary Need to know how to get the List of values for Spoke SystemContent Hello, Does anyone know where/how i can get the List of values for the Spoke System. Any table…User_JXMHE 7 views 1 comment 0 points Most recent by Magesh Kesavapillai-Oracle Product Master Data Management
-
Item descriptions in Another LanguageSummary Item descriptions in Another LanguageContent Hello We have an implementation for LATAM countries and they would like to have different item descriptions in spani…gabriel kinovisques-163562 13 views 1 comment 2 points Most recent by Debalina Maiti-Oracle Product Master Data Management
-
Mass update "Public item flag" on items in Private Item ClassSummary We are in the strange position that our Item Classes are all private but the items within the private classes are shown as "Public". We now need to disable the p…Mark Hartenberg 11 views 4 comments 0 points Most recent by Mark Hartenberg Product Master Data Management
-
Need an example on how to create Cross Reference using import mapSummary CSV file to create a Cross Reference using import mapContent Hi All, Can some one share their csv file to create cross ref using import map. I need to know what …User_JXMHE 11 views 4 comments 0 points Most recent by Robert Edmiston Product Master Data Management
-
What is the best naming convention for Master Org? IMO - Inventory Master org or MAS - Master OrgSummary What is the best naming convention for Master Org? IMO - Inventory Master org or MAS - Master OrgContent Just wanted to ask a quick questions on defining master …
-
Good practices on creating EFF, total number of attributes and attribute groupsContent Hi folks, I'm looking for some guidance from Oracle abou good practices related to number of attributes and attributes groups number. How far can we go creating …Carlos Benassi 16 views 2 comments 1 point Most recent by Carlos Benassi Product Master Data Management
-
How to build a BI report for Non Functional Product Hierarchy CatalogSummary How to build a BI report for Non Functional Product Hierarchy CatalogContent We are planning to defining a Product Hierarchy catalog but not associated to any fu…
-
Is there any OTBI report that I can run to validate the number if Item importedSummary Is there any OTBI report that I can run to validate the number if Item importedContent Hi, I used the FBDI template to load thousands of items. Is there any OTBI…
-
Free Tutorial Videos!Summary Video tutorials to help you be successfulContent The Cloud PLM Advanced Tutorials may provide the guidance you need when you need it. Here are some examples: * I…Kyle Topham-Oracle 12 views 0 comments 2 points Started by Kyle Topham-Oracle Product Master Data Management
-
REST Service for Item EFFSummary unable to get it workingContent Can some one help with below payload to make it working. I am creating Item EFF. My URL is…
-
Implications for deleting an attachment entity from Attachment CategorySummary What is the downside to deleting an attachment entity from a custom Attachment CategoryContent Hello, We have a custom attachment category with the Item and Item…Matt Lanterman 9 views 2 comments 0 points Most recent by Matt Lanterman Product Master Data Management
-
How to obtain a flat bill of material (flat BOM)?Summary Within production information management, is there a way to get an aggregated parts list?Content We have a bill of material that has approximately 700 unique par…Brian Lisiecki 22 views 1 comment 0 points Most recent by Carlos Benassi Product Master Data Management
-
Automatic mechanism to Purge Interface Tables by checking the records countSummary Automatic mechanism to Purge Interface Tables by checking the records countContent Hello, Requirement is to Run the Purge Interface tables job, when the Item int…Aravind Laxmaiah 13 views 1 comment 1 point Most recent by Shyam Lakshman-Oracle Product Master Data Management
-
Multi Row Attribute Group Attributes Enabled for BI not displayed in OTBI AnalysisSummary Multi Row Attribute Group Attributes Enabled for BI not displayed in BI Analysis Subject AreasContent Multi Row Attribute Group Attributes Enabled for BI not dis…Sudheer Movva-193114 10 views 3 comments 0 points Most recent by Magesh Kesavapillai-Oracle Product Master Data Management
-
Role for enabling and editing infoletsSummary Unable to find security role that will allow users to customize, manage, and create new InfoletsContent Hello. What role is needed in BI or in Fusion to allow ac…Matt Lanterman 29 views 2 comments 1 point Most recent by Matt Lanterman Product Master Data Management
-
Capturing Item Images in OTBISummary Capturing Item Images in OTBIContent Hello, We would like to capture the item images on OTBI report. We tried using Product Management - Source System Item Real …Anand Dhinakaran 23 views 8 comments 0 points Most recent by Anand Dhinakaran Product Master Data Management
-
How to Export Item Images from OTBI Analysis to Excel OuputSummary How to Export Item Images from OTBI Analysis to Excel OuputContent Hi, We have Items with images in PIM, We need to export the Item attributes along with Images …
-
Duplicate value returned in EGO_ITEM_EFF_B TableSummary Desire to know what the difference is in the ACD_TYPE meanings when writing a report, and how to choose correct record.Content Hello, Our goal is a custom report…Matt Lanterman 15 views 4 comments 0 points Most recent by Matt Lanterman Product Master Data Management
-
Find item class of an item using BIPContent I am trying to write my own sql using BIP to draw item and item class information. However, it seems there is no key linkage between EGP_ITEM_CLASSES_B and EGP_S…Marcus Tam-142282 9 views 1 comment 0 points Most recent by Shivam Upadhyay Product Master Data Management
-
How can we Hide Operational Attributes from Item Specifications TabSummary We want to hide some Specifications attribute at item level as per user selection.Abhishek Bhatele 23 views 3 comments 0 points Most recent by Carlos Benassi Product Master Data Management