Category 174
Discussion List
-
DFF details are not found in Install base Subject AreaSummary: By default the DFF on IB will show up in OTBI reporting ? Content (required): I have DFF created on IB asset, When I tried to add the DFF to a OTBI analysis I d…Suresh Kampati 83 views 5 comments 0 points Most recent by Laura Liu Reporting and Analytics for SCM -
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 1 view 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM -
Report showing different output when logging in same environment (With SSO and Without SSO)Summary: Background A customer report is a custom report that shows all parts/items that are appended to a Machine. Parts/items will be included in the report even when …Kamohelo Leqele-Oracle 11 views 1 comment 0 points Most recent by Kamohelo Leqele-Oracle Reporting and Analytics for SCM -
How to increase time-out limit for online reportsSummary: I need to know where to increase the processing time for online reports. We have already increased the extraction limit to 2GB, but when we extract the report w…
-
Oracle fusion INV_MATERIAL_TXNS table's ACCT_PERIOD_ID column not populatedSummary: We are designing a DataWarehouse for fusion SCM and we notice that ACCT_PERIOD_ID column from INV_MATERIAL_TXNS table is not populated Content (please ensure yo…Emel Serpegean-Oracle 145 views 4 comments 0 points Most recent by Emel Serpegean-Oracle Reporting and Analytics for SCM
-
Hide catalog toolbar when call analytic report from ApplicationsSummary: How Hide catalog toolbar when call analytic report from Applications Content (please ensure you mask any confidential information): Version (include the version…Arafat022 55 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
OTBI Procurement - Requisitions Real Time Subject areaSummary: Procurement - Requisitions Real Time Subject area doesn't show Requisition with Source Inventory, Only showing Data for Supplier Source so which Subject area ca…
-
Are there any seeded infolets available for HCM?Summary: I enabled HCM Infolets in Rel 23C. However, it only resulted in a blank HCM infolets page. Are there any seeded infolets available for HCM? If so, how can I ena…
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report.Assem Khaled 2 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
How to increase extraction capacity of a customized report?Summary: I need to extract the report over a 2-month interval, which would give approximately 100 000 lines. Content (required): I created a report with approximately 80…
-
RTF Font not being rendered in PDF outputSummary: RTF Font not being rendered in PDF output Content (required): We are trying to use a specific font in our PO RTF template called Script MT Bold : However when w…
-
Query in BIP report not showing result, what can I do to make it work? (SQL included)Summary: Content (required): Hi, I have created a report containing the receipts made for the selected time period. The report is showing the result when I limit the per…Mariyam129 34 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
OTBI REPORT from Purchase requisition to Invoice paidSummary: Report from Purchase Requisition to Invoice Paid Content (required): We need a report which show a full flow status from PR to purchase order to receipt and fin…Najumah Bibi Abdool Rahman 62 views 2 comments 0 points Most recent by Najumah Bibi Abdool Rahman Reporting and Analytics for SCM
-
Query to Derive tax amount for a purchase orderSummary: Looking for a query to calculate tax amount for a purchase order Content (required): Looking for a query to calculate tax amount for a purchase order Version (i…Ripendra Kumar-Oracle 1.5K views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
how to use BICC for extracting large data from cloudSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):user12941432 22 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Need query to pull item cost details for specific transactionsSummary: Content (required): Business requirement is to pull item cost details for specific transactions from the refurbished SKUs Version (include the version you are u…kalyan gade 13 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Can anyone help me tune the query which i have wriiten to fetch the goods received not invoicedSummary: Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced since its having performance issue. Content (required): select p…Rudraksha Vishnu 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and S&OP?Summary: What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and Sales and Operations Planning? Content (required): What BICCs are…
-
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3…
-
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …User_BEGVH 187 views 3 comments 0 points Most recent by Marc Vermeulen Reporting and Analytics for SCM
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Need corresponding technical information on the R12 views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_VSummary: Looking for the replacement view or table information for the R12 supply chain planning views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_V. Content (required): Curr…Santhi 71 views 2 comments 0 points Most recent by Manojj Basetti-Oracle Reporting and Analytics for SCM
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 201 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor…Lucky Sharma 42 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
BICC PVO for Sales Order and CustomerWe need to extract the data for customers , items and sales orders using BICC. It extract should be used by DW. If you have done these kind of extract, Could you please …Oracletechnofunctional 432 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
How to use BIP schedule trigger.Summary: I want to notify only when the number of detected cases under specific conditions is 1 or more, but please tell me what kind of SQL should be set for the event …Maki,Tomofumi 52 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Is there a table that holds - Reports usage metricsSummary: Is there a table that holds - Reports usage metrics Content (required): Is there a table that holds - Reports usage metrics, we want to understand which reports…Ramesh Devarakonda 31 views 4 comments 0 points Most recent by Ramesh Devarakonda Reporting and Analytics for SCM -
Display "No Record Found" in BI Report with XPT Template if query returns 0 RecordsSummary: Looking for an option to display "No Record Found" in BI Report with XPT Template if query returns 0 Records without Impacting Performance. Content (required): …Karthik Chedella 193 views 0 comments 0 points Started by Karthik Chedella Reporting and Analytics for ERP
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 1.1K views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM