OTBI
Discussion List
-
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 11 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 1 view 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…Matt Lanterman 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 18 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 147 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 User_GJJBJ Product Master Data Management
-
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 76 views 2 comments 0 points Most recent by Vinay Butta 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 33 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 41 views 3 comments 0 points Most recent by Krishna V P-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 62 views 1 comment 0 points Most recent by Krishna V P-Oracle 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…Nathan_T_Lee52 31 views 3 comments 0 points Most recent by Sitanshu-Oracle Product Master Data Management
-
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 3 comments 0 points Most recent by Prasanth Senthivel-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 11 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 13 views 1 comment 0 points Most recent by Swapnil Kashid 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 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 2.7K 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 83 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…