Costing
Discussion List
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin… -
Data not showing albeit correct rolesSummary: Data is not showing whilst creating an OTBI analysis Content (required): Data is not showing whilst creating an OTBI analysis for the Unit Cost Dimension althou…
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…Sushan Peiris 168 views 8 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 321 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…Rohit Kumar-266502 184 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 72 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Cost Accounting Distribution TablesContent Hi Team, Can anyone help me with table name for all the transaction types and the cost distribution details present on attached screen. Regards Nidhi...Nidhi Chhajed 22 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 24 views 3 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM -
Maximum Number of Records for a BICC ExtractSummary Maximum Number of Records for a BICC ExtractContent We're looking at using BICC to extract cost and inventory data for reporting because of the volume of records…
-
Receipt Accounting reportSummary Tables for 'Expense Adjustment' and 'Invoice Price Adjustment'Content Hi guys, I am trying to create a custom BIP report based on receipt accounting. However, I …Raja Haroon Habib 43 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
How Charge type (Freight, Duty...) is calculated on a POSummary How Charge type (Freight, Duty...) is calculated on a PO in Landed Cost ManagementContent I need to show per unit cost of Charge (Freight, Duty, Material, Miscel…
-
Inventory Transaction and Costing - Cross Subject AreasSummary I need an OTBI Analysis that includes Inventory Transaction Real Time and Costing Item Cost Real TimeContent Hi, I created a cross subject area Analysis to displ…Marysol Torres 62 views 4 comments 0 points Most recent by Marysol Torres Reporting and Analytics for SCM
-
Inventory OnHand Balance ReportSummary Inventory OnHand Balance ReportMahgoub S.Mohamed 62 views 1 comment 0 points Most recent by User_XW1ZL Reporting and Analytics for SCM
-
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 36 views 1 comment 2 points Most recent by Mauricio Chavarry-132851 Reporting and Analytics for SCM
-
How to get inventory reports?Summary How to get inventory reports?Content Hello, we would like to get the following reports: - List of items per inventory organization with attributes. - Structures …Mario Cura Barba 118 views 3 comments 0 points Most recent by Mario Cura Barba Reporting and Analytics for SCM -
Total Purchases for Tier I SuppliersSummary I need to create an analysis that shows total purchases for specific suppliers.Content I need to create an analysis that shows purchase order line details such a…
-
R13 SCM and Procurement OTBI subject area Description documentationSummary R13 SCM and Procurement OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides use…