OTBI
Discussion List
-
In which table Derived related items are stored in Oracle Fusion CloudHi , In which table Derived Related Items details are stored in Oracle Fusion Cloud. I have already checked EGP_ITEM_RELATIONSHIPS_B table. Thanks and Regards, SanmatiSanmati Patil-Oracle 89 views 1 comment 0 points Most recent by Krishna -Oracle Product Master Data Management -
What is the table name to capture/extract audit enabled seeded attribute for example user item type?Summary: What is the table name to capture/extract audit enabled seeded attribute information for example user item type? We have checked EGPSYSTEM_ITEMS_B table but it …
-
Adding 'Trading Partner Type' filtering data "Product Management - Trading Partner Item Real Time"Summary: Filtering Trading Partner details alone by Trading Partner Type is not working as expected with "Product Management - Trading Partner Item Real Time" SA. Issue:…Santhi Vakacharla-Oracle 14 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management
-
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 11 views 1 comment 0 points Most recent by Swapnil Kashid 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 3.9K views 2 comments 0 points Most recent by Sitanshu-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 114 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…
-
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 45 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 31 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 38 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 58 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 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 41 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 38 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 155 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…User_2025-02-04-16-34-29-464 83 views 2 comments 1 point Most recent by User_2025-02-04-16-34-29-464 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 35 views 8 comments 0 points Most recent by Anand Dhinakaran Product Master Data Management