OTBI
Discussion List
-
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 82 views 3 comments 0 points Most recent by Mohit_Raj Product Master Data Management -
Default values from Fusion Cloud is not showing in OTBISummary: We are using Oracle Transactional Business Intelligence (OTBI) to generate reports from Fusion PLM. However, when we attempt to generate reports for attributes …
-
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 1.5K views 2 comments 0 points Most recent by Ramaraj M Product Master Data Management -
Can Trading Partner data "Rel. Desc." "Rank" "Type" and "Rel. Stat." be displayed in OTBI?Summary: Can the Trading Partner data "Relationship Description" "Rank" "Type" and "Relationship Status" be displayed in OTBI? Content (please ensure you mask any confid…
-
How to display new EFFs in BI reports?Summary: I have made new EFFs in PIM to see datas in BI reports. So I marked the BI Enabled check-box from setup and maintenance, but still cannot display them in the re…Nano Kanazawa 41 views 4 comments 0 points Most recent by Nathaniel.Wilcox Product Master Data Management
-
How To Manually Retrieve Database Query for BICC VO Through BI UISummary: How To Manually Retrieve Database Query for BICC VO Through BI UI Followed the steps given in (Doc ID 2513701.1). But when we click on ISSUE SQL getting error C…
-
Unable to remove datastore from Offering in BICCSummary: BICC, Unable to remove the existing PVO from the offering Content (please ensure you mask any confidential information): Version (include the version you are us…
-
Could you recommend vulnerability scanning tools for BIP, OTBI, and OIC (To Integrate with CI/CD)?Summary: Could you recommend vulnerability scanning tools for BIP, OTBI, and OIC that can be integrated with CI/CD pipelines? Content (please ensure you mask any confide…Kalyan_Duggineni 11 views 0 comments 0 points Started by Kalyan_Duggineni Product Master Data Management
-
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 2 comments 0 points Most recent by Harish Batana-Oracle Product Master Data Management
-
how can I join MSC_TRADING_PARTNER_SITES with EGP_TRADING_PARTNER_ITEMSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get Header Columns in a BIP Report Export in Camel case?Summary: When creating a BIP Report, the header columns specified in our data model are in camel case. However, when we export the report in CSV format, these header col…
-
Query to Get Item Number, Creation Date, Receipt Routing, and OrganizationSummary: what is the query to get item number, creation date, receipt routing, and organization? Content (please ensure you mask any confidential information): Version (…
-
How to create report that show item's list price update historyI can check list price update history of each item by doing the following step: Navigator: Product management > manage items 1. Search item number 2. Click on item numbe…
-
How to identify Parent Buy Items from BOM Structure?Summary: We have no. of BOMs for our Manufacturing and need to identify Standard Buy Items and Parent Buy Items (not child Buy Components under a parent Buy Item Structu…
-
What is the Subject Area to fetch Item Additional Attributes (Descriptive Flexfield)Summary: I am developing OTBI report to validate Item Impot - post Item Import validation. Able to get all Item attributes except Additional attributes (DFF) Could Anyon…Jayaharan Krishnamurthy 23 views 3 comments 0 points Most recent by Sam Bandara Product Master Data Management
-
How to migrate user folder from one user to other having OTBI and BI reportsSummary: We are changing username for some of the users and we need a way to migrate there reports from old name folder to ne username folder Reports and Analytics Conte…Aakanksha0395 21 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
What are the privileges needed for a role in order to import using item batches and import maps?What are the privileges to be added to a role if the user needs to use Manage Import Maps and Manage Item Batches and load data related to Item Relationships.Sainatha B 14 views 1 comment 0 points Most recent by MANALI BISWAS-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…User_2025-02-04-16-34-29-464 29 views 3 comments 0 points Most recent by Avijit Vidyarthi Product Master Data Management -
Table used for Project Financial ManagementSummary: Can i please know the table we are storing Project Management details in. Content (please ensure you mask any confidential information): Navigator > Project Man…Priyansha Singh 1 view 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
Innovation Management - Retrieve Attachment DataSummary: We are working in the Innovation Management - Proposal module. Under the Attachment tab of Proposal module, user can upload image attachment(s) by Catergory (e.…Poh Chie 11 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management -
Innovation Management - how to customize the DefaultReportDataModel and DefaultProposalReportSummary: We are working on the Innovation Management - Proposal module, and the Proposal Action Menu consists of Export function which using the default data model and d…Poh Chie 11 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management
-
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…
-
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 165 views 5 comments 0 points Most recent by Sam Samaddar Product Master Data Management
-
I cannot avoid multiplexing when joining item and category tables.Hello The following SQL multiplexes up to the item organizations record. CAT.CATEGORY_NAME AS CATEGORY_NAME and CAT.CATEGORY_CODE AS CATEGORY_CODE multiplexes on the bas…
-
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 29 views 5 comments 0 points Most recent by Leen Mardini 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 5 comments 0 points Most recent by Faizhan.Tanvir Product Master Data Management
-
Trading Partner Web Service: REST or SOAPSummary: Need url for creating Manufacturer type trading partners Content (please ensure you mask any confidential information): Hi All, Please share url of SOAP or REST…MohitChandane 42 views 3 comments 0 points Most recent by UserKV-Oracle Product Master Data Management
-
PDH: Schedule Product Upload JobSummary: Hi Friends, I want to Inactivate Product Hub item when suppliers associated with those items are inactive. I have created BI report extracting such Item and sta…
-
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.…
-
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 UserKV-Oracle Product Master Data Management