OTBI
Discussion List
-
Subtab Content Not Found in Subject Area of BI PublisherSummary: I am working on the Product Management >> Innovation Management. In the Subtabs Region, there is a Content - which consists of Text Editor for user to enter for… -
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.… -
I need to add a role or privilege to a user.Summary: I need to add a role or privilege to a user that can let him see an OTBI report was made related to items we have on our system. Content (required): Version (in…Abdelaziz Safwat 1 view 0 comments 0 points Started by Abdelaziz Safwat Product Master Data Management
-
how can get sql with catalogs and category in oracle fusionSummary: how can get SQL with catalogs and categories in oracle fusion need to generate a query but these catalogs and categories not are assigned to itemscgleonch 286 views 2 comments 0 points Most recent by Sitanshu-Oracle Product Master Data Management -
How to add Two Subject Areas in one Analysis in OTBISummary: How to add Two Subject Areas in one Analysis in OTBI Content (required): How to add Two Subject Areas in one Analysis in OTBI Version (include the version you a…Srinivasa Rao Pavuluri 31 views 1 comment 0 points Most recent by Nakul Buradkar-Oracle Product Master Data Management
-
Need list of Item EFF attributes used in existing OTBI reportsSummary: We need to identify the Item EFF attributes not being used in any of the OTBI report defined in the instance and disable the BI enabled flag for them. Since we …sudheer.movva 51 views 2 comments 0 points Most recent by sudheer.movva Product Master Data Management
-
How to Add Two Entries in one Criteria from the same Subject AreaSummary: Hi Team, We are trying to add two Entries in to one Criteria in the same Subject Area. Kindly help us how to add. 1. Document Review Cycle Info->Business Proces…Srinivasa Rao Pavuluri 51 views 0 comments 0 points Started by Srinivasa Rao Pavuluri Product Development
-
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…
-
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 61 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 51 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…
-
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 71 views 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 21 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 28 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 16 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 31 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 21 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 Started by Kyle Topham-Oracle Product Master Data Management -
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 29 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 73 views 1 comment 0 points Most recent by Carlos Benassi Product Master Data Management