Category 174-2
Discussion List
-
how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real TiSummary: how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real Time? Content (required):n/a Version (include the version you … -
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 9 views 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM
-
How can we create a custom events to trigger the integration flowSummary: How can we create a custom events to trigger the integration flow. if we click a release button for a project the integration need to trigger but i am unable to…Veera venkata satya Ranga Prasad 7 views 0 comments 0 points Started by Veera venkata satya Ranga Prasad Reporting and Analytics for SCM
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…
-
Can we customize the Award Negotiation Spreadsheet?Summary: Is is possible to customize the Award Negotiation spreadsheet? Also , is this report a BIP report in OTBI? If yes can you share the location? If it is not what … -
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 41 views 4 comments 0 points Most recent by Emel Serpegean-Oracle Reporting and Analytics for SCM
-
Is there any way to customize the filters for custom reports in OTM?Summary: I created the filters using the options available in the path: Business Process Automation>Power Data>Document Generation>Reports. The customer wants more flexi…
-
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…
-
Is there a method to import RFQ data from legacy system to Oracle Cloud.Summary: When checked for FBDI option, the template to import only lines is available but not the header or RFQ as a whole. The requirement is to migrate Inprogress RFQs…
-
Do we have Out of the box OTBI report specifically for Production Scheduling?Summary: We need details on the standard Out of the box reports for Production scheduling, any lead would be highly helpful. Content (please ensure you mask any confiden…Vatsala Bharadwaj-Oracle 2 views 0 comments 0 points Started by Vatsala Bharadwaj-Oracle Reporting and Analytics for SCM -
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 1 view 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Please help me to find Location table for procurementSummary: I am trying to find a table which is having Location details showing on Manage Location page. I want to fetch highlighted fields showing in attached image. Curr…Reetika Chaudhary 11 views 1 comment 0 points Most recent by Swapnil Kashid 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…
-
Missing the Attribute Column in FLEX_BI_ItemBaseDFF_VISummary: Content (please ensure you mask any confidential information): using (FscmTopModelAM.EgpItemsPublicModelAM.ItemBaseDFFBIAM.FLEX_BI_ItemBaseDFF_VI) I'm attemptin…
-
Where can I find the equivalent table of Approval Rule conditions?Summary: We are creating a new Approval Rules for Cash Advance and Expense report but it is not successful using the conditions available on the Approval Workflow. We ne…
-
Supplier Address Level Tax Classification CodeSummary: We are trying to determine the Tax classification code field at Supplier Address level in OTBI analysis Content (please ensure you mask any confidential informa… -
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Kurmally 1 view 0 comments 0 points Started by Najumah Bibi Kurmally Reporting and Analytics for SCM
-
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 31 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 72 views 4 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for SCM
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 23A…Ramamurthy Shankarachetty-Oracle 9.4K views 50 comments 37 points Most recent by Anders W. Langholm Reporting and Analytics for SCM
-
Field names in several subject areas are changed. Where to find this in documentsSummary: Field names in several subject areas seem to have been changed as a result of 23B release. We've reviewed the documents and can see no mention of this in any of…Sudhan-Oracle 11 views 2 comments 1 point Most recent by Catherine Raes Reporting and Analytics for SCM
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …
-
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 23 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 22 views 2 comments 0 points Most recent by Ripendra Kumar-Oracle Reporting and Analytics for SCM
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…