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 31 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 22 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 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 81 views 4 comments 2 points Most recent by Kyle Topham-Oracle Product Master Data Management
-
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
-
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 2 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 15 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 6 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 10 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 32 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 9 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 39 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