OTBI
Discussion List
-
SQL for fetching Item, Item Class, Attribute and Attribute Group etc.Summary: SQL for fetching Item, Item Class, Attribute and Attribute Group etc. Content (required): SQL for fetching Item, Item Class, Attribute and Attribute Group etc. …Goopikrishnan Jayaraman-Oracle 957 views 1 comment 0 points Most recent by Goopikrishnan Jayaraman-Oracle Product Master Data Management -
PDH Item PublicationSummary: PDH 'Item Publication' process Content (required): Hi, I am testing the 'Item Publication' process in product hub. I have done the spoke system setup using - ht…Sravanthi Kollapudu-Oracle 41 views 3 comments 0 points Most recent by Manoj Bagul-Oracle Product Master Data Management -
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 53 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?…Ashish_Kumar 11 views 1 comment 0 points Most recent by Wim Bos [MLE] Product Master Data Management -
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…
-
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 22 views 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 22 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 35 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 48 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 17 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 14 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 42 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 20 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 36 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 32 views 0 comments 2 points Most recent by Kyle Topham-Oracle 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 122 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
-
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 70 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 33 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 55 views 4 comments 0 points Most recent by Matt Lanterman 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 78 views 3 comments 0 points Most recent by Carlos Benassi Product Master Data Management -
How to change the default item attribute value at master levelSummary How to change the default item attribute value at master levelContent Hi, When we are creating items few item attribute values are defaulting from master level. … -
Unable to view all item attributes under specification tab in manage itemsSummary Unable to view all item attributes under specification tab in manage itemsContent Unable to view all item attributes under specification tab in manage itemsI hav…